Problem happen when import text with Chinese

users
#1

Dear All:

    When import text with Chinese in Calc , the Chinese will overlap with
others as picture attached.
Is there any method to avoid ? or this is a bug.

    i found
<http://nabble.documentfoundation.org/file/n4012628/screenshot_145.bmp> an
company claim they had fix this on http://blog.openoffice.com.tw/?p=100

Thanks for your help & time. :slight_smile:

Regards from
Scott

#2

There was recently a thread with Japanese in Calc. Have a look in the nabble mail. Maybe there is a solution.
If I am not completely mistaken I made a test with Japanese in Calc myself but don't recall if I reported a bug or not.

"import" means copy and paste from another application like Writer, correct?

#3

Hi :slight_smile:
I think the Japanese thread might have been a llllloooonnnngggg time ago
now. Depends how recently things have to be to count as being recent. I
guess.

I did a quick search of Nabble and got
http://www.libreoffice.org/get-help/nabble-mailing-list-interface/
but it looked like the most recent posts were about the 2011 earthquake!

Regards from
Tom :slight_smile:

#4

Thanks Tom:

  Ihe picture which i posted was made this afternoon, Taiwan time. Maybe i
did not explain it clearly.
The Libeoffice version is 3.6.2, and the encoding of Chinese is utf-8. No
matter is utf-8, unicode, big5 it happens the same.

oh, "Import file" means open a text file, and set delimiter of fixed width
column.

// Scott

#5

I made a test I did before (maybetooo long time before) and
    reported today a bugBug55954-EDITING: copypaste issues
        - Japanese text from writer into calcWhat I remember from my previous test( I used LO 3.5.4 or 3.5.5)is thatI got what is called in Japanese "mojibake" and can be
        imaged as wingding symbols, thus unreadable characters. This
        time with LO 3.5.6.2 at least all characters where correct.For Scott to compare what I did in the test with what he did
        during his import process here the bug report:beginProblem
        description:copypaste of Japanese text from writer to calc shows
        inconsistency
        opf the paste results depending on the paste methode (pasting
        directly into cells or pasting into the input line). Details are
        to
        be seen in the attached files.
Steps
          to reproduce:

1.
          copy a Japanese text in writer

2.
          paste directly into a cell in calc creates a too small font
          neither
          matching the font in writer nor default in calc, color is
          black

3.
          paste into the input line creates the same font result but
          color is
          gray.

4.
          when increasing the font size in calc overlapping of Japanese
          characters occure depending on the width of the column (this
          can be
          seen in the attached calc sheet when changing the column
          width)

Current
          behavior:As
          described aboveThe
          same issue should appear with all double byte word languages
          (Japanese, Chinese, Korean, Thai etc...)

Expected
          behavior:when
          pasting Japanese from writer into calc the font should be as
          in
          writer or as the default font in calc (type, size, color)

Platform
          (if different from the browser):

LO
          3.5.6.2 / XP SP3

Browser:
          Mozilla/5.0 (Windows NT 5.1; rv:16.0) Gecko/20100101
          Firefox/16.0end
<!--
    @page { margin: 2cm }
    P { margin-bottom: 0.21cm }

#6

I made a test I did before (maybetooo long time before) and
    reported today a bugBug55954-EDITING: copypaste issues
        - Japanese text from writer into calcWhat I remember from my
previous test( I used LO 3.5.4 or 3.5.5)is thatI got what is called in
Japanese "mojibake" and can be
        imaged as wingding symbols, thus unreadable characters. This
        time with LO 3.5.6.2 at least all characters where correct.For
Scott to compare what I did in the test with what he did
        during his import process here the bug report:beginProblem
        description:copypaste of Japanese text from writer to calc shows
        inconsistency
        opf the paste results depending on the paste methode (pasting
        directly into cells or pasting into the input line). Details are
        to
        be seen in the attached files.
Steps
          to reproduce:

1.
          copy a Japanese text in writer

2.
          paste directly into a cell in calc creates a too small font
          neither
          matching the font in writer nor default in calc, color is
          black

3.
          paste into the input line creates the same font result but
          color is
          gray.

4.
          when increasing the font size in calc overlapping of Japanese
          characters occure depending on the width of the column (this
          can be
          seen in the attached calc sheet when changing the column
          width)

Current
          behavior:As
          described aboveThe
          same issue should appear with all double byte word languages
          (Japanese, Chinese, Korean, Thai etc...)

Expected
          behavior:when
          pasting Japanese from writer into calc the font should be as
          in
          writer or as the default font in calc (type, size, color)

Platform
          (if different from the browser):

LO
          3.5.6.2 / XP SP3

Browser:
          Mozilla/5.0 (Windows NT 5.1; rv:16.0) Gecko/20100101
          Firefox/16.0end
<!--
                @page { margin: 2cm }
                P { margin-bottom: 0.21cm }

I can confirm Dr R O Stapf's remark above, i e, copying text to Writer
from, e g, Japanese or Chinese newspapers and then copying a portion of
that text and pasting into a cell in Calc results, depending upon the
length of the text, in cell boundaries being exceeded. This running Version
3.6.0.1 (Build ID: 360m1(Build:101)) of LibreOffice on 64-bit Ubuntu 12.04.
The web browser used to copy from the sources was Firefox Nightly 19.0a1
(2012-10-13)....

Henri

#7

感謝します。
Reinhold

#8

如何致し致して！。。。

Henri

#9

'Fixed Width' means just that. You manually set the width:

#10

NoOp, thanks for your information.

Readin your comment I understand I was a bit off of the issue which originated this thread. Especially your comment on the "Fixed Width" is very interesting. I did not consider such an import process.

Your comment on the situation of copying Chinese text into calc let's me think that there is an improvement going in the right direction. In 3.5.4 or 3.5.5 unreadable characters appeared. In 3.5.6 the characters were correct but the fonts are wrong and there was overlapping. In 3.6.2 it seems to be even better.

However, did you make a test by copying directly into cells (what you did) AND copying into the input line? It would be interesting to also know if the result is exactly the same or if there is a difference as in 3.5.6.

#11

<snip>

Thanks for hopping in here, Gary ! I rechecked in Calc on Version 3.6.0.1
(Build ID: 360m1(Build:101)) with the texts I myself had pasted in
previously and then followed the procedure you outlined above using Scott's
text, but the results were the same, i e, the right lateral boundary of the
cells in question were violated in each case. I then tried writing in a
Chinese text directly in a cell, using SCIM 1.4.9, but no change ; again
the text did not wrap. Thinking that this problem couldn't be limited to
Chinese and Japanese texts, I tried writing in an English text with the
same discouraging results. I then went to Format → Cell → Alignment →
Properties and ticked the box entitled «Wrap text automatically» and
repeated the procedure - as I suspected, the text, no matter whether the
language in which it is couched, is wrapped. Thus, on my machine at least,
not wrapping is the default, but can be achieved, as seen above, by ticking
the «Wrap» box. What I cannot do, however, is to set «Wrap text
automatically» as the default so that texts are automatically wrapped when
pasted or written in ; rather, I have to tick the box for every individual
cell. Here below an illustration of what I see when the box is and not
ticked, respectively....

[image: Infogad bild 1]

How can I set Calc so that «Wrap text automatically» becomes the default
?...

Henri

#12

Hi :slight_smile:
At the top of each column is a greyish box with the columns reference number in it.  Similarly for each row.  Clicking on one selects the whole column, or row so you can format entire columns or rows at a time.

At the top-left corner above the top row and before the first column is an empty greyish box.  Click on that to select the entire sheet.

There is probably a way to set your formatting as default for every new sheet, perhaps something to do with styles?  If so then you might be able to apply the style to existing sheets and ones from other people as well as new sheets. 
Regards from
Tom :slight_smile:

#13

Hi :slight_smile:
At the top of each column is a greyish box with the columns reference
number in it. Similarly for each row. Clicking on one selects the whole
column, or row so you can format entire columns or rows at a time.

At the top-left corner above the top row and before the first column is an
empty greyish box. Click on that to select the entire sheet.

There is probably a way to set your formatting as default for every new
sheet, perhaps something to do with styles? If so then you might be able
to apply the style to existing sheets and ones from other people as well as
new sheets.
Regards from
Tom :slight_smile:

Thanks, Tom ! The colour schema is a little different on my set up - orange
instead of greyish, but if I click to select rows and/or columns, I can
hten right-click and format all the cells in that row, column, or the whole
sheet respectively. Nice to know !...

Henri