I came across a tricky corner case in copying conditional formats: 1.) Apply a conditional format to a single cell (or a range of cells). 2.) Copy the entire sheet (Sheet1) to a new one (Sheet1_2), including all conditional formatting. 3.) Now, when you copy any conditionally formatted cells from the original Sheet1 to a new location, the conditional formatting is correctly copied. The same holds if you transfer the formatting via the Format Paintbrush. 4.) However, when you copy any conditionally formatted cells from the copied Sheet1_2 to a new location, the conditional formatting is NOT copied. The same bug occurs if you transfer the formatting via the Format Paintbrush.
Simple steps to reproduce: 1. In cell A1 apply conditional format (CF) with style 'Heading' 2. Right-click "Sheet1" > Move/Copy Sheet > OK Expected result: 3. In "Sheet1", copy cell A1 to B1 Unexpected result: 4. In "Sheet1_2", copy cell A1 to B1 Reproduced with LO 4.2.6.1 Not reproduced with LO 4.3.0.3 I don't know whether fix will be backported to 4.2.x Waiting for confirmation from dev
At least marking as NEW as Christian has confirmed that it exists on 4.2. I'm 95% sure that this is a duplicate of another bug but can't seem to find it. @Markus - think that the fix in 4.3 will be backported or should we just close this as WFM?
Minor bug - can slow down the creation of professional quality work but won't prevent it.
Created attachment 103642 [details] Example of original sheet and 2 copies.
(In reply to comment #1) > Expected result: > 3. In "Sheet1", copy cell A1 to B1 I was wrong. Actually CF not copied to B1 -> see Bug 82503 Bug still exist in 4.3.1.1 Still trying to find the relation with Bug 82503
Trying to summarize this bug (with additional tests in another versions): - LO 4.3.1.1 -> pasting result in "Sheet1" and "Sheet1_2" is incorrect because of Bug 82503 - LO 4.2.6.2, 4.2.6.1, 4.2.5.2, 4.1.6.2, 4.0.6.2 -> same behavior as comment 0 & comment 1 - LO 4.2.4.2, 4.2.0.0.beta1 -> reversed behavior (correct pasting in "Sheet1_2", incorrect in "Sheet1") - LO 3.6.7.2 -> correct results, so it's broken since 4.0.x
*** This bug has been marked as a duplicate of bug 82503 ***
Following comment 12 of bug 82503 (https://bugs.freedesktop.org/show_bug.cgi?id=82503#c12), this bug is not a duplicate and still not fixed. => Reopening
Well - Markus is one of our core calc developers so that's an interesting opinion....anyways REOPENED is wrong status. Moving to NEW....even though it's probably a dupe.
@Joel: Maybe you are right; I have just tried again can no longer reproduce this bug with the latest release version (4.3.3.2). @Christian: As it was your comment, could you please check again and see if you can confirm this bug fixed?
This one is fixed.