Bug 57086

Summary:	FORMATTING: in a spreadsheet with partial protection: allow modifying cell styles that are not used on a protected sheet
Product:	LibreOffice	Reporter:	VLB <vlb1>
Component:	Calc	Assignee:	Not Assigned <libreoffice-bugs>
Status:	NEW ---
Severity:	enhancement	CC:	cno, shantanu.oak
Priority:	medium
Version:	3.6.3.2 release
Hardware:	Other
OS:	All
See Also:	https://bugs.freedesktop.org/show_bug.cgi?id=57102 https://bugs.documentfoundation.org/show_bug.cgi?id=57091
Whiteboard:
Crash report or crash signature:		Regression By:
Bug Depends on:
Bug Blocks:	107332, 107450

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 4.0.0.0.beta1 (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 6.0.0.0beta2, but is still present.

Comment 6 Joshua Coppersmith 2020-05-25 15:35:35 UTC

Confirmed in Version: 6.4.3.2
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.