| Summary: | When applying clone-format an existing Color Scale conditional format gets destroyed | ||
|---|---|---|---|
| Product: | LibreOffice | Reporter: | Peter <temp> |
| Component: | Calc | Assignee: | Not Assigned <libreoffice-bugs> |
| Status: | VERIFIED DUPLICATE | ||
| Severity: | minor | CC: | himajin100000, ilmari.lauhakangas, miguelangelrv |
| Priority: | medium | ||
| Version: | 6.4.6.2 release | ||
| Hardware: | All | ||
| OS: | All | ||
| Whiteboard: | |||
| Crash report or crash signature: | Regression By: | ||
| Bug Depends on: | |||
| Bug Blocks: | 87351 | ||
| Attachments: | 4 screenshots (German version) to reproduce the bug | ||
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 *** |
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