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 > calcext:target-range-address="Tabelle1.A1:Tabelle1.A1" but should be > calcext:target-range-address="Tabelle1.A1:Tabelle1.A2"
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)
Hello 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 Bye TuxMario
Hello again 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": http://cgit.freedesktop.org/libreoffice/core/commit/?id=add3633a6ec53b038ebd29b70125d0eb259549d6 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: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
*** Bug 61136 has been marked as a duplicate of this bug. ***