Issue 28985 - 2 problems of the stylist with protected sheets
Summary: 2 problems of the stylist with protected sheets
Alias: None
Product: Calc
Classification: Application
Component: code (show other issues)
Version: OOo 1.1.1
Hardware: All All
: P3 Trivial with 3 votes (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Depends on:
Reported: 2004-05-10 11:20 UTC by norbert2
Modified: 2017-05-20 11:13 UTC (History)
3 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

protected_stylist_1.sxc (5.27 KB, application/vnd.sun.xml.calc)
2004-05-10 11:21 UTC, norbert2
no flags Details
protected_stylist_2.sxc (5.32 KB, application/vnd.sun.xml.calc)
2004-05-10 11:21 UTC, norbert2
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description norbert2 2004-05-10 11:20:59 UTC
Please ...

- open the first attached spreadsheet:
It contains a unprotected and a protected sheet.

- open the stylist-window if it is not already open:
I have added a user-defined style "Unbenannt1", that is applied to NO cell.

- right-click "Unbenannt1" and click "change" (german: "Ändern..."):
Nothing happens!

- right-click "Unbenannt1" and click "delete" (german: "Löschen..."):
Calc asks if you really want to delete this style.

- press OK:
Nothing happens! You cannot ask if something really should be deleted and then 
do nothing after the user has confirmed!

I think it is in general OK to forbid these changements also if the style is 
not applied, because I think to check such dependencies would be to much work / 
to difficult.

But both, "Ändern..." and "Löschen...", should either open the window that 
locked sheets cannot be changed or be disabled if there are protected sheets in 
the document. But I would prefer the first suggestion, because just disabling 
the items coul be a bit unintuitive: Just imagine a complex spreadsheet 
containing many sheet where only one sheet is protected...
So I think the message that locked sheets cannot be changed would be the best 
solution here. Excel (tested: Excel 2000) also does so...


Please ...

- open the second attached spreadsheet:
It contains 2 equal sheets, but one is protected. Sheet 1 is the unprotected 

If you select move the focus between A1 and the other cells, you can see in the 
stylist switching between "Standard" and "Ãœberschrift" (german).
This is OK.

- If you do the same in the protected sheet (Sheet2), the stylist does not show 
the current style! I think this should be fixed to also show the style of the 
focused cell within protected sheets.
Comment 1 norbert2 2004-05-10 11:21:24 UTC
Created attachment 15123 [details]
Comment 2 norbert2 2004-05-10 11:21:37 UTC
Created attachment 15124 [details]
Comment 3 frank 2004-06-03 11:34:42 UTC
Hi Niklas,

the second part is not reproducible using OOo1.1.2rc3 but the first is.

Comment 4 niklas.nebel 2004-06-03 12:23:04 UTC
nn->gt: It's iBIS #98759#.
Comment 5 danielfl 2006-02-02 17:48:15 UTC
The first is reproducible in OOo 2.0!

Comment 6 frank 2006-02-03 09:16:11 UTC
Hi Niklas,

please have again a look at this one.

Comment 7 gnustavo 2008-05-13 19:40:19 UTC
This seems to be a duplicate of issue #4679.
Comment 8 Marcus 2017-05-20 11:13:08 UTC
Reset assigne to the default "".