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: 2020-05-25 15:15 UTC (History)
5 users (show)

See Also:
Crash report or crash signature:


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