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.
Created attachment 88649 [details]
sample xlsx file with more than 65535 rows
For earlier versions of LO:
- v220.127.116.11 OOO330m19 Build: 6
- v18.104.22.168 OOO340m1 Build: 602
- v22.214.171.124 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:
- v126.96.36.199 Build ID: e183d5b
- v188.8.131.52 Build ID: 2e2573268451a50806fcd60ae2d9fe01dd0ce24
- v184.108.40.206 Build ID: 0a0440ccc0227ad9829de5f46be37cfb6edcf72
All versions tested under Ubuntu 10.04 x86_64.
Please retest with actual versions 4.3.x or 4.4.x. When I open your file, I doesn't see problems you described.
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.