Download it now!
Bug 115122 - In specific XLS file in drop-down autofilter's list there aren't any items (workaround: turn off-on autofilter)
Summary: In specific XLS file in drop-down autofilter's list there aren't any items (w...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected)
3.5.0 release
Hardware: All All
: medium normal
Assignee: Not Assigned
Keywords: filter:xls
Depends on:
Blocks: AutoFilter XLS
  Show dependency treegraph
Reported: 2018-01-20 11:12 UTC by Roman Kuznetsov
Modified: 2020-01-10 13:21 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

example file XLS (308.50 KB, application/
2018-01-20 11:13 UTC, Roman Kuznetsov

Note You need to log in before you can comment on or make changes to this bug.
Description Roman Kuznetsov 2018-01-20 11:12:51 UTC
in XLS file from attach in drop-down autofilter's list there aren't any items.
in MS Excel this file works correctly, in drop-down list there are items.
if in MS Excel save this file as XLSX, then in LO in drop-down list there are items -> OK.
i tried it in LO, 5.4.3, 4.4.7

Steps to Reproduce:
1. Open XLS file from attach
2. On tab there are autofilter's drop-down lists
3. Open any drop-down list
4. there aren't any items in list

Actual Results:  
autofilter's drop-down lists are empty and doesn't work

Expected Results:
in autofilter's drop-down lists there are items and it works correctly

Reproducible: Always

User Profile Reset: No

Additional Info:

User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:58.0) Gecko/20100101 Firefox/58.0
Comment 1 Roman Kuznetsov 2018-01-20 11:13:34 UTC
Created attachment 139234 [details]
example file XLS
Comment 2 m.a.riosv 2018-01-20 13:48:13 UTC
I think something was already reported, but I can't find it.
Comment 3 Chavdar 2018-01-20 19:46:51 UTC Comment hidden (obsolete)
Comment 4 Roman Kuznetsov 2019-02-03 19:26:49 UTC Comment hidden (obsolete)
Comment 5 Roman Kuznetsov 2020-01-10 13:21:42 UTC
still repro in

Version: (x64)
Build ID: b6295e4a1b7735c148174f44f6d28221f4f52302
CPU threads: 4; OS: Windows 10.0 Build 18362; UI render: default; VCL: win; 
Locale: ru-RU (ru_RU); UI-Language: en-US
Calc: threaded