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
View All Add an attachment (proposed patch, testcase, etc.)

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 ***