Apache OpenOffice (AOO) Bugzilla – Issue 4679
can't change CellStyles Properties (soft format) if a sheet is protected
Last modified: 2017-05-20 10:44:49 UTC
Hi, I tried changing the "CellBackColor" property of "MyCellCstyle" in a calc document using soft format (only 2 of 5 sheets using this CellStyle, the others are protected). But I can only change the property, if all 5 sheets are unprotected. If I have to unprotect all sheets before doing this, it's easier to use hard formating Is it a bug or a feature ??? First noticed with S0 5.2. regards Oliver
Hi Oliver, I could not reproduce this Issue. Please attach a file that shows such problems. Best regards Frank
Created attachment 1622 [details] demo for issue 4679
Hi Niklas, this one seems to be yours. You can create a new cell style and assign it to cells on the unprotected cells. Modifying this style is also impossible. Frank
It's a feature. As soon as any sheet is protected, all cell styles are considered protected, too.
As mentioned on the qa dev list on March 5th I will close all resolved duplicate issues. Please see this posting for details. First step in IssueZilla is unfortunately to set them to verified.
As mentioned on the qa dev list on March 5th I will close all resolved <wontfix/duplicate/worksforme/invalid> issues. Please see this posting for details.
*** Issue 34767 has been marked as a duplicate of this issue. ***
From issuer of 34767 : It is reasonnable to protect style that are used on the protected sheet. This is obvious. However, when a style is NOT used on the protected sheet, it could also be reasonnable to make it editable. Or at least warn the user that the "Edit" is not possible since there is at least one protected sheet. I suspect that a less "skilled" user may get mad in finding out why its style is not editable. But this is only my point of view. Have a nice day.
*** Issue 43954 has been marked as a duplicate of this issue. ***
*** Issue 43819 has been marked as a duplicate of this issue. ***
Due to user's request in http://www.openoffice.org/issues/show_bug.cgi? id=74565 I will allow myself to reopen the issue.
*** Issue 74565 has been marked as a duplicate of this issue. ***
*** Issue 80186 has been marked as a duplicate of this issue. ***
It would be nice to treat styles differently based on whether they are used in a protected sheet, but that would be quite challenging. On the other hand, the current behavior--acting like it's going to do something with nothing actually happening--is not a very satisfactory approach. (Note that attempting to delete an unused style even gives you a confirmation dialog before doing nothing.) I suggest as a bare minimum that an error dialog be displayed indicating that the modify and delete features are disabled because one or more sheets is protected. This ought to be a fairly straight-forward change since the logic is evidently already in place to determine whether a sheet is protected--all that should be needed is adding the dialog.
issue still open for 7 years now - please close it if it will not be fixed at least there should be an error box if one tries to change/remove a style in case a sheet is protected - or the two context menu entries should be disabled...
adjusting target
*** Issue 126124 has been marked as a duplicate of this issue. ***
Reset the assignee to the default "issues@openoffice.apache.org".