Bug 140787 - Introduce an option for cell formatting on protected sheets
Summary: Introduce an option for cell formatting on protected sheets
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected) release
Hardware: All All
: medium enhancement
Assignee: Not Assigned
Depends on:
Blocks: Cell-Sheet-Protection
  Show dependency treegraph
Reported: 2021-03-04 03:06 UTC by MARINA-SODA
Modified: 2022-04-14 12:19 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:
Regression By:


Note You need to log in before you can comment on or make changes to this bug.
Description MARINA-SODA 2021-03-04 03:06:25 UTC
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.---


Comment 1 Heiko Tietze 2022-04-04 09:38:36 UTC
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.
Comment 2 jan d 2022-04-11 20:22:41 UTC Comment hidden (obsolete)
Comment 3 Heiko Tietze 2022-04-12 11:22:13 UTC
(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?
Comment 4 Heiko Tietze 2022-04-14 12:19:36 UTC
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.