Issue 57708 - No option to permit autofilter in protected sheets when exporting as XLS
Summary: No option to permit autofilter in protected sheets when exporting as XLS
Alias: None
Product: Calc
Classification: Application
Component: save-export (show other issues)
Version: OOo 2.0
Hardware: All All
: P3 Trivial with 1 vote (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Keywords: ms_interoperability, oooqa
Depends on:
Reported: 2005-11-10 22:00 UTC by kerneld
Modified: 2013-08-07 15:12 UTC (History)
2 users (show)

See Also:
Latest Confirmation in: ---
Developer Difficulty: ---

Example of Protected Sheet using Autofilter (10.27 KB, application/vnd.sun.xml.calc)
2005-11-16 16:27 UTC, atdsm
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description kerneld 2005-11-10 22:00:52 UTC
When protecting a sheet, there is no option to allow the use of auto-filter like
there is in Excel. Without this option, the autofilter is disabled, I would like
the option to permit use of the autofilter in the protected sheet similar to
what is seen in Excel 2003.
Comment 1 atdsm 2005-11-16 16:27:51 UTC
Created attachment 31558 [details]
Example of Protected Sheet using Autofilter
Comment 2 atdsm 2005-11-16 16:42:04 UTC
I can confirm this for OOo 2.0 Windows XP

To reproduce:

1) Open the attachment I created in OOo Calc
2) Save the attachment I created in .XLS format (File > Save As, type Microsoft
Excel 97/2000/XP)
3) Close the document in OOo Calc
4) Open the new .XLS document in MS Excel 2003. Autofilter is now disabled in
Excel, and there is no option in OOo Calc to change this.

Please change to confirmed. Also, I would change type to enhancement (or to
defect P4) and add the ms_interoperability keyword.

As a side note, I just signed up to be a QA observer; doesn't this give me the
ability to make these changes myself? If so, how do I do it?
Comment 3 atdsm 2005-11-17 14:33:19 UTC
Can confirm - Windows XP SP2, OOo 2.0
Can confirm - Windows XP SP2, OOo-dev 2.0.139

Added ms_interoperability keyword.

Changed type to enhancement, since this is more a feature enhancement request
than a bug.
Comment 4 frank 2006-02-17 11:36:10 UTC
One for the requirements team.
Comment 5 cno 2006-11-12 20:51:44 UTC
I made #71468 for more protection possibilities, present in Excel.