https://bugs.documentfoundation.org/show_bug.cgi?id=108338
Bug ID: 108338
Summary: Numeric formatting using the _ does not work
Product: LibreOffice
Version: 5.3.2.2 release
Hardware: All
OS: NetBSD
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: p...@whooppee.com
Description:
In the "other" spreadsheet program, I would be able to apply a format of
'#,##0_._0_0' to request that space for a decimal point and two fractional
digits be reserved, but not printed; with horizontal-alignment of "right" the
above format would align correctly with numbers formatted at '#,##0.00'.
However, with Calc, the _ formatting directive doesn't seem to work. It allows
me to create a user-defined format, but when the document is saved and then
reloaded, all formats with the _x type of directive are replaced with modified
formats that have trailing quoted spaces instead of the _x directive(s). And
the number of spaces does not seem to be correct for ensuring vertical
alignment.
Steps to Reproduce:
1.Format a number using the _0 (or any other _x)
2.Save document, exit program
3.Restart program, open document, observe formatting changes
Actual Results:
format string for affected numeric fields is changed to include " " (number
of spaces varies).
Expected Results:
Specified formatting (with the _ directive) should be retained.
Alternatively, if the conversion to " " formatting is absolutely essential, at
least the amount of space being inserted should correspond to the intended
behavior (ie, proper alignment).
Reproducible: Always
User Profile Reset: No
Additional Info:
According to Mike Kaganski, he has reproduced this on 5.3.3.2 and requested
that I file this bug report.
User-Agent: Mozilla/5.0 (Windows NT 6.3; WOW64; rv:53.0) Gecko/20100101
Firefox/53.0
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
