https://bugs.freedesktop.org/show_bug.cgi?id=69005

          Priority: medium
            Bug ID: 69005
          Assignee: [email protected]
           Summary: FILTER: (Standard Filter) Empty cells at the bottom of
                    a column match a non-empty Value
          Severity: normal
    Classification: Unclassified
                OS: Linux (All)
          Reporter: [email protected]
          Hardware: x86-64 (AMD64)
            Status: UNCONFIRMED
           Version: 4.1.1.2 rc
         Component: Spreadsheet
           Product: LibreOffice

Created attachment 85295
  --> https://bugs.freedesktop.org/attachment.cgi?id=85295&action=edit
The spreadsheet in the example

Take this sheet:
ID    Data
1    
2    
3    Fred
4    Fred
5    Fred
6    
7    Charlie
8    Charlie
9    
10    

Filtering for "Fred" in the Data column produces
ID    Data
3    Fred
4    Fred
5    Fred
9    
10    
which has two unexpected rows at the bottom.

On the other hand, adding an additional (phoney) row:
ID    Data
1    
2    
3    Fred
4    Fred
5    Fred
6    
7    Charlie
8    Charlie
9    
10    
11    ---
works as expected.

Similar weird things happen when filter for "Charlie" or Not Empty.

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

Reply via email to