https://bugs.documentfoundation.org/show_bug.cgi?id=117575
Bug ID: 117575
Summary: Number formats: Thousands separator should be space if
not preceded by a digit.
Product: LibreOffice
Version: 6.1.0.0.alpha1+ Master
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
In a number format, "(?)works as the (#) but adds a space character to keep
decimal alignment if there is a hidden non-significant zero." [from the help
text].
However (?) does not play well with thousands separators:
With a fixed-width font such as Courier, using a format like "????????0.00"
will nicely display all values below 1 Billion with decimal points aligned.
However with number format "???,???,??0.00" the decimals are aligned but
smaller values have extra commas hanging out in space to the left.
Please see attached demo file.
SUGGESTED SOLUTION: Make thousands separators (e.g. comma in the United States)
format as a space when there is no actual digit to the immediate left. This
will make it work nicely with "?", which already formats as a space when there
is nothing significant to show.
Steps to Reproduce:
1. Open attached "formatdemo.ods" file
Actual Results:
Extraneous commas are shown for smaller values using format code
"???,???,??0.00".
Expected Results:
Would like the non-significant commas to become spaces.
Reproducible: Always
User Profile Reset: No
Additional Info:
User-Agent: Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:59.0) Gecko/20100101
Firefox/59.0
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
