https://bugs.documentfoundation.org/show_bug.cgi?id=94702
Bug ID: 94702
Summary: FILTER - Using AutoFilter -> Standard Filter ->
Condition "Ends With". If value of filter has 7 chars
long, then cells with 6 chars long are not filtered.
Product: LibreOffice
Version: unspecified
Hardware: x86-64 (AMD64)
OS: Linux (All)
Status: UNCONFIRMED
Severity: major
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Created attachment 119204
--> https://bugs.documentfoundation.org/attachment.cgi?id=119204&action=edit
Values used to reproduce the error.
Hi,
FILTER - Using AutoFilter -> Standard Filter -> Condition "Ends With". If value
of filter has 7 chars long, then cells with 6 chars long are not filtered.
Replication scenario:
Go to A1 and paste the following cells vertically (should fill range a1:a8)
col
a12345
b1234567
C__1234567
D____1234567
e1234
f123
g12345
Then select the range a1:a8, go to Data->Filter->AutoFilter.
When autofilter is set, pull down the filter and select "Standard Filter...".
On "Field name" set "col" (the value at a1 cell), on "Condition" set "Ends
With", on Value set "1234567" (a 7 char prefix that should filter some values
on the sample table), then click "OK" button to apply the filter.
You will see that cells a2 and a8 (both are 6 chars long) will remain
unfiltered even the fact that they don't fit the filter condition.
I use this option a lot, please let me know if I can contribute somehow to fix
this issue for next release.
Regards,
Matias Lopez.
--
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
