I have an old file where there is some cells with contitional formatting. When Isaved it, at the reopen I didn't see that formatting. I made conditional formatting again,but at the reopen of file, after a save, the formatting was losta again.
In the reopened file, the list of formatting, in" Manage" menu, it's empty.
Can you please attach a test document?
Created attachment 66997 [details]
Original Excel spreadsheet wtih conditional formatting in A6
Created attachment 66998 [details]
188.8.131.52 ods document created by saving as ods
Cell A6 is losing its formatting.
Created attachment 67116 [details]
184.108.40.206 ods document created by saving as ods
Attachment 66997 [details]: Original Excel spreadsheet wtih conditional formatting in A6
An original Excel spreadsheet with conditional formatting on cell A6
Attachemnt 66998: 220.127.116.11 ods document created by saving as ods
The output of 18.104.22.168 created by saving as ods. Conditional formatting is gone!
Attachemnt: 22.214.171.124 ods document created by saving as ods
The output of 126.96.36.199 created by saving as ods. Conditional formatting is Ok!
@Lawrence R. Steeger:
Thank you very much for the good test files!
Tested with the reporter’s test files on Mac OS X 10.6.8 (Intel).
1) With LibreOffice 188.8.131.52, BOTH .ods files (both the one created with LibO 184.108.40.206 and the one created with 220.127.116.11) open correctly, i.e., the cell A6 is displayed in red, and the “Conditional formatting” dialog window (accessible from the menu via “Format > Conditional Formatting > Conditional Formatting...“) correctly lists the rule to make the cell contents red if the value of the cell is = 5.
2) With LibreOffice 18.104.22.168 (Build ID: e29a214), as the user said, only the .ods file created with LibO 22.214.171.124 opens correctly, but the .ods file created wth LibO 126.96.36.199 misses all conditional formatting for cell A6: the cell text is black, and the “Conditional formatting” dialog window (accessible from the menu via “Format > Conditional Formatting > Conditional Formatting...“) does not list any formatting rules.
So this is (at least partially) a FILEOPEN problem introduced in LibreOffice 3.6.0 or 3.6.1, therefore I add the keyword “regression”.
3) But, good news: LibreOffice 188.8.131.52 (Build ID: ba822cc; the 1st pre-release of the new 3.6.2 version) opens again both files .ods files correctly, i.e. with the conditional formatting of cell A6, just like LibreOffice 184.108.40.206.
So the regression is IMHO already fixed in LibreOffice 220.127.116.11, therefore I set the status of this bug report to RESOLVED/WORKSFORME.
@Lawrence R. Steeger:
You can test yourself whether LibreOffice 18.104.22.168 solves the problem or not if you download that version from
Feel free to reopen this bug report if you can still reproduce the problem with LibreOffice 22.214.171.124. Thank you!
*** Bug 54508 has been marked as a duplicate of this bug. ***
It is still reproducible with Version 126.96.36.199 (Build ID: 360m1(Build:2)) on Kubuntu 12.10
Saving the Excel file and reopen it loses the conditional formatting.
Created attachment 69828 [details]
Cell with conditional formating
It is not related to Excel. When i create a conditional formatting in a cell, and then use autofill, the conditional formatting is copied to the cells. After saving and reloading, the conditional formatting in the other cells is gone
Created attachment 69829 [details]
File after autofill
(In reply to comment #9)
> Created attachment 69829 [details]
> File after autofill
Please open a new bug report for the autofill problem. The autofill should normall not copy conditional formats but I have to investigate why this happens. If this was the only problem that resulted in reopening this bug report please also close this bug report again. I will try to keep track of the problem than in the new bug report.
... and please do not “update” the Version field ;-): it should always contain the *first* version in which a bug is known to exist, and not the last one.
Marking as fixed. Please open the new bug report and put me in cc there.
As part of regular FDO maintenance we are checking minor release regression versions to ensure that it was introduced during a minor release.
I can confirm this exact behavior on 188.8.131.52 release
Created attachment 106409 [details]
Excel Spreadsheet which demonstrate conditional format bug
After saving and re-open this file the conditional format is gone
This bug still exists in Version V184.108.40.206
It works correct on OpenOffice V4.1.1
See attachment: "Excel Spreadsheet which demonstrate conditional format bug"
Please open a new bug. Markus is one of our spreadsheet experts and he closed this particular issue as FIXED because the particular issue is fixed. If you're seeing it on a different spreadsheet, it's likely it's not related. Marking again as FIXED. Please create a new bug report and if needed you can reference this one.