https://bugs.documentfoundation.org/show_bug.cgi?id=119949

            Bug ID: 119949
           Summary: Filter broken by blank line
           Product: LibreOffice
           Version: 6.1.1.2 release
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: [email protected]
          Reporter: [email protected]

Description:
Certain blank lines in a sheet cause filtering in filtered columns to stop -
any values in the column beyond that line will be displayed, even if they don't
match the filter.

Steps to Reproduce:
1. Open the attached .ods file and follow the instructions within; namely:
2. Click the autofiltered column header
3. Uncheck all but "VISA"

Actual Results:
Extraneous rows are present after filtering

Expected Results:
Only row 2 should be visible after filtering.


Reproducible: Always


User Profile Reset: No



Additional Info:
This breaks badly expense tracking in sheets that have total rows (a total row
would have a blank value for the filtered "Payment" column from the example).

The bug is probably reproducible on all OS-es, and I've tested on Ubuntu.

-- 
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

Reply via email to