Bug 62221 - FORMATTING: using format with color on cell with formula, color is lost when spreadsheet saved/re-opened until cell content changes
Summary: FORMATTING: using format with color on cell with formula, color is lost when ...
Status: RESOLVED DUPLICATE of bug 60215
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected) release
Hardware: Other Windows (All)
: high major
Assignee: Not Assigned
Whiteboard: BSA
Depends on:
Reported: 2013-03-12 11:30 UTC by nigel
Modified: 2013-03-15 14:23 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

test spreadsheet as described above (7.76 KB, application/vnd.oasis.opendocument.spreadsheet)
2013-03-12 11:30 UTC, nigel

Note You need to log in before you can comment on or make changes to this bug.
Description nigel 2013-03-12 11:30:41 UTC
Created attachment 76390 [details]
test spreadsheet as described above

Problem description: 
If a cell contains a formula and a format is applied which includes color. The save  the spreadsehet & reopen & there is no color. color reappears when cell content is changed.

Steps to reproduce:
1. Create new sheet. Enter 2 in A1, 1 in A2 and =A2-A1 in B2
2. Format cell B2 with e.g. #,##0.00 ;[RED](#,##0.00)  
3. close sheet & reopen. 
4) edit A1 to 3 & color reppears

Current behavior: color lost on save & reopen

Expected behavior: color restored on reopen

Operating System: Windows 7
Version: release
Comment 1 Thomas van der Meulen [retired] 2013-03-12 16:54:43 UTC
Hello nigel,
I CANNOT reproduce this bug running LibreOffice on Windows 8

In version we know there is a problem with saving necatice numbers in red but that is fixit/working on it in

so please check you version.(help --> about libreoffice )

if it please set the status to mark as Duplicate of bug 60215 

if it is on please tell me. and I wil try again harder.

Thank you,
Comment 2 Thomas van der Meulen [retired] 2013-03-13 06:23:33 UTC
ow Nigel I tested again on Mac osx 10.6.8 on LibreOffice and I can see the bug, I will set it to new and ask some one of this is a dublicate of bug 60215.
Comment 3 Thomas van der Meulen [retired] 2013-03-15 14:23:35 UTC

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