Bug 55584 - EDITING: Conditional formatting lost after deleting a column
Summary: EDITING: Conditional formatting lost after deleting a column
Status: RESOLVED DUPLICATE of bug 54842
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
3.6.1.2 release
Hardware: All All
: high critical
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2012-10-03 15:28 UTC by Zirneklītis
Modified: 2012-10-07 05:38 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:

Attachments
Spreadsheet with conditional formatting and formulas. (15.77 KB, application/vnd.oasis.opendocument.spreadsheet)
2012-10-03 15:28 UTC, Zirneklītis 		Details
The same attachment with correct MIME (15.77 KB, application/vnd.oasis.opendocument.spreadsheet)
2012-10-03 15:31 UTC, Zirneklītis 		Details
Conditional formatting disappears when deleting a line (19.02 KB, application/vnd.oasis.opendocument.spreadsheet)
2012-10-03 22:23 UTC, Guillermo 		Details
Show Obsolete (2) 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 Zirneklītis 2012-10-03 15:28:31 UTC 
Created attachment 68045 [details]
Spreadsheet with conditional formatting and formulas.

Step 1. Open the attached file "CondForm.ods". Delete the column 'U'. Save the the file. Close LibreOffice. -> LibreOffice crashes.

Step 2. Open the file created in Step 1. -> The conditional formatting is partly damaged.

Tested with:

LibreOffice 3.6.1.2 Build ID e29a214 / Fedora 14 x64
LibreOffice 3.6.1.2 Build ID e29a214 / Windows 7 x64

The RC version 3.6.2.2 ID da801e6 crashes while opening the attached file!


The attached file can be opened and edited with LibreOffice 3.5.2.2./Windows 2000, Apache OOo 3.4.1/Windows XP; LibreOffice 3.5.6.2/ Fedora 14 x64.

All of them even manage to open the file saved by LibreOffice 3.6.1.2. Even more – the conditional formatting is shown as in original file.
Comment 1 Zirneklītis 2012-10-03 15:31:43 UTC 
Created attachment 68046 [details]
The same attachment with correct MIME
Comment 2 Guillermo 2012-10-03 22:23:17 UTC 
Created attachment 68060 [details]
Conditional formatting disappears when deleting a line

I believe this might be teh same sort of problem. I had a large spreadsheet with conditional formatting in one column. It worked great for a long time. After some changes it suddenly went crazy, and one of the effects I see is Conditional Fomratting disappearing when I delete a line.

I made the spreadsheet as small as possible and to show this. If a line is deleted the Conditional formatting is deleted on my I5 notebook with Win7-64 bits.
Comment 3 Rainer Bielefeld Retired 2012-10-04 16:56:08 UTC 
Comment on attachment 68046 [details]
The same attachment with correct MIME

dup. document
Comment 4 Rainer Bielefeld Retired 2012-10-07 05:36:59 UTC 
Seems to be a DUP of "Bug 54842 - Conditional formatting lost when delete any row or column", but I can not test because of new Crash problem mentioned by reporter, for what I submitted separate "Bug 55710 - CRASH FILEOPEN particular .ods with Conditional Formatting"

@Zirneklītis
Please reopen if fix for Bug 54842 does not work for your problem

*** This bug has been marked as a duplicate of bug 54842 ***
Comment 5 Rainer Bielefeld Retired 2012-10-07 05:38:54 UTC 
Comment on attachment 68060 [details]
Conditional formatting disappears when deleting a line

@Guillermo
Without complete description of your problem the attachment is more worrying than helping. With what Verison do you see the problem? Immediately or after close reopen? So I obsolete your sample document for now. Please feel free to open a separate bug with this sample (and a more complete description due to  <http://wiki.documentfoundation.org/BugReport>)