Bug 63950 - FORMATTING: Negative numbers displayed in black although format says red
Summary: FORMATTING: Negative numbers displayed in black although format says red
Status: RESOLVED DUPLICATE of bug 60215
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
4.0.2.2 release
Hardware: Other Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard: BSA
Keywords:
Depends on:
Blocks:
 
Reported: 2013-04-26 08:35 UTC by Seved Torstendahl
Modified: 2013-04-26 15:49 UTC (History)
0 users

See Also:
Crash report or crash signature:


Attachments
A small spreadsheet that shows the incorrect behaviour. (9.72 KB, application/vnd.oasis.opendocument.spreadsheet)
2013-04-26 08:35 UTC, Seved Torstendahl
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Seved Torstendahl 2013-04-26 08:35:04 UTC
Created attachment 78506 [details]
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
Comment 1 Thomas van der Meulen [retired] 2013-04-26 15:49:25 UTC
Hello Seved, Thank you for your bug report,
this is a well known bug so I will set it as a dublicate of bug fdo#60215

*** This bug has been marked as a duplicate of bug 60215 ***