Bug 160535

Summary:	Support sheet protection option: Use AutoFilter
Product:	LibreOffice	Reporter:	Gabor Kelemen (allotropia) <kelemeng>
Component:	Calc	Assignee:	Not Assigned <libreoffice-bugs>
Status:	NEW ---
Severity:	enhancement	CC:	raal
Priority:	medium
Version:	Inherited From OOo
Hardware:	All
OS:	All
Whiteboard:
Crash report or crash signature:		Regression By:
Bug Depends on:
Bug Blocks:	122921
Attachments:	Example file from Excel with sheet protection and AutoFilter The option in Excel The Use Autofilter option in the Excel dialog Autofilter is usable on the protected sheet in Calc

Description Gabor Kelemen (allotropia) 2024-04-05 12:23:01 UTC

Created attachment 193506 [details]
Example file from Excel with sheet protection and AutoFilter

Excel offers the sheet protection feature "Use Autofilter" meaning even on protected sheets the autofilters work.

1. Open attached document in Excel an Calc
-> In Excel, on the first sheet the autofilter is usable ("Use Autofilter" is enabled in the Protect Sheet dialog), but on the second sheet it is not.
-> In Calc, the Protect Sheet dialog does not have this option, so the autofilter is usable on both sheets.

Version: 24.8.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: c9d4f99b2bb54ac7735b3e0d0cadbafbd0279518
CPU threads: 15; OS: Windows 10.0 Build 19045; UI render: default; VCL: win
Locale: hu-HU (hu_HU); UI: en-US
Calc: default

Comment 1 Gabor Kelemen (allotropia) 2024-04-05 12:23:32 UTC

Created attachment 193507 [details]
The option in Excel

Comment 2 Gabor Kelemen (allotropia) 2024-04-05 12:24:13 UTC

Created attachment 193508 [details]
The Use Autofilter option in the Excel dialog

Comment 3 Gabor Kelemen (allotropia) 2024-04-05 12:29:45 UTC

Created attachment 193509 [details]
Autofilter is usable on the protected sheet in Calc

Comment 4 raal 2024-04-06 19:40:31 UTC

Setting to NEW.
Should bug 122921 be closed?