Bug 60575 - When one protected sheet is present it's impossible to edit styles
Summary: When one protected sheet is present it's impossible to edit styles
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected) release
Hardware: All All
: low enhancement
Assignee: Not Assigned
Keywords: needsDevEval
Depends on:
Blocks: Calc-Styles Sheet
  Show dependency treegraph
Reported: 2013-02-10 10:53 UTC by S K
Modified: 2022-04-11 02:52 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:
Regression By:


Note You need to log in before you can comment on or make changes to this bug.
Description S K 2013-02-10 10:53:19 UTC
Problem description: 

It's impossible to edit styles which are not even linked with protected sheet. 

Steps to reproduce:
1. Create new protected sheet
2. Try to Modify any Style (F11 -> Right Click -> Modify...)

Current behavior:
Nothing happens. 

Expected behavior:
 * If style is not used in protected sheet, then the new dialog should be shown.  
 * Otherwise a MessageBox with explanation ("Cannot edit style used in protected sheet. Clone/copy the style.") should be shown.
Comment 1 S K 2013-02-10 10:57:19 UTC
When trying to remove any Style, we have the same issue like in problem description. 

Creating new Styles works but modifying the created one doesn't work.
Comment 2 Joel Madero 2013-02-11 05:43:36 UTC
This is an enhancement request as currently LibreOffice is working as it's designed to work. 

Verified on Bodhi Linux, LibreOffice release

Marking as:

New (confirmed)
Low (there are workarounds, opening a new document allows you to edit styles)

possibly an Easyhack so I'm going to go ahead and mark this also as:

Comment 3 Joel Madero 2014-02-27 22:55:30 UTC
In order to limit the confusion between ProposedEasyHack and EasyHack and to make queries much easier we are changing ProposedEasyHack to NeedsDevEval.

Thank you and apologies for the noise
Comment 4 Robinson Tryon (qubit) 2015-12-13 11:21:41 UTC Comment hidden (obsolete)