Created attachment 203528 [details] CALC - feature request - area when copy conditional formatting SUMMARY If you copy a random cell into the area of a conditional format, the area of the conditional formatting is changed. Often new entries are created in the conditional formats list that are not required because they apply the same format just in a different area. OBSERVED RESULT Your area for conditional formatting is eg. A1:B10. Ax has a value, Bx has a value. If Ax and Bx match, the conditional formatting shell mark them green, if not, red. If you copy cells from somewhere outside the area of the conditional formatting, the area is changed. SUGGESTED RESULT The suggestion / feature request is an option to lock the area of conditional formatting. So no matter what you copy from where and with which formatting, the area stays the same (Just like you would copy only the values with Ctrl + Shift + V) SOFTWARE/OS VERSIONS Version: 25.8.2.2 (X86_64) / LibreOffice Community Build ID: d401f2107ccab8f924a8e2df40f573aab7605b6f CPU threads: 12; OS: Linux 6.14; UI render: default; VCL: gtk3 Locale: de-AT (de_AT.UTF-8); UI: de-DE Flatpak Calc: threaded ADDITIONAL INFORMATION I have a large file with ~1500 lines and many different people working on it. As people entered the wrong values in the past, I tried to include an indicator for them so that they can tell at first sight if their entered value is right. It basically does the same as the provided demo file, but a little bit more complex. Since much information is often the same, they just copy one line to the next (of course they do, why would they write the same for information if they can copy it). However, exactly this causes the problem as the area of effect is split up with every copy. I usually end up with an area so cut into pieces that the text of the area is longer than all formulas combined. I tried to explain people that they can also copy just information without altering the area, but they forget or don't care.
Created attachment 203530 [details] CALC - feature request - altered area of conditional formatting Video demonstrating the problem. NOTE: Undoing a change done to the area with Ctrl + Z seems to work, no idea what I did wrong (probably that I just removed the values with "Del" and not undoing the change. However, the main problem still stays)
Created attachment 203532 [details] CALC - feature request - lock area of conditional formatting A suggestion / design study who this feature could look like. You have a clickable icon next to the area. There are two example states above for locked and unlocked status (eg. red/green or a locked/unlocked padlock symbol). There should probably also in indicator of this in the list overview window.
Created attachment 203536 [details] CALC - feature request - lock area of conditional formatting correction update