https://bugs.freedesktop.org/show_bug.cgi?id=66342
Priority: medium
Bug ID: 66342
Assignee: [email protected]
Summary: FILTER: Data > Filter > Standard Filter doesn't work
for large (> 2^14) data sets
Severity: normal
Classification: Unclassified
OS: All
Reporter: [email protected]
Hardware: Other
Whiteboard: BSA
Status: UNCONFIRMED
Version: 3.5.7.2 release
Component: Spreadsheet
Product: LibreOffice
Problem description:
You can't filter more than 2^14 rows correctly.
We've replicated on the current Ubuntu 3.5.7.2 and a Mac version.
Also noticed here:
http://milospjanic.blogspot.com/2011/10/how-to-remove-duplicates-in-libreoffice.html?showComment=1342671113599#c2441335020298867469
Steps to reproduce:
Create a document (CSV, etc.) with > 2^14 rows, a single column of 20k
dictionary words is fine. Drag it in to your spreadsheet, and use Data > Filter
> Standard filter to try and reduce to Column Not Empty and No Duplication.
Even if every word was unique, you'll end up with 2^14 rows.
Current behavior:
Even if every word was unique, you'll end up with 2^14 rows, truncating off
lots of valid data.
Expected behavior:
You retain all 20k rows.
Operating System: All
Version: 3.5.7.2 release
--
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
