[Bug 158724] Conditional Formatting gets overwritten

bugzilla-daemon at bugs.documentfoundation.org bugzilla-daemon at bugs.documentfoundation.org
Tue Jan 16 15:44:54 UTC 2024


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

--- Comment #14 from Eike Rathke <erack at redhat.com> ---
(In reply to phantomlord2 from comment #12)
> (In reply to Eike Rathke from comment #10)
> > I'd rather introduce an option like "[ ] Lock all formatting even on
> > unprotected cells" because that is what is actually requested here.
> 
> this would work for my sheet i guess but what is the difference to this:
> 
> > Another option for the sheet protection could be 
> > Tools > Protect Sheet: + [x] Format cells (if checked you permit any 
> > formatting including DF, CF, and styles). 
It is unclear to what cells the option applies, because normally all protection
applies only to protected cells, but not to unprotected cells. Now if checked,
would that mean that formatting protected cells would be ok? And if unchecked,
why would it prevent unprotected cells from being formatted?


(In reply to Heiko Tietze from comment #13)
> (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).
"Disable editing values" is the standard case for protected cells in a
protected sheet. Making this explicit and then even allowing to disable it is
confusing.


> > 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.
But that is exactly what is requested here. The protected cells are of course
locked in a protected sheet, but for non-protected cells where one enters or
pastes values to, modifying CF is also to be disallowed. I don't get why that
should not be possible in the sheet protection dialog. Of course it requires
implementation of an additional protection method, but what's your point here
with the dialog?

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


More information about the Libreoffice-ux-advise mailing list