Any changes to the Condition field under Filter Criteria in Standard Filter are rejected (filter changes not saved and don't take effect).
Please attach a sample file, reduce the size as much as possible without private information, and paste the information in Menu/Help/About LibreOffice, there is a copy icon. And please do not set your own reports as new, someone else should verify the reproduction of the problem.
Created attachment 197731 [details] Couldn't attach multiple files. Hence attached a screen recording to demonstrate the issue with filter change rather than attach the test spreadsheet.. The issue seems to occur when I try to change filter and save it **without clicking anywhere on the spreadsheet** while applying a filter, change filter conditions and save the change.
You can add several files, one by one, in this only one spreadsheet it's needed to demonstrate the issue. Please paste here the information on Menu/Help/About LibreOffice (There is an icon to copy)
Created attachment 198104 [details] Test spreadsheet Attached test spreadsheet.
Created attachment 198107 [details] Sample file with filter In your file, there was no filter. Added to it, after, it is saved reopens fine. Version: 24.8.4.1 (X86_64) / LibreOffice Community Build ID: 1be9007f5d86a3741c366527d13e2970cbeef057 CPU threads: 16; OS: Windows 11 X86_64 (10.0 build 26100); UI render: Skia/Vulkan; VCL: win Locale: es-ES (es_ES); UI: en-US Calc: CL threaded
Created attachment 198137 [details] New testing document. Still present in version 24.8.3.2. Version: 24.8.3.2 (X86_64) / LibreOffice Community Build ID: 48a6bac9e7e268aeb4c3483fcf825c94556d9f92 CPU threads: 16; OS: Linux 5.18; UI render: default; VCL: gtk3 Locale: fr-FR (fr_FR.UTF-8); UI: fr-FR Calc: threaded Did you try resetting your UserProfile? : Yes Attached an new testing file. In this testing file a standard filter is applied to the $Feuille1.A:A column. This filter only display lines with the value "Valeur2" If I modify the filter operator from "=" to "<>" then click OK, the filter result is not updated. If I go back to the standard filter dialog, the filter operator remains "=".
Indeed data is filtered, because i see just "Valeur 2", but I dont see the filter to be active in the sheet.
I succeded to see the filter in Data - More Filter - Standard Filter, but what I selected is what I see after save/close/reopen. Version: 24.8.4.2 (X86_64) / LibreOffice Community Build ID: bb3cfa12c7b1bf994ecc5649a80400d06cd71002 CPU threads: 16; OS: Linux 6.8; UI render: default; VCL: gtk3 Locale: ro-RO (ro_RO.UTF-8); UI: en-US Calc: threaded
There's no need to save/close/reopen the document. When the document is open, displayed cells are those which contains the value "Valeur 2". Then : - click on the cell A2 - go to Data > More Filters > Standard Filter ... - change the Condition field of the filter from "=" to "<>" - click the 'OK' button What happens : The filter result doesn't change. What should happens : The filter should hide cells with value "Valeur 2" and display cells with any other value.
I changed in Tools - Options - LibreOffice Calc - Calculate "Search criteria = and <> must apply to whole cells", being checked or unchecked, but I still have wrong results. Gautham, can you try to test with this settings, if this can solve this problem?