Bug 57086 - FORMATTING: in a spreadsheet with partial protection: allow modifying cell styles that are not used on a protected sheet
Summary: FORMATTING: in a spreadsheet with partial protection: allow modifying cell st...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected) release
Hardware: Other All
: medium enhancement
Assignee: Not Assigned
Depends on:
Blocks: Calc-Styles Cell-Sheet-Protection
  Show dependency treegraph
Reported: 2012-11-13 19:09 UTC by VLB
Modified: 2020-05-25 15:35 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 VLB 2012-11-13 19:09:18 UTC
I have a document with 4 sheets. One or two sheet is protected and i want to change Styles and formatting on a other unprotected sheet, but that isn't possible.

I have long search what was the issue and thre was a protect on a sheet.
When the change Styles and Formatting isn't related to the protect sheet, it is very nice if the change for Styles and Formatting is possible.

If that is diffecult to make, it is fine when there is a mention that there is a protect sheet.
Comment 1 Cor Nouws 2012-11-14 00:06:29 UTC
Hi Frank,
THanks for the issue - let's split it in two :-)
This one is the dofficult one
Comment 2 Cor Nouws 2012-11-14 00:13:28 UTC
And see Bug 57102 for the easy part.
Comment 3 VLB 2012-12-19 15:37:03 UTC
confirm with LO Versie (Bouw-id: 87906242e87d3ddb2ba9827818f2d1416d80cc7)
Comment 4 ign_christian 2013-06-26 02:51:31 UTC
Because of Bug 60837 ?
Comment 5 VLB 2017-12-20 13:13:48 UTC
I have test with the latest version LO, but is still present.
Comment 6 Joshua Coppersmith 2020-05-25 15:35:35 UTC
Confirmed in Version:
Build ID: 747b5d0ebf89f41c860ec2a39efd7cb15b54f2d8
CPU threads: 8; OS: Linux 5.3; UI render: default; VCL: gtk3; 

Instead of trying to sort out which sheet is active when Style Modify... is attempted and which sheet uses which styles could we just add a "Suspend protection on all sheets"? If checked, no protection anywhere, if not, then individual sheets are protected per each sheet's regular protection setting. How hard to then put an open padlock symbol on all tabs that WOULD be protected once suspend mode is cancelled? Seems like this would be useful for lots of power-user scenarios when IT is working on a workbook for end users--turn a bug into a feature.

Of course, the method would query for each password for each sheet having a protection password but after trying no password AND the previous sheet's (if one) password on each sheet, since usually I suspect people use the same password on all protected sheets.