https://bugs.documentfoundation.org/show_bug.cgi?id=169055
Bug ID: 169055
Summary: [Feature request] Option to lock area of conditional
formatting
Product: LibreOffice
Version: 25.8.2.2 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Created attachment 203528
--> https://bugs.documentfoundation.org/attachment.cgi?id=203528&action=edit
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.
--
You are receiving this mail because:
You are the assignee for the bug.
