Created attachment 75302 [details] Spreadsheet with negative calculated cells not correctly displayed on load. Steps to reproduce: 1. Create a spreadsheet. 2. Place a negative number in cell A1. 3. Set cell B2 to "=A1". 4. Select both cells, open Format Cells and enable "Negative numbers red". 5. Save and close the spreadsheet. 6. Reopen the spreadsheet. 7. Change the value of cell A1 to another negative number. Expected: From step 4 on, the symbols in cells A1 and B2 are always red. Actual: In step 6 cell B2 is displayed with black text. Note 1: If the format specifies parenthesis for negative numbers, that format is displayed correctly on load. Note 2: In the attached spreadsheet, cells B3 and B4 have the same format but they are display differently until cell A1 is changed. I'm not sure whether that is the same issue or a different issue.
Version 4.1.0.0.alpha0+ (Build ID: 9601a571d42b0199bdccf2256fc8be82e14af8a) Date: Mon Feb 18 23:22:17 2013 +0100 Bodhi Linux 2.2 ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ New (confirmed) Minor (can slow down high quality work) Medium (setting at medium as we are aware of these kinds of issues but this one in particular is new) @Markus - you told us to let you know about these ones, import cache problem as ctrl + shift + f9 solves it
Thank you for reporthing this bug, I can reproduce this bug running LibreOffice 4.0.0.3 and 4.0.1.1rc on Mac osx 10.6.8
*** This bug has been marked as a duplicate of bug 60215 ***