[Bug 158724] Conditional Formatting gets overwritten

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #10 from Eike Rathke <erack at redhat.com> ---
The "Edit values" values option doesn't make much sense to me, protecting a
sheet to allow editing on protected cells.. it doesn't tell what would be
protected then. But more, all code over the place asks whether the sheet and
then cell is protected and if so denies content changing actions or skips cells
when traveling; with that option it would also have to ask whether that option
is enabled if the sheet is locked. Not good.

Similar for "Format cells" protection that's just another wording reversing the
state to ask. For this to take effect and be disabled if sheet protection is on
it still would disallow editing on protected cells, so wouldn't solve the
request. Or if that was to apply on non-protected cells it's confusing UX.

Or did you mean to have both? That's utterly confusing.

I'd rather introduce an option like "[ ] Lock all formatting even on
unprotected cells" because that is what is actually requested here.


(In reply to phantomlord2 from comment #8)
> If the sheet would priorize CF over manual formatting it would also work,
> didn't know it should work like this.
Prioritize where? Copy-pasting a cell also pastes the "this has no CF"
attribution, if so, unless excluded with Values Only. That won't change.

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