https://bugs.freedesktop.org/show_bug.cgi?id=78503
--- Comment #8 from [email protected] --- This might be the same bug as 88593 although in my case only certain column widths produce it. The numbers are displayed correctly with some bigger _or_ smaller column widths. I don't mind if the numbers are obscured with ## characters in too narrow columns but in my case I got totally incorrect values when LibreOffice 4.3.4 and 4.3.5 omit significant numbers and misplace the decimal comma (see the attached screenshot and sample file). The decimal comma is misplaced so, depending on the column width, the displayed number is 70-2000 times more than it really is. So, depending on the column width the calculation 7830 * 0,45 = 3551,6282571 is displayed as the following variations: ,628 1,6283 51,62826 3552 (correct) 3551,6 (correct) 3551,63 (correct) 3551,62826 (correct) I had prepared the spreadsheet in an older version of LibreOffice and after upgrading to v4.3.4 I noticed the incorrect result in one cell. Setup: Mac mini (Late 2009), OS X 10.10.1. Locale setting Finnish -- otherwise default settings. Resetting the user profile does not help. BTW, on a MacBook Pro Retina 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. On the other hand, LibreOffice 4.2.3 displays the correct spreadsheet numbers on the Mac mini. I have found some workarounds to fix the issue: 1. LibreOffice Calc > General > Use printer metrics for text formatting ON 2. LibreOffice Calc > Calculate > Limit decimals for general number format ON 3. Format > Cells... > Numbers > Number > Format: use some other setting than General -- You are receiving this mail because: You are the assignee for the bug.
_______________________________________________ Libreoffice-bugs mailing list [email protected] http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
