Like mentioned in Bug 54464 comment #8, after saving and reopening of a file that contains cells with conditional formatting that originate from an autofill operation, the conditional formattings are gone.
Have a look at attachment #69828 [details] and attachment #69828 [details] from Bug 54464
Conditional formatting was copied ever since, and it still works in current versions. The only problem is, that they don't survive a save/open operation.
attachment #69828 [details] (Document before autofill)
attachment #69829 [details] (Document after autofill, save)
Doing the same with Caligra sheets, conditional formatting works as expected.
The conditional formatting has a wrong range. It is
but should be
Created attachment 70179 [details]
Conditional formating window snapshot
The conditional formating which is lost after closing the file
Created attachment 70180 [details]
The example of speadsheet with conditional formating
Snapshot of speadsheet when conditional formating is OK
Created attachment 70181 [details]
snapshot of speadsheet after close and open
The speadsheet after close and re-open of file. The conditional formating is empty (probably not saved by save action)
I have a problem with this LibreOffice release.
All my new conditional formatings of cells are lost after closinf the file.
Cells with conditional formatings done with LibreOffice 3.5 still are OK after closing the file
Here attached 3 snapshots of an example
The conditional formating window
The file before closing it
The file after re-opening
In fact the problem exists when
_1 either cells are created by dragging one cell with conditional formating. All new cells don't kept the conditional formating after saving file
_2 cells are created by Copy/Paste process All new cells don't kept the conditional formating after saving file
NB : When adding manually conditional formating the format is properly saved
Bye : Mario
Markus Mohrhard committed a patch related to this issue.
It has been pushed to "master":
autofill should adapt the cond format range, fdo#57050
The patch should be included in the daily builds available at
http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More
information about daily builds can be found at:
Affected users are encouraged to test the fix and report feedback.
*** Bug 61136 has been marked as a duplicate of this bug. ***