Bug 61271 - FORMATTING: Negative numbers red does not work on file load for calculated cells
Summary: FORMATTING: Negative numbers red does not work on file load for calculated cells
Status: RESOLVED DUPLICATE of bug 60215
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
4.0.0.3 release
Hardware: Other All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2013-02-22 11:41 UTC by B.J. Herbison
Modified: 2013-11-19 15:31 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments
Spreadsheet with negative calculated cells not correctly displayed on load. (8.26 KB, application/vnd.oasis.opendocument.spreadsheet)
2013-02-22 11:41 UTC, B.J. Herbison
Details

Note You need to log in before you can comment on or make changes to this bug.
Description B.J. Herbison 2013-02-22 11:41:13 UTC
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.
Comment 1 Joel Madero 2013-02-22 17:19:25 UTC
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
Comment 2 Thomas van der Meulen [retired] 2013-02-22 17:23:00 UTC
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
Comment 3 Markus Mohrhard 2013-02-22 17:30:46 UTC

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