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
Created attachment 193507 [details] The option in Excel
Created attachment 193508 [details] The Use Autofilter option in the Excel dialog
Created attachment 193509 [details] Autofilter is usable on the protected sheet in Calc
Setting to NEW. Should bug 122921 be closed?
Balazs Varga committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/83910246044c1e05a3b50e25d21ac6a31566cc38 tdf#160404 tdf#160535 tdf#160536 - sc improve sheet protection It will be available in 25.2.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
(In reply to raal from comment #4) > Setting to NEW. > Should bug 122921 be closed? Bug 122921 comment 3 also lists Format Cells, sorting and inserting an image/comment/hyperlink, which are all still valid.