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)
Version:
(earliest affected)
4.0.1.2 release
Hardware: Other Windows (All)
: high major
Assignee: Not Assigned
URL:
Whiteboard: BSA
Keywords:
Depends on:
Blocks:
 
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:

Attachments
test spreadsheet as described above (7.76 KB, application/vnd.oasis.opendocument.spreadsheet)
2013-03-12 11:30 UTC, nigel 		Details
View All Add an attachment (proposed patch, testcase, etc.)

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: 4.0.1.2 release
Comment 1 Thomas van der Meulen [retired] 2013-03-12 16:54:43 UTC 
Hello nigel,
I CANNOT reproduce this bug running LibreOffice 4.0.1.2 on Windows 8

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

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

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

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

Thank you,
pje335
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 4.0.2.1 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 ***