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.

Reply via email to