Bug 160326

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