Apache OpenOffice (AOO) Bugzilla – Issue 93591
custom thousands separator (number format) does not function above 999999
Last modified: 2013-01-29 21:48:05 UTC
When setting a custom thousands separator (e.g. a space: # ##0), the cell does not separate at the 10^6, 10^9 etc., wheras the default thousands separator ( a dot) does. I will submit a sample spreadsheet as soon as i can.
Created attachment 56314 [details] space as thousands separator in number format
In actual version 3.1.1 this works Number 1234567890 with format # ##0 is 1 234 567 890.
I am sorry raal, but in version 3.1.1 (Dutch, O/s Windows XP) and in version 3.1.0 (Dutch, linux) it does not work. 1234567890 with format # ##0 gives 1234567 890.
I have Czech version, probably language specific. OS WinXP.
I confirm the behaviour. Set to Feature, since I didn't study the specs (yet) to see if it works as designed ..