Download it now!
Bug 71231 - Automatic filter doesn't work with more than 65535 rows
Summary: Automatic filter doesn't work with more than 65535 rows
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected) release
Hardware: Other All
: medium normal
Assignee: Not Assigned
Depends on:
Reported: 2013-11-04 20:00 UTC by Kamil Páral
Modified: 2015-03-11 15:34 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

automatic filter problem with too many files (81.66 KB, image/png)
2013-11-04 20:00 UTC, Kamil Páral
sample xlsx file with more than 65535 rows (753.44 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2013-11-04 20:01 UTC, Kamil Páral

Note You need to log in before you can comment on or make changes to this bug.
Description Kamil Páral 2013-11-04 20:00:40 UTC
Created attachment 88648 [details]
automatic filter problem with too many files

When I have a xlsx file with more than 65535 rows (different content in each cell) and I create an automatic filter and display it, the checkboxes don't work properly.

Please see the attached screenshot and the sample file.

First, the checkboxes are ordered correctly until foo_65535, after that they continue from the latest item (foo_70000) in _descending order_ until foo_65536.

Second, checkboxes from foo_65537 onward (to foo_70000) are not checked, even though they should be. foo_65536 is the last item in the popup, but it is checked.

Third, "show only current item" doesn't work correctly. Checkboxes between foo_65537 and foo_70000 can _never_ be enabled, no matter what you do. foo_65536 is _always_ enabled, no matter what you do.

Fedora 19
Comment 1 Kamil Páral 2013-11-04 20:01:17 UTC
Created attachment 88649 [details]
sample xlsx file with more than 65535 rows
Comment 2 Owen Genat (retired) 2014-01-21 05:58:36 UTC
For earlier versions of LO:

- v3.3.0.4 OOO330m19 Build: 6
- v3.4.6.2 OOO340m1 Build: 602
- v3.5.7.2 Build ID: 3215f89-f603614-ab984f2-7348103-1225a5b

The entries in the AutoFilter in the provided attachment are limited to 16384. This limitation is described (for Standard Filter) in bug 66342. The new limit is higher, but confirmed for:

- v3.6.7.2 Build ID: e183d5b
- v4.0.6.2 Build ID: 2e2573268451a50806fcd60ae2d9fe01dd0ce24
- v4.1.4.2 Build ID: 0a0440ccc0227ad9829de5f46be37cfb6edcf72

All versions tested under Ubuntu 10.04 x86_64.
Comment 3 raal 2015-03-06 22:14:13 UTC
Please retest with actual versions 4.3.x or 4.4.x. When I open your file, I doesn't see problems you described.
Comment 4 Kamil Páral 2015-03-11 15:34:57 UTC
You're right, it works well in newer versions of LO. Except for "All" and "Show only current item" buttons, which make Calc consume 100% CPU for long minutes and one has to kill it. But that should be a separate report.