https://bugs.documentfoundation.org/show_bug.cgi?id=153812

            Bug ID: 153812
           Summary: Custom Number Format in Calc is not Retained
           Product: LibreOffice
           Version: unspecified
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs@lists.freedesktop.org
          Reporter: catmik2001-...@yahoo.co.uk

Custom Number Formatting (user defined) in a CALC spreadsheet such as:-

[GREEN][$£-809]#,##0.00;[RED]-[$£-809]#,##0.00

which formats positive numbers as GREEN or negative numbers as RED works fine.

It is possible to use more than the standard colours using COLORX e.g.

[COLOUR22][$£-809]#,##0.00;[RED]-[$£-809]#,##0.00

This colours positive numbers in this case as DARK GREEN and this is displayed
in the spreadsheet when applied.
However when the spreadsheet (ODF) is saved, this formatting is not displayed
and the custom format is lost.

-- 
You are receiving this mail because:
You are the assignee for the bug.

Reply via email to