Working in a protected spreadsheet,
Open Styles and Formatting
Right click on cell style
Choose Modify ...
> Nothing happens
The least one would expect is that there is a warning for the reason that modifying is impossible because of the protection on one or more sheets.
related to Bug 57086
It was very difficult to find, why I can't modify style.
*** Bug 86010 has been marked as a duplicate of this bug. ***
On pc Debian x86-64 with master sources updated today, here what I tried:
- Launch Calc with a brand new file
- Tools/Protect Sheet
- Let options by default and put a password
- Save the file
- reopen the file
- right click any cell to make context menu appear
- select Styles and choose any style
=> Popup error message:
Protected cells can not be modified.
Could someone give it a try with a recent LO version?
wi 10 Versie: 220.127.116.11 (x64
steps to reproduce:
1) open new file
2) make a second sheet
3) make sheet 1 protect
4) go to sheet 2 and open Styles and Formatting
5) choose a style in a cell
6) when you want to change the style, right click on cell style and nothing happens
7) go to sheet 1 and unprotect sheet
8) go to sheet 2 and do step 6 and now you can change the style
(In reply to vlb from comment #5)
On pc Debian x86-64 with master sources updated today, I gave a try to it but don't reproduce this.
If I follow the steps
> steps to reproduce:
> 1) open new file
> 2) make a second sheet
> 3) make sheet 1 protect
> 4) go to sheet 2 and open Styles and Formatting
Where's is "Styles and Formatting" ?
Anyway, I could change the style of a cell in sheet2,
I couldn't on sheet1 where I got the error message quoted in my previous message.
I made the same test with LO Debian package 18.104.22.168 with gen rendering (to approach a bit Windows case)
(In reply to Julien Nabet from comment #6)
> > 4) go to sheet 2 and open Styles and Formatting
> Where's is "Styles and Formatting" ?
When you are in sheet 2 choose "F11" and the Style formats open right in the window.
When you choose a cel style it is possible, but when you rigt click with the mouse and choose change style, there nothing happens. When sheet 1 is unprotect it is possible to change the style on sheet 2.
(In reply to vlb from comment #7)
> (In reply to Julien Nabet from comment #6)
> > > 4) go to sheet 2 and open Styles and Formatting
> > Where's is "Styles and Formatting" ?
> When you are in sheet 2 choose "F11" and the Style formats open right in the
> When you choose a cel style it is possible, but when you rigt click with the
> mouse and choose change style, there nothing happens. When sheet 1 is
> unprotect it is possible to change the style on sheet 2.
Ok I could reproduce this. There's also nothing displayed when trying on sheet1 whereas I should see it.
Thank you for your feedback (and your patience!)
Confirmed still exists in Version: 22.214.171.124
Build ID: 747b5d0ebf89f41c860ec2a39efd7cb15b54f2d8
CPU threads: 8; OS: Linux 5.3; UI render: default; VCL: gtk3;
Locale: en-US (en_US.UTF-8); UI-Language: en-US
This is a really long-term usability issue, still in 7.2.x.
There should be at least a pop-up message explaining that one must first unlock all sheets in order to edit styles. Even better would be an option to temporarily unlock all tables until the style editor gets closed again (after entering the password, if required), as unlocking/locking a number of sheets can be quite tedious.