Issue 74565 - Allow style editing when sheet is locked
Summary: Allow style editing when sheet is locked
Status: CLOSED DUPLICATE of issue 4679
Alias: None
Product: Calc
Classification: Application
Component: formatting (show other issues)
Version: OOo 2.1
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: spreadsheet
QA Contact: issues@sc
Depends on:
Reported: 2007-02-15 10:38 UTC by jamescrompton
Modified: 2007-02-16 10:54 UTC (History)
2 users (show)

See Also:
Latest Confirmation in: ---
Developer Difficulty: ---


Note You need to log in before you can comment on or make changes to this issue.
Description jamescrompton 2007-02-15 10:38:52 UTC
At present, if one sheet is locked in a spreadsheet, it is not possible to edit
any styles, not even styles that are not used on the protected sheet and even if
no cells are actually protected on the locked sheet. Under issue 4679 it was
decided not to fix this on the dubious grounds that it is a feature not a bug.

There are many situations in which it would be desirable to protect the data in
some cells/sheets while still allowing for the possibility of changing the style
of others or even the style of the protected cells. Therefore:

1. Only ever lock the styles that are actually applied to protected cells.
2. Provide an option for not locking those styles in the 'Protect sheet' and
'Protect document' dialogue.
3. In the 'Cell protection' tab of the 'Format cells' and 'Cell style'
dialogues, provide an option to protect data only and allow changes to the format.
Comment 1 kpalagin 2007-02-15 11:30:16 UTC
Resolving as dup 4679. 

I have reopened 4679. Please vote for it.

*** This issue has been marked as a duplicate of 4679 ***
Comment 2 frank 2007-02-16 10:54:26 UTC
...and closed