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