To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=74565 Issue #|74565 Summary|Allow style editing when sheet is locked Component|Spreadsheet Version|OOo 2.1 Platform|All URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|ENHANCEMENT Priority|P3 Subcomponent|formatting Assigned to|spreadsheet Reported by|jamescrompton
------- Additional comments from [EMAIL PROTECTED] Thu Feb 15 10:38:52 +0000 2007 ------- 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. --------------------------------------------------------------------- Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]