Created attachment 169633 [details] 4 screenshots (German version) to reproduce the bug Description: An existing conditional format is destroyed when applying a format with Clone Formatting (not sure how it is called in english) Steps to Reproduce: 1. In a table insert 1,2,3 to B3, B4, B5 2. Set cond. formatting to color-bar for this 3 cells only 3. Set format (e.g. blue background) in e.g. A4 and C4 4. Select row 4 and click on Clone Formatting icon 5. Apply to A5 6. This will remove the cond. formatting from B5!? (applying correct style to A5 and C5) 7. Even Ctrl-Z (Undo) is not restoring it! Actual Results: Cell B5 lost cond. formatting after applying the cloned style Expected Results: cond. formatting should be untouched, as the original (where I clone from) has the exact same setting (at least in row B) Reproducible: Always PS: Screenshot is from german version, but I think you get the point. It's made out of 4 screenshots
Right, but I think it is not a bug. Conditional format it's part of cell format, so Paintbrush does their job, if source cell doesn't have the CF then it is cleared in destination cell. You can use Menu/Edit/Paste special [Ctrl+Shift+V] to copy without the format.
> "if source cell doesn't have the CF then it is cleared in destination cell." That is not the case: As said: the source AND target cell HAVE cond. format set. But target looses it if I use the Clone Formatting from source to target.
Yeah, it is creating a new ColorScale condition for B5 even though B5 was part of the range B3:B5. Arch Linux 64-bit Version: 7.4.0.0.alpha0+ / LibreOffice Community Build ID: ba0100be03c6bbc5ae10201bae340b3f7b7c4500 CPU threads: 8; OS: Linux 5.16; UI render: default; VCL: kf5 (cairo+xcb) Locale: fi-FI (fi_FI.UTF-8); UI: en-US Calc: threaded Jumbo Built on 27 January 2022
*** This bug has been marked as a duplicate of bug 154906 ***