Description: In LibreOffice Calc, when using the "AutoFilter" feature to hide rows based on certain criteria (e.g., rows with 0,00€ or empty cells), the filter does not dynamically update when cell values are changed to meet the filter criteria. For instance, changing a cell value to 0,00€ does not automatically hide the row; I must manually reopen the filter dropdown and reapply the filter settings for the rows to update and become hidden. This behavior is unexpected as I anticipate the AutoFilter to automatically react to cell value changes. This issue presents a challenge, especially in scenarios where a form created in Calc is intended for use by individuals without technical expertise, expecting a dynamically updating filter. Steps to Reproduce: 1. Create a new spreadsheet in LibreOffice Calc. 2. Populate a range of cells with various values, including some cells with values that will not meet the filter criteria. 3. Apply an "AutoFilter" to the range. 4. Set the filter to hide rows with a specific value (e.g., 0,00€ or empty). 5. Notice that the corresponding rows are hidden as expected. 6. Change the value of a cell in a visible row to one that meets the filter's criteria to be hidden (e.g., change a value to 0,00€). 7. Observe that the row with the changed value does not automatically hide. Actual Results: Rows that are changed to meet the AutoFilter criteria after the filter has been applied do not automatically become hidden. Manual reapplication of the filter settings is required to update the visibility of these rows. Expected Results: I expect that changing a cell's value to meet the AutoFilter's criteria would automatically hide the row without needing to manually reapply the filter settings. Reproducible: Always User Profile Reset: Yes Additional Info: - The naming of the feature seems to imply an auto-updating filter - The issue persists regardless of the type of data filtered (numeric values, text, etc.). - A potential workaround is to instruct users to manually reapply the filter settings, but this is not ideal for untechnical users and usability. - No specific changes or upgrades to the system or LibreOffice version were made prior to noticing the issue. Version: 24.2.1.2 (AARCH64) / LibreOffice Community Build ID: db4def46b0453cc22e2d0305797cf981b68ef5ac CPU threads: 10; OS: macOS 14.4; UI render: Skia/Metal; VCL: osx Locale: de-DE (de_DE.UTF-8); UI: en-US Calc: threaded
Created attachment 193257 [details] .ods Spreadsheet for reproduction of bug I attached a spreadsheet file for reproduction of the bug.
Created attachment 193258 [details] .mp4 Screenrecording of the behaviour Screenrecording showing the unintended behaviour based on the provided spreadsheet.
Roland, you put some effort into this topic for bug 130770. Are we missing some option, hidden deep in the expert settings?
Repro already in oldest of Linux 43all repository. This is not related to the regression reported as bug 130770. Arch Linux 64-bit Version: 25.2.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: 450739e92e6f90060e5fdfa42ae291b1abaebd7a CPU threads: 8; OS: Linux 6.9; UI render: default; VCL: kf6 (cairo+wayland) Locale: fi-FI (fi_FI.UTF-8); UI: en-US Calc: CL threaded Built on 16 July 2024