https://bugs.freedesktop.org/show_bug.cgi?id=63950

          Priority: medium
            Bug ID: 63950
          Assignee: [email protected]
           Summary: FORMATTING: Negative numbers displayed in black
                    although format says red
          Severity: normal
    Classification: Unclassified
                OS: Windows (All)
          Reporter: [email protected]
          Hardware: Other
        Whiteboard: BSA
            Status: UNCONFIRMED
           Version: 4.0.2.2 release
         Component: Spreadsheet
           Product: LibreOffice

Created attachment 78506
  --> https://bugs.freedesktop.org/attachment.cgi?id=78506&action=edit
A small spreadsheet that shows the incorrect behaviour.

Problem description: 

When I open the attached spreadsheet file all the numbers in column G are
displayed in black. The format specifications is # ##0,00;[RED]-# ##0,00
The contents of the cells are calculated with a formula. If numbers are entered
directly they are displayed correctly. 

Steps to reproduce:
1. Open the attached file
2. Select column G
3. Copy the column (Ctrl-C)
4. Paste the column (Ctrl-V)
5. Voilà! Negative values are now red!

If the file is saved, closed and reopened all numbers are black again.
Operating System: Windows XP
Version: 4.0.2.2 release

-- 
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

Reply via email to