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: [email protected]
Reporter: [email protected]
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.