Description: EN:We make a header for the document, and we insert a filter into it and protect the header cells. RU: Делаем шапку для документа, и в неё же вставляем фильтр и защищаем ячейки шапки Steps to Reproduce: 1. New document 2. Enter any arbitrary values. 3. Install the filter 4. Service – Protect the sheet – enter the password 5. Check the operation of the filter by clicking the mouse. Actual Results: EN: Clicking on the filter with the mouse does not open the filter. RU: Нажатие на фильтр мышкой – не открывает фильтр Expected Results: EN: Clicking on the filter opens the filter. This action worked in earlier versions. RU: Нажатие на фильтр мышкой – открывает фильтр. Это действие работало в ранних версиях Reproducible: Always User Profile Reset: Yes Additional Info: EN: аААААААААА 25.2.2.2-2 It doesn't work either RU: аААААААААА 25.2.2.2-2 тоже не работает
Created attachment 201494 [details] filter.ods
Latest version that works on the ones I have installed. Version: 24.2.7.2 (X86_64) / LibreOffice Community Build ID: ee3885777aa7032db5a9b65deec9457448a91162 CPU threads: 16; OS: Windows 10.0 Build 26100; UI render: Skia/Vulkan; VCL: win Locale: es-ES (es_ES); UI: es-ES Calc: CL threaded
bibisected with linux-64-25.2 author Balazs Varga commit 83910246044c1e05a3b50e25d21ac6a31566cc38 tdf#160404 tdf#160535 tdf#160536 - sc improve sheet protection
It doesn't look like a regression but a new feature which was implemented here: https://bugs.documentfoundation.org/show_bug.cgi?id=160535 See in Release Note 25.2: https://wiki.documentfoundation.org/ReleaseNotes/25.2 - New sheet protection options related to Pivot Tables, Pivot Charts and AutoFilters were added. tdf#160404 tdf#160535 tdf#160536 Before clicking "OK" on the "Protect Sheet" dialog select "Use Autofilter" among the checkboxes. See attached picture.
Created attachment 201528 [details] Protect Sheet options
Indeed, new functionality has appeared. However, in the process of work, this checkmark is lost after saving the document. I can't know exactly what it looks like, we're updating LO Действительно, появился новый функционал. Однако в процессе работы теряется данная галка после сохранения документа. Как это выглядит точно не могу знать, занимаемся обновлением LO
(In reply to Roman from comment #6) > Indeed, new functionality has appeared. However, in the process of work, > this checkmark is lost after saving the document. I can't know exactly what > it looks like, we're updating LO Works for me in new file. Cannot test with your file, I don't know password. Version: 26.2.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: 8ea8e254a3151f5390f3a10ff156fcaf8e7c5d5c CPU threads: 4; OS: Linux 6.8; UI render: default; VCL: kf5 (cairo+xcb) Locale: cs-CZ (cs_CZ.UTF-8); UI: en-US Calc: threaded
(In reply to raal from comment #7) > (In reply to Roman from comment #6) > > Indeed, new functionality has appeared. However, in the process of work, > > this checkmark is lost after saving the document. I can't know exactly what > > it looks like, we're updating LO > > Works for me in new file. Cannot test with your file, I don't know password. > > Version: 26.2.0.0.alpha0+ (X86_64) / LibreOffice Community > Build ID: 8ea8e254a3151f5390f3a10ff156fcaf8e7c5d5c > CPU threads: 4; OS: Linux 6.8; UI render: default; VCL: kf5 (cairo+xcb) > Locale: cs-CZ (cs_CZ.UTF-8); UI: en-US > Calc: threaded Yes, it is, and I know it works. However, the error trigger scenario is not entirely clear.: 1) The old version doesn't know how to do this, but I tested 7.5 and had no problems. 2) Internal changes at work have not yet been proven. Да это и я знаю что он работает. Однако не совсем понятен сценарий срабатывания ошибки: 1) Старая версия не умеет этого делать - но я тестировал 7.5 у той проблем не было. 2) Внутренние изменения при работе - ещё не доказано.
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
Table protection is written to the document as <loext:table-protection oext:use-autofilter="true" loext:use-pivot="true"/> as requested in bug 160535 and bug 160536. Obviously this was not available before 25.2 and saving a file with sheet protection will not (re)store these settings. And there is no way to modify the options post hoc, like switch autofilter on/off for a protected sheet, without infringing the protection itself. I'm afraid you either have to abandon the outdated versions or to abstain from using new features. => WF