[Libreoffice-bugs] [Bug 119949] New: Filter broken by blank line

[bugzilla-daemon at bugs.documentfoundation.org]

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: libreoffice-bugs at lists.freedesktop.org
          Reporter: ddascalescu+freedesktop at gmail.com

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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20180918/75e0bb6b/attachment.html>