https://bugs.freedesktop.org/show_bug.cgi?id=63380
Priority: medium Bug ID: 63380 Assignee: libreoffice-bugs@lists.freedesktop.org Summary: FORMATTING: Calc Formatting: Not all negative numbers appear in red color Severity: normal Classification: Unclassified OS: Linux (All) Reporter: karat...@yahoo.gr Hardware: Other Whiteboard: BSA Status: UNCONFIRMED Version: 4.0.1.2 release Component: Spreadsheet Product: LibreOffice Created attachment 77738 --> https://bugs.freedesktop.org/attachment.cgi?id=77738&action=edit A sample .ods file In my Calc spreadsheets I use to format cells so the negative numbers appear as red (Format/Cells.../Category: Numbers and then I check “Negative numbers red”). I had no problem with all negative numbers using Calc up to version 3.6.5.2. In Calc 4.0.x, if the negative number is the result of a function (i.e. the subtraction of two cells), when Ι save the file and open it again, the color of the number turns to black (default). [See Calc_4.0.x_Sample.ods and Calc_4.0.x_Sample.ods.pdf] Strangely the problem appears only if Ι use the .ods file type. If i save the same file as .xls and open it again, all negative numbers have red color. [See Calc_4.0.x_Sample.xls and Calc_4.0.x_Sample.xls.pdf] I confirmed the problem using Calc 4.0.x in several O.S. (Mint13/MATE - Mint14/Cinnamon - Ubuntu12.04/Unity - Win7 Gr Home Premium). Operating System: Linux (Other) Version: 4.0.1.2 release -- You are receiving this mail because: You are the assignee for the bug.
_______________________________________________ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs