Bug 57102 - FORMATTING: in a spreadsheet with partial protection: give warning that cell styles cannot be changed
Summary: FORMATTING: in a spreadsheet with partial protection: give warning that cell...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
3.6.0.4 release
Hardware: Other All
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
: 86010 (view as bug list)
Depends on:
Blocks: Calc-Styles Cell-Sheet-Protection
  Show dependency treegraph
 
Reported: 2012-11-14 00:11 UTC by Cor Nouws
Modified: 2022-01-25 15:26 UTC (History)
6 users (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 Cor Nouws 2012-11-14 00:11:59 UTC
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.
Comment 1 Cor Nouws 2012-11-14 00:13:00 UTC Comment hidden (obsolete)
Comment 2 andry 2017-04-02 16:40:42 UTC
Confirm.
It was very difficult to find, why I can't modify style.
Comment 3 Buovjaga 2017-06-04 13:08:39 UTC
*** Bug 86010 has been marked as a duplicate of this bug. ***
Comment 4 Julien Nabet 2020-04-16 18:48:51 UTC
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?
Comment 5 VLB 2020-04-16 19:25:52 UTC
wi 10 Versie: 6.4.3.2 (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
Comment 6 Julien Nabet 2020-04-17 11:01:53 UTC
(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
=> ok
> 2) make a second sheet
=> ok
> 3) make sheet 1 protect
=> ok
> 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 6.4.2.2 with gen rendering (to approach a bit Windows case)
Comment 7 VLB 2020-04-17 15:43:20 UTC
(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.
Comment 8 Julien Nabet 2020-04-17 16:57:57 UTC
(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
> 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.

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!)
Comment 9 Joshua Coppersmith 2020-05-25 15:15:54 UTC
Confirmed still exists in Version: 6.4.3.2
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
Comment 10 cpohle 2022-01-25 15:26:31 UTC
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.