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)
Version:
(earliest affected)
3.5.0 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: filter:xls
Depends on:
Blocks: AutoFilter XLS
  Show dependency treegraph
 
Reported: 2018-01-20 11:12 UTC by Roman Kuznetsov
Modified: 2019-02-03 19:26 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments
example file XLS (308.50 KB, application/vnd.ms-excel)
2018-01-20 11:13 UTC, Roman Kuznetsov
Details

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
Description:
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 6.0.0.2, 5.4.3, 4.4.7

Steps to Reproduce:
1. Open XLS file from attach
2. On tab 4analytics.ru 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
Am I the only one that could not open the attached file?
Comment 4 Roman Kuznetsov 2019-02-03 19:26:49 UTC
still repro in

Версия: 6.3.0.0.alpha0+
ID сборки: 51af3179cf972809d6495c7d58033e069f647bbf
Потоков ЦП: 4; ОС:Linux 4.18; Отрисовка ИП: по умолчанию; VCL: kde5; 
TinderBox: Linux-rpm_deb-x86_64@86-TDF, Branch:master, Time: 2019-02-01_00:15:00
Локаль: ru-RU (ru_RU.UTF-8); UI-Language: ru-RU
Calc: threaded