https://bugs.documentfoundation.org/show_bug.cgi?id=170670
Bug ID: 170670
Summary: FORMATTING Calc mangles single "-" in number format
code after file is closed and then re-opened
Product: LibreOffice
Version: 25.8.4.2 release
Hardware: x86-64 (AMD64)
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
I have the following number format code defined for a cell:
[>0]#,##0_);[<0](#,##0);"-"_)
This works as expected and when the cell has a zero value a single "-" is
displayed followed by the space for a right-hand parenthesis.
However when the file is closed and then re-opened the number format code has
been replaced with the following:
[>0]#,##0_);[<0](#,##0);- "_)"
which obviously does not give the desired format for a zero value.
Strangely when this number format code is used:
[>0]#,##0_);[<0](#,##0);"--"_)
no such mangling occurs when the file is closed and re-opened.
--
You are receiving this mail because:
You are the assignee for the bug.