Download it now!
Bug 80272 - Grid lines messed up when formula returns error message in Chinese
Summary: Grid lines messed up when formula returns error message in Chinese
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
4.2.4.2 release
Hardware: All All
: medium major
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: CJK
  Show dependency treegraph
 
Reported: 2014-06-20 08:14 UTC by Kevin Suo
Modified: 2015-07-15 05:14 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Kevin Suo 2014-06-20 08:14:20 UTC
Our Simplified Chinese libreoffice community members had been suffering from the grid-line-messed-up issue in Calc, but it was difficult to find the steps to 100% reproduce this bug behaviour. But now, we have finally found the following easy steps to reproduce.

Steps to Reproduce:

1. Switch to Simplified Chinese or Tranditional Chinese UI;

2. Input "=VLOOKUP()" in A1;
Note: In formula you input is without any parameter, so the formular returns the error value "错误:511" (Err: 511) in Chinese.

3. Click on a few cells in column A.
>> You can observe that the row label (1,2,3,4,...) spaces have changed a little bit. (This is the bug)

4. Input some other formulas which will return errors, in some other cells. For example, you can input: =VALUE(), =MATCH(), =YEAR()...
>> You can observe that the grid lines are messed up, and even worse if you input more formulas.

More info:
When is in English UI, Japanese UI and French UI I do not reproduce this bug behaviour. But in both Simplified Chinese and Trandisional Chinese UI, I reproduce this bug behaviour.

OS: Windows XP SP3
Version: 4.3.0.1
Build ID: 67f5430184326974072b65403ef1d9d934fc4481
Our commutiy members has said this behaviour first reproduced in 4.2.4.2.
Comment 1 Kevin Suo 2014-06-20 08:15:43 UTC
Added bug 79395 as see also. It may be related.
Comment 2 yanjingtao 2014-06-20 08:20:35 UTC
The same in Fedora 20 Build ID: 4.2.4.2-18.fc20.

I found the font-size of "错误" is a little bigger than ":511".
Comment 3 Kevin Suo 2014-06-20 08:24:45 UTC
(In reply to comment #2)
> The same in Fedora 20 Build ID: 4.2.4.2-18.fc20.
> 
> I found the font-size of "错误" is a little bigger than ":511".

Font size issue may not be related to this bug, so should not be discussed within this bug (In fact I also noticed the font-size issue in linux. The workaround is to set the default style a 0.5 larger font size for Westen Chars than Chinese)

I my testing, those font sizes are the same for me in Windows XP, while I also reproduce the bug. So they are not related.
Comment 4 Kevin Suo 2014-06-24 13:26:44 UTC
I also reproduce in Ubuntu 14.04 x86, version 4.3.0.1.
Set OS to ALL.
Comment 5 Kevin Suo 2015-07-15 05:14:39 UTC
Same as bug 79395, works in version 5.0.0.3. Marked as WORKSFORME.