Bug 60598 - FORMATTING: cell with formula not well formated after re-open
Summary: FORMATTING: cell with formula not well formated after re-open
Status: RESOLVED DUPLICATE of bug 60215
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected) release
Hardware: All All
: medium normal
Assignee: Not Assigned
Depends on:
Reported: 2013-02-10 16:42 UTC by jailh
Modified: 2013-11-18 12:06 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:

Test sheet (11.72 KB, application/vnd.oasis.opendocument.spreadsheet)
2013-02-10 16:42 UTC, jailh
Format dialog-box (78.06 KB, image/png)
2013-02-10 16:44 UTC, jailh
Test sheet (11.72 KB, application/vnd.oasis.opendocument.spreadsheet)
2013-02-10 16:49 UTC, jailh

Note You need to log in before you can comment on or make changes to this bug.
Description jailh 2013-02-10 16:42:24 UTC
Created attachment 74548 [details]
Test sheet

Bug (?) found in a sheet which was working in 3.6.

A cell with a custom formating ("[GREEN]0;[RED]-0") is not formated when the file is opened. (Its my wanted format, but it breaks wit other formats to).

If any cell used by the formula is changed, the formating is done.

But after saving/closing/re-opening, the formating is lost.

To reproduce the problem : 

Create the file (a test file is attached to the bug)
 - Create a new sheet
 - type "1" in A1
 - type "-1" in A2
 - type =A1 in B1
 - type =A2 in B2
 - format all these cells with the custom format : Number -> "[GREEN]0;[RED]-0"
 - save the file
 - Close the file

Observe the bug : 
 - Re-open the file 
 - See that numbers in col B are not colored
 - Change the values in col A (you can re-use the same values)
 - See that the numbers in col B are now colored
 - Save file
 - Close
 - Replay this scenarii forever
Comment 1 jailh 2013-02-10 16:44:48 UTC
Created attachment 74549 [details]
Format dialog-box
Comment 2 jailh 2013-02-10 16:49:52 UTC
Created attachment 74550 [details]
Test sheet
Comment 3 Jorendc 2013-02-10 17:21:53 UTC
Thanks for reporting!
I can confirm this behavior. Pressing ctrl + shift + F9 to recalculate resolve this problem.

Because a recalculation resolve this issue, I think this is due a Import Cache problem. Therefore I put Markus, Kohei and (Eike?) in CC.

Kind regards,
Comment 4 Markus Mohrhard 2013-02-10 18:51:50 UTC

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