Apache OpenOffice (AOO) Bugzilla – Issue 74565
Allow style editing when sheet is locked
Last modified: 2007-02-16 10:54:26 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.
Resolving as dup 4679. jamescrompton, I have reopened 4679. Please vote for it. *** This issue has been marked as a duplicate of 4679 ***
...and closed