Created attachment 108928 [details] Small example spreadsheet that can be used to reproduce this bug. I'm using LibreOffice version 4.2.6.3 on Linux Mint 17 "Qiana" MATE. I do not know if this bug reproduces in the current version of LibreOffice but it should not be difficult to check. Steps to reproduce this bug: 1. Create a LibreOffice Calc sheet with conditional formatting. 2. Duplicate the sheet in the workbook, placing the copied sheet before the sheet to be copied. 3. Save the spreadsheet to a file. 4. Re-open the spreadsheet in LibreOffice Calc. 5. Observe the conditional formatting is lost for the duplicated sheet. The attached spreadsheet is a simple example that can be used to reproduce the above bug, but any spreadsheet with conditional formatting should work (as far as I've observed). Interestingly, conditional formatting does *not* seem to be lost if the destination for the copied sheet is placed after the source sheet (step 2 in the repro steps above). I'm setting the severity to critical because this causes loss of data. Please adjust as necessary.
Hm, the attachment says it's text/plain, but it's an OpenDocument spreadsheet. If you want to use it, save it as a file with an .ods extension before opening it.
Comment on attachment 108928 [details] Small example spreadsheet that can be used to reproduce this bug. corrected mime type
Hi smkkbot, THanks for the report. It works fine for me in 4.3.3.2 - the latest version. Did not try in other versions, but this looks as fixed since the 4.2.6.3 that you used. Could you check that please? Best Cor
I just tried with version 4.3.3.2 (Build ID: 430m0(Build:2)) and I cannot reproduce the bug, so it seems fixed in the latest version.
Thanks for checking indeed. Usually we then set 'WorksForMe' (and fixed when we know the specific commit, or mark as Duplicate when we know which issue.. But that's not necessary and consumes time ;) )
Created attachment 112502 [details] Mark list Conditional foramtting is changed after reopening the file. In TAR sheet, i used condional formatting for AH4:AH7. It works. But when i reopen the same file after saving, it changes to some other condition that i used for some other cells.
Think, I observed similar behaviour Software LibreOffice Calc Version 4.3.5.2.0+ Build ID 430m0(Build:2) OS OpenSuse Linux 13.2 Kernel Version 3.16.7-7-desktop Desktop KDE 4.14.4 Conditional formatting copied/paintbrushed is lost during save/reload. Applied conditional formatting to a single cell, copied format (paintbrush, insert special) to other cells. The conditional format works at first, but is partially destroyed after save/close/reload file. steps to reproduce (sc_i = screenshot i, attached): - create spreadsheet in calc - insert numbers 1...10 in column A (see sc_1) - create conditional formatting for the first of these numbers Menu/Format/Conditional Formatting/Condition..., (see sc_2) actual parameters used: value >5, new format "higher number" copy format to the rest of the cells (2...10), using format paintbrush or insert special - formats only. (see sc_3) save & close spreadsheet (file name "spdsh_con_form_bug.ods") reopen spreadsheet observed: conditional formatting is not shown (see sc_4) expected: (example attached) all numbers > 6 written in light red inspecting the cells' format A1: conditional formatting still there (see sc_5) A2: conditional formatting no longer (see SC_6) ditto for A3...A10 The conditional formatting can be reapplied, but is lost during save/reload I tried several approaches to track down the conditions under which the fault occurs. I could tell no difference between copying the format by paintbrush or copy/past special (format only). I expected the fault to act deterministically, but instead found some interesting deviations. The formatting is not always lost on all cells. Unfortunately I could not determine, which circumstances influenced the results. Manually entering the cond. form. seems to work OK! I used spdsh_con_form_bug_v2.ods (attached) to manually enter the conditional formatting, instead of copying it. During some save/reload cycles the sheet seemed stable. If I can help further, just let me know.
Created attachment 113452 [details] spred sheet file om which the fault occurs
Created attachment 113453 [details] sc1 - spread sheet w/o formatting
Created attachment 113454 [details] sc2 - conditional formatting detailed shows the options chosen for "font effects"
Created attachment 113455 [details] sc-3 cond. formatting corretly working all numbers >5 are correctly displayed in red
Created attachment 113456 [details] sc-4: spreadsheet after save/close/load The consitional formats (at least for numbers >5) are not enacted
Created attachment 113457 [details] sc_5: manually created cond. formattng for A1 preserved sc_5: manually created cond. formattng for A1 preserved during save/close/relad
Created attachment 113458 [details] sc_6: copied format not preserved sc_6: copied cond. formatting not preserved during save/close/reload
Created attachment 113459 [details] Spdsht: Manually entered cond. form. and it is preserved This spreadsheet contains conditionally formatted cells, but the format has not been copied, but been entered manually. In this case the formats are preserved.
Conditional formatting is not copied with sheet in a workbook and between workbooks in 4.4.4.2 and 5.1.2 with Linux 64b
(In reply to Heinrich Seebauer from comment #7) Fixed in bibisect50max for bug 86253, backported to 4.4.0 and 4.3.6: commit 1e4fc94c7feff11f28654dcf70cccf77db216143 Author: Markus Mohrhard <markus.mohrhard@collabora.co.uk> CommitDate: Sun Nov 30 00:47:33 2014 +0100 we need to copy the condition format cell for cell, fdo#86253