https://bugs.documentfoundation.org/show_bug.cgi?id=167244
--- Comment #9 from pharmankur <[email protected]> --- I understand the pain of @Roman where in new version of libreoffice CALC , if a sheet is protected autofilter does not work. Especially if the file is opened and saved by the OLD version of Libreoffice calc, and that file is opened AGAIN in new libreoffice version. I will redraft the bug report like this Steps to reproduce 1] In a computer with latest libreoffice e.g. 25.8.2 ; Prepare a libreoffice calc sheet having Autofiler. 2] Protect the sheet .. Right click on sheet name --> Protect --> Protect the sheet and content --> Under section "ALLOW users of this sheet to" --> ensure to check "USE AUTOFILTER" and "USE PIVOT TABLE AND PIVOT CHART" 3] Save the CALC file. 4] Check Autofilter if it is working ... It works ... If it is working , Close the file. 5] NOW open the file in OLD libreoffice version e.g. 6.0.7 6] Check Autofilter if it is working ... It works ... If it is working , SAVE and Close the file --- Very important. 7] NOW open the same file in latest libreoffice e.g. 25.8.2 8] You will find that AUTOFILTER does not work anymore ... the setting "USE AUTOFILTER" and "USE PIVOT TABLE AND PIVOT CHART" is VANISHED. but PROTECTION of the sheet is continued. So we have to manually go to every protected sheet, unprotect and again set "USE AUTOFILTER" and "USE PIVOT TABLE AND PIVOT CHART" option ON. Its is a total pain. Expected Results: In new version of Libreoffice Under section "ALLOW users of this sheet to" --> "USE AUTOFILTER" and "USE PIVOT TABLE AND PIVOT CHART" ----> THESE OPTION MUST BE ON BY DEFAULT This is so much needed for user comfort. There is no logic in turning OFF these options as a DEFAULT -- You are receiving this mail because: You are the assignee for the bug.
