[Libreoffice-bugs] [Bug 108338] New: Numeric formatting using the _ does not work

[bugzilla-daemon at bugs.documentfoundation.org]

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 at lists.freedesktop.org
          Reporter: paul at 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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20170605/5878a1e6/attachment.html>