Bug 160535 - Support sheet protection option: Use AutoFilter
Summary: Support sheet protection option: Use AutoFilter
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
Inherited From OOo
Hardware: All All
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: 122921
  Show dependency tree / graph
 
Reported: 2024-04-05 12:23 UTC by Gabor Kelemen (allotropia)
Modified: 2024-04-06 19:40 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Attachments
Example file from Excel with sheet protection and AutoFilter (9.12 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2024-04-05 12:23 UTC, Gabor Kelemen (allotropia) 		Details
The option in Excel (10.47 KB, image/png)
2024-04-05 12:23 UTC, Gabor Kelemen (allotropia) 		Details
The Use Autofilter option in the Excel dialog (10.26 KB, image/png)
2024-04-05 12:24 UTC, Gabor Kelemen (allotropia) 		Details
Autofilter is usable on the protected sheet in Calc (84.71 KB, image/png)
2024-04-05 12:29 UTC, Gabor Kelemen (allotropia) 		Details
Show Obsolete (1) View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
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?