Apache OpenOffice (AOO) Bugzilla – Issue 77816
Calc - thousands separator placement bug for values less than 1
Last modified: 2013-08-07 15:12:27 UTC
- Open a new spreadsheet. - Enter a value between -1 and 1 in any cell; 0 works too. The bug will not occur if the value rounds to -1 or 1, however (e.g. if you put in .9999999999) I've confirmed this bug with .1, .01, 0, -.1, .437, -.9876, etc., and I believe it will occur with all values that are between -1 and 1 after rounding to the chosen number of decimal places. - Right-click the cell, choose "Format Cells", set Leading Zeroes to at least 4 (it also works with 6 or 7 or 9, probably more), set Decimal Places to at least 1 (2 also works, probably more), and check "thousands separator". This can also occur with currency formats -- that's where I discovered the bug. - Click OK. - The last "thousands separator" will be after the hundreds place, not the thousands, and any before that will be after the hundred-thousands, hundred-millions, etc., instead of the millions, billions, etc.
Created attachment 45404 [details] Example .ods file
Confirmed this error in OO 2.2 in Windows XP
Confirmed this error in OO 2.0.4 in OpenSUSE 10.2
Confirming with 2.2 on WinXP - see attached screenshot.
Created attachment 45698 [details] Illustrating screenshot
Hi Eike, seems to be yours. Frank
works fine now in 3.1 -> can be closed
Verified - fixed. I just love self-fixing bugs.
Yep :) probably was fixed with the re-implamentation of grouping code for issue 53498.