[Bug 158724] Conditional Formatting gets overwritten

bugzilla-daemon at bugs.documentfoundation.org bugzilla-daemon at bugs.documentfoundation.org
Mon Jan 15 12:37:23 UTC 2024


https://bugs.documentfoundation.org/show_bug.cgi?id=158724

--- Comment #13 from Heiko Tietze <heiko.tietze at documentfoundation.org> ---
(In reply to Eike Rathke from comment #10)
> Or did you mean to have both? That's utterly confusing.
Yes, both. The example is a vacation planner/tracker where users copy/paste
data points (eg. "x") from week 1 into 2. And the sheet author wants to allow
this but asks for a way to keep the CF. My idea was to "[x] Lock all
formatting" + "[ ] Disable editing values" (to turn the logic around here; this
would be on by default).

> I'd rather introduce an option like "[ ] Lock all formatting even on
> unprotected cells" because that is what is actually requested here.
Cannot wrap my mind around the "even on unprotected cells". This wont be
possible in the sheet protection dialog and requires some additional protection
method.

(In reply to Eike Rathke from comment #10)
> ...code over the place...
Sounds like some effort.

-- 
You are receiving this mail because:
You are on the CC list for the bug.


More information about the Libreoffice-ux-advise mailing list