Bug 54508 - FORMATTING: Calc lose conditional formatting after save and close
Summary: FORMATTING: Calc lose conditional formatting after save and close
Status: RESOLVED DUPLICATE of bug 54464
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
3.6.1.2 release
Hardware: Other All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard: BSA
Keywords:
Depends on:
Blocks:
 
Reported: 2012-09-04 19:46 UTC by keyopen
Modified: 2012-10-04 09:21 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:

Attachments
In the spreadsheet, with the previous versions of Calc, I applied a formatting conditional, but now it is not more present. (18.23 KB, application/vnd.oasis.opendocument.spreadsheet)
2012-09-04 19:46 UTC, keyopen 		Details
In this file are present conditional formatting (55.05 KB, application/vnd.oasis.opendocument.spreadsheet)
2012-09-05 17:54 UTC, keyopen 		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 keyopen 2012-09-04 19:46:00 UTC 
Created attachment 66628 [details]
In the spreadsheet, with the previous versions of Calc, I applied a formatting conditional, but now it is not more present.

Problem description: Formatting conditional

Steps to reproduce:
1. In Calc you can build, for example, a table in a spreadshit and assign a conditional formatting to his cells.
2. Save the spreadsheet
3. Close Calc
4. Reopen the spreadshit with Calc
5. The previous conditional formatting is loose

Current behavior:
Calc lose conditional formatting after save and close

Expected behavior:
To see the conditional formatting after a spreadsheet is re-opened.

Platform (if different from the browser):
              
Browser: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.7; rv:15.0) Gecko/20100101 Firefox/15.0
Comment 1 Markus Mohrhard 2012-09-05 16:50:54 UTC 
Your test file does not contain conditional formats. You should attach a document that opens fine in another version and that is now incorrectly opened.
Comment 2 keyopen 2012-09-05 17:54:30 UTC 
Created attachment 66692 [details]
In this file are present conditional formatting

As request I attach the whole spreadsheet that contains conditional formatting and in the previous versions was opened and showed correctly.
Comment 3 Jean-Baptiste Faure 2012-09-18 04:47:50 UTC 
(In reply to comment #2)
> Created attachment 66692 [details]
> In this file are present conditional formatting
> 
> As request I attach the whole spreadsheet that contains conditional formatting
> and in the previous versions was opened and showed correctly.

Could you explain how this file is incorrectly opened by LO 3.6 ?
When I open your file with LO 3.6.2.1, I see the conditional formattings that are visible in LO 3.5.6

Best regards. JBF
Comment 4 thaonja 2012-10-04 09:02:20 UTC 
Hello

I also have the same problem.
I use LO 3.6.1.2 (build ID:e29a214, language:Japanese).
It seems that LO 3.6.1.2 erases conditional formattings by the following operations.
1) Open a spreadsheet file by LO 3.6.1.2.
   This file was made by LO 3.5 and contains conditional formatting.
2) Copy a sheet that contains conditional format.
3) Edit the sheet that is copied.
4) Save and close this file.
5) Re-open this file.
   The sheet that was copied loses all conditional formattings.
   Original sheet keeps all conditional formattings.

Thanks
Comment 5 Lawrence R. Steeger 2012-10-04 09:21:06 UTC 
I believe this is a duplicate of 54464.

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