Issue 77816 - Calc - thousands separator placement bug for values less than 1
Summary: Calc - thousands separator placement bug for values less than 1
Status: CLOSED FIXED
Alias: None
Product: Calc
Classification: Application
Component: formatting (show other issues)
Version: OOo 2.2
Hardware: PC All
: P3 Trivial with 1 vote (vote)
Target Milestone: ---
Assignee: ooo
QA Contact: issues@sc
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2007-05-25 17:35 UTC by psymar
Modified: 2013-08-07 15:12 UTC (History)
2 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---


Attachments
Example .ods file (6.59 KB, application/vnd.oasis.opendocument.spreadsheet)
2007-05-25 17:36 UTC, psymar
no flags Details
Illustrating screenshot (2.29 KB, image/png)
2007-06-06 18:59 UTC, kpalagin
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description psymar 2007-05-25 17:35:12 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.
Comment 1 psymar 2007-05-25 17:36:13 UTC
Created attachment 45404 [details]
Example .ods file
Comment 2 crolidge 2007-05-26 13:42:51 UTC
Confirmed this error in OO 2.2 in Windows XP
Comment 3 helenrussian 2007-06-06 16:55:09 UTC
Confirmed this error in OO 2.0.4 in OpenSUSE 10.2
Comment 4 kpalagin 2007-06-06 18:57:02 UTC
Confirming with 2.2 on WinXP - see attached screenshot.
Comment 5 kpalagin 2007-06-06 18:59:22 UTC
Created attachment 45698 [details]
Illustrating screenshot
Comment 6 frank 2007-07-09 14:08:30 UTC
Hi Eike,

seems to be yours.

Frank
Comment 7 aoo-bugger 2009-06-12 23:02:03 UTC
works fine now in 3.1
-> can be closed
Comment 8 kpalagin 2009-06-13 05:22:25 UTC
Verified - fixed.
I just love self-fixing bugs.
Comment 9 ooo 2009-06-15 11:40:02 UTC
Yep :)  probably was fixed with the re-implamentation of grouping code for issue
53498.