I want to color cells white protecting sheet.
Because the issue is not solved that Calc delete inputted cell when click it.
So I protect the sheet as a countermeasure for this problem, but it is inconvenient because the color cannot be painted.
I don't want to protect and unlock the seat every time (If you repeat every minute? 1000 times?)
---Below this line is the native language.---
So you talk about Tools > Protect Sheet... and request a new option under "Allow all users of this sheet to:" [ ] Change cell background.
I wonder if this should be restricted to the cell background color or as well to other attributes, cell styles, and clear direct formatting.
(In reply to Heiko Tietze from comment #1)
> So you talk about Tools > Protect Sheet... and request a new option under
> "Allow all users of this sheet to:" [ ] Change cell background.
> I wonder if this should be restricted to the cell background color or as
> well to other attributes, cell styles, and clear direct formatting.
Could we do something like " Change cell formatting"?
(In reply to jan d from comment #2)
> Could we do something like " Change cell formatting"?
I think we can recommend anything. Wonder if formatting has limits maybe something like number style? And what about alignment?
Topic was on the agenda for the design meeting but didn't receive further input.
Let's add the option at the protection dialog to change cell attributes except number format as other cells may depend on it.