Issue 83742 - Changing template doesn't work after sheet protection
Summary: Changing template doesn't work after sheet protection
Alias: None
Product: Calc
Classification: Application
Component: code (show other issues)
Version: OOo 2.3.1 RC1
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Depends on:
Reported: 2007-11-18 21:14 UTC by Joost Andrae
Modified: 2017-05-20 11:31 UTC (History)
1 user (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 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 "".