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.
THanks for the issue - let's split it in two :-)
This one is the dofficult one
And see Bug 57102 for the easy part.
confirm with LO Versie 22.214.171.124.beta1 (Bouw-id: 87906242e87d3ddb2ba9827818f2d1416d80cc7)
Because of Bug 60837 ?
I have test with the latest version LO 126.96.36.199beta2, but is still present.
Confirmed in Version: 188.8.131.52
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.