https://bugs.documentfoundation.org/show_bug.cgi?id=172206
--- Comment #7 from ady <[email protected]> --- The problem is that Calc does not really accept "fully customized" number formats, but only modifications based on Language-Country formats. That kind of customization is a frequent request. That means that in the cell format (ctrl+1) you have to first set a Language-Country that matches both the thousand separator and the decimal separator that you want to use for that cell. If you want to use English (USA) for the cell, but the space character as thousand separator and dot/period as decimal separator, then you will have to set the number of decimal places "by hand", manually modifying the number format code. For example, starting from: #" "###" "###" "###" "###" "###" "###" "###" "###" "###" "###" "##0.00 If you want 3 decimal places: #" "###" "###" "###" "###" "###" "###" "###" "###" "###" "###" "##0.000 The only way to solve the real problem is to allow real customization of separators, independent of the original ones for the Language-Country. Having said that, the amount of places to the left of the decimal separator in attachment 207195 (34 places) does not make much sense for spreadsheet tools. You could still show that amount of places, but the less-significant places will not be considered for calculations. This is orthogonal to the report. Considering the current limitations of Calc, I guess that the report will eventually be marked as WF. -- You are receiving this mail because: You are the assignee for the bug.
