https://bugs.documentfoundation.org/show_bug.cgi?id=160326
Bug ID: 160326
Summary: FILTER AutoFilter does not automatically hide rows
upon cell value changes in Calc
Product: LibreOffice
Version: 24.2.1.2 release
Hardware: ARM
OS: macOS (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
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
--
You are receiving this mail because:
You are the assignee for the bug.
