Issue 83742

Summary: Changing template doesn't work after sheet protection
Product: Calc Reporter: Joost Andrae <Joost.Andrae>
Component: codeAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact:
Severity: Trivial    
Priority: P3 CC: issues
Version: OOo 2.3.1 RC1   
Target Milestone: ---   
Hardware: All   
OS: All   
Issue Type: ENHANCEMENT Latest Confirmation in: ---
Developer Difficulty: ---

Description Joost Andrae 2007-11-18 21:14:01 UTC
enter some string into A1 of Sheet1
/tools/protect document/sheet
switch to Sheet2
open stylist via function key F11
try to change a style

--> not possible to change a style if sheet protection is activated on one of
the sheets
Comment 1 frank 2007-11-19 08:55:21 UTC
Issue 28985 and Issue 4679 seems to be doubles of this one.
Comment 2 Joost Andrae 2007-11-28 13:52:26 UTC
Changing issue type to ENHANCEMENT. When talking to Niklas I got the information
that it is the defined behavior that templates cannot be changed whilst a sheet
is protected because if you change a template then you could change the
protected cells. And from my POV when looking at the templates all templates are
children of the "default" template so changing cannot be allowed if the
"default" template is used within the protected cell area/sheet.

A possible enhancement could be to implement the ability to allow changing of
templates that are not used by protected cells to allow further usage of
templates in a document that has sheet protection activated in other sheets and
the current sheet that you're working on isn't using sheet protection at all.
To be discussed if such a thing is feasible
Comment 3 Marcus 2017-05-20 11:31:04 UTC
Reset assigne to the default "issues@openoffice.apache.org".