Bug 60442 - FORMATTING Currency format does not turn red when number is calculated
Summary: FORMATTING Currency format does not turn red when number is calculated
Status: RESOLVED DUPLICATE of bug 60215
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected) release
Hardware: x86-64 (AMD64) Windows (All)
: medium normal
Assignee: Not Assigned
Depends on:
Reported: 2013-02-07 19:47 UTC by Daniel Luebke
Modified: 2013-03-17 17:02 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:


Note You need to log in before you can comment on or make changes to this bug.
Description Daniel Luebke 2013-02-07 19:47:44 UTC
When you format a currency cell the number usually turns red if the amount is negative. Up to 3.4 this worked also if the number is calculated. However, after having upgraded to 4.0 the negative numbers appear black iff the cell contains a formula but work correctly if the cell is the number directly.
Comment 1 fortunato_chrome 2013-02-12 03:23:10 UTC
Also noticed this error since upgrade.

But when formulas with negative values change/recalculated, the become correctly colored as red.
Comment 2 Rainer Bielefeld Retired 2013-02-13 07:17:53 UTC
NOT reproducible with Server Installation of "LibO rc   -  GERMAN UI / German Locale  [Build ID: 7545bee9c2a0782548772a21bc84a9dcc583b89)]"  {tinderbox: @6, pull time 2013-01-31 11:30(?)} on German WIN7 Home Premium (64bit) with separate  new User Profile:

When into a Currency formatted cell I type "=-1-1" <Enter> the result "-2€" will be shown in red.

But I think reporter forgot to mention the detail that that problem appears when he opens the document? Very rare problem description, but probably DUP of "Bug 60215 - FILEOPEN: FORMATTING of value-related color, localized decimal separator and Currency VIEWING need Complete Recalculation"

Please feel free to reopen this Bug if you find evidence that we have an independent issue here  (for example because the fix for the other bug does not work for you).

*** This bug has been marked as a duplicate of bug 60215 ***
Comment 3 Andrzej Petrykowski 2013-03-17 17:02:20 UTC
this bug appears in Linux edition too. Even if corrected and negative numbers are displayed in red, then file is saved, closed and reopened these negative numbers are not displayed in red