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)
Version:
(earliest affected)
4.0.0.3 release
Hardware: All All
: low enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: needsDevEval
: 119455 161549 165477 (view as bug list)
Depends on:
Blocks: Calc-Styles Sheet
  Show dependency treegraph
 
Reported: 2013-02-10 10:53 UTC by S K
Modified: 2026-01-04 20:29 UTC (History)
7 users (show)

See Also:
Crash report or crash signature:


Attachments
Demonstration video for a non-obvious situation (3.15 MB, video/mp4)
2026-01-04 20:27 UTC, Jeff Fortin Tam
Details
Sample testing file (6.95 KB, application/vnd.oasis.opendocument.spreadsheet)
2026-01-04 20:28 UTC, Jeff Fortin Tam
Details

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 4.0.0.3 release

+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Marking as:

New (confirmed)
Enhancement
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:

ProposedEasyHack
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)
Comment 5 m_a_riosv 2024-06-13 20:24:33 UTC
*** Bug 119455 has been marked as a duplicate of this bug. ***
Comment 6 m_a_riosv 2024-06-13 20:25:21 UTC
*** Bug 161549 has been marked as a duplicate of this bug. ***
Comment 7 m_a_riosv 2025-02-28 00:15:56 UTC
*** Bug 165477 has been marked as a duplicate of this bug. ***
Comment 8 Jeff Fortin Tam 2026-01-04 20:27:55 UTC
Created attachment 204923 [details]
Demonstration video for a non-obvious situation

This is a pretty confusing and undiscoverable problem because the UI doesn't warn you about anything, and protected sheets might be hidden/invisible, so you would never suspect this to be the reason why the UI isn't reacting to the "Edit Style…" action, it just doesn't show you a dialog.

I understand that it cannot be edited while any of the sheets are locked, however the UI should provide you an explanation/error dialog (and offer to unlock the sheets for you, or list them, especially if they are hidden) instead of just silently failing to respond. It took me half an hour to figure out what was going on here, and only when I was about to file a bug report with a sample did I realize that the sample file still had hidden protected sheets that I forgot existed. I would not expect less-technical users to figure this one out without some sort of error dialog telling them what's going on.
Comment 9 Jeff Fortin Tam 2026-01-04 20:28:59 UTC
Created attachment 204924 [details]
Sample testing file

This is the sample file for testing shown in the above video.