Apache OpenOffice (AOO) Bugzilla – Issue 57708
No option to permit autofilter in protected sheets when exporting as XLS
Last modified: 2013-08-07 15:12:27 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.
Created attachment 31558 [details] Example of Protected Sheet using Autofilter
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?
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.
One for the requirements team.
Hi, I made #71468 for more protection possibilities, present in Excel.