https://bugs.documentfoundation.org/show_bug.cgi?id=158724
--- Comment #13 from Heiko Tietze <heiko.tie...@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.