Created attachment 112490 [details]
screenshot and the .ods file
(See the attached screenshot and the .ods file)
The correct calculated value (in red) should be:
3551,6282571 (this is correctly shown in the format dialog)
...but depending on the column width (!) it is displayed in the spreadsheet as:
1,6283 (notice that the first numbers "355" are omitted)
...or depending on the column width with some other wrong value.
Using some narrower or wider column width displays the correct value in the spreadsheet.
Hi @matti, thanks for repporting.
Works for me with:
Build ID: 8fd0451cc08e6a5310bed8b7ad1c46b93c1c6889
Build ID: 7a728f882b5a66d2184dcc2fbcf291b9dbba88fe
TinderBox: Win-x86@42, Branch:libreoffice-4-3, Time: 2015-01-16_11:05:28
LibreOffice 4.2.3 displays the correct spreadsheet numbers in the same setup (OS X 10.10.1).
But LibreOffice 4.3.4 and 4.3.5 omit significant numbers:
Depending on the column width 3551,6282571 is displayed as:
Setting Preferences > LibreOffice Calc > Calculate > Limit decimals for general number format ON also displays the correct value for THAT SAVED spreadsheet.
Another workaround is to use some other format that GENERAL in the Format > Cells... > Numbers dialog.
unable to reproduce with LO .3.5.2, win7
I don't see any left truncation in my master build on OSX 10.10.1
Build ID: 15db0307fe6429238be72612cccd4a1df5e1e97c
As for rounding on the right hand side, this functions as designed methinks
I see no problem in
Build ID: 3a87456aaa6a95c63eea1c1b3201acedf0751bd5
on OSX 10.10.1 either
@Matti : are you using a 32bit version of LO on OSX ?
What locale are you using ?
Setting to NEEDINFO, until requested information is provided.
Set back to unconfirmed once information has been provided.
Please verify if the option:
... LibreOffice Calc/General/Use printer metrics for text formatting
If not please try resetting the user profile, sometimes solves strange issues.
(In reply to Alex Thurgood from comment #7)
> @Matti : are you using a 32bit version of LO on OS X ?
Hmm I see no option to choose the bitness in OS X 10.10.1 with LibreOffice 18.104.22.168 on my Mac mini (Late 2009).
> What locale are you using ?
Finnish (but using Default - English (USA) makes no difference).
(In reply to m.a.riosv from comment #8)
> Please verify if the option:
> ... LibreOffice Calc/General/Use printer metrics for text formatting
> change something.
Yes, that fixed the issue! Thanks!!
Was the cause caused by my default printer HP LaserJet P1005?
> If not please try resetting the user profile, sometimes solves strange
That makes no difference. And I was testing on a fresh install or under a guest user anyway.
I tried this with another newer Mac running OS X 10.10.1 (MacBook Pro Retina) with the LibreOffice 22.214.171.124 default settings:
There the incorrect values are displayed VERY briefly before changing to the correct values. I had to watch out this very carefully and even then didn't always notice it when the file opens.
(In reply to matti.haveri from comment #10)
> (In reply to m.a.riosv from comment #8)
> > Please verify if the option:
> > ... LibreOffice Calc/General/Use printer metrics for text formatting
> > change something.
> Yes, that fixed the issue! Thanks!!
Then seems a duplicate of 78503.
Please if you are not agree, reopen it.
*** This bug has been marked as a duplicate of bug 78503 ***
This might be the same bug although in my case only certain column widths produced it:
The numbers were displayed correctly with some bigger _or_ smaller column widths.
I don't mind if the numbers are obscured with ## characters in too narrow columns.
In my case the decimal comma was misplaced so, depending on the column width, the displayed number was 70-2000 times more than it really was.
I had prepared the spreadsheet in an older version of LibreOffice and after upgrading to v4.3.4 I noticed an incorrect result in one cell (7800 * 0,45 = 1,6 WHAT?!). Now I'm a bit nervous to trust the displayed numbers.
Created attachment 112607 [details]
How it appears to me
Created attachment 112608 [details]
Test .ods file
Looks fine for me.
Please take a look on the options in Menu/Tools/Options/LibreOffice/View - Graphics output.
I can turn off Anti-Aliasing in LibreOffice > View - Graphics output, but it does not make any difference for the misplaced decimal comma.
LibreOffice Calc > General > Use printer metrics for text formatting ON
LibreOffice Calc > Calculate > Limit decimals for general number format ON
do fix the issue (Locale setting Finnish -- otherwise default settings).
Please @matti.haveri, comment in the duplicate bug: