[Libreoffice-bugs] [Bug 122975] New: Filter displays wrong rows

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 122975
           Summary: Filter displays wrong rows
           Product: LibreOffice
           Version: 6.1.4.2 release
          Hardware: All
                OS: Windows (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: roger.millichamp at virgin.net

Description:
If I filter a column to only display non empty rows then rows that are empty
are displayed.

Steps to Reproduce:
1.In a new spreadsheet: 
    a) column A: put a value in rows 1 to 3
    b) Column B: put a value in row 2
2. Apply a filter:
    a) Select the whole of Column B by selecting the column label
    b) Select the menu item Data-> More Filters -> Standard Filter which opens
the standard filter dialogue
    c) The selection in Column B will now change to select only rows 1 and 2. 
       This is not correct
    d) In the dialogue set Column B: Condition: =, Value: Not Empty, and then
OK


3.

Actual Results:
Rows 2 and 3 will be displayed

Expected Results:
1) In step 2c either the whole of Column B should remain selected on rows 1 to
3 should be selected
2) In the final result only row 2 should be displayed as that is the only rows
in Column B that has a value


Reproducible: Always


User Profile Reset: Yes



Additional Info:
The above is not correct behaviour because the user will expect the filter to
be applied to what the user selected and will not expect Calc to modify the
selection.

Fix: The filter should be applied to the rows in Column B that have a value in
ANY column rather than just those that have a value in Column B.

Version: 6.1.4.2 (x64)
Build ID: 9d0f32d1f0b509096fd65e0d4bec26ddd1938fd3
CPU threads: 4; OS: Windows 10.0; UI render: default; 
Locale: en-GB (en_GB); Calc: CL

-- 
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/20190125/c0a205a4/attachment-0001.html>