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

Reply via email to