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)
Version:
(earliest affected)
7.0.4.2 release
Hardware: All All
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
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:


Attachments

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.---
シートを保護している時にもセルの塗りつぶしをできるようにオプションが欲しい。

なぜなら、10年以上前から報告されているのに全く解決されない「他のアプリと行き来してセルをクリックすると中身が消去される」のをなんとかするためにシートを保護しているから。

色を塗る作業が発生するたびにシートの保護を解除したくありません。
あなたなら毎分その作業しますか?1000回やりますか?
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.