Bug 109374 - excel autofilter shows different items checked
Summary: excel autofilter shows different items checked
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
3.5.3 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: filter:xls
Depends on:
Blocks: AutoFilter XLS
  Show dependency treegraph
 
Reported: 2017-07-26 06:50 UTC by dumischbaenger
Modified: 2019-02-03 19:23 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments
test file excel (15.00 KB, application/vnd.ms-excel)
2017-07-26 06:50 UTC, dumischbaenger
Details
test file calc (18.16 KB, application/vnd.oasis.opendocument.spreadsheet)
2017-07-26 07:08 UTC, dumischbaenger
Details
comparison excel calc (61.58 KB, image/png)
2017-07-26 07:15 UTC, dumischbaenger
Details
tt saved in ods format with Microsoft Excel Starter 2010 (6.20 KB, application/vnd.oasis.opendocument.spreadsheet)
2017-07-26 10:13 UTC, Jacques Guilleron
Details

Note You need to log in before you can comment on or make changes to this bug.
Description dumischbaenger 2017-07-26 06:50:15 UTC
Created attachment 134861 [details]
test file excel

If I save an ods file with autofilter in excel xls format the filter drop down list in excel shows the wrong items checked.
Comment 1 dumischbaenger 2017-07-26 07:08:34 UTC
Created attachment 134862 [details]
test file calc
Comment 2 dumischbaenger 2017-07-26 07:15:58 UTC
Created attachment 134863 [details]
comparison excel calc
Comment 3 Xisco Faulí 2017-07-26 07:24:53 UTC
Thank you for reporting the bug.
it seems you're using an old version of LibreOffice.
Could you please try to reproduce it with the latest version of LibreOffice from https://www.libreoffice.org/download/libreoffice-fresh/ ?
I have set the bug's status to 'NEEDINFO'. Please change it back to 'UNCONFIRMED' if the bug is still present in the latest version.
Comment 4 dumischbaenger 2017-07-26 09:20:38 UTC
Confirmed it with 5.3.4.2.
Comment 5 Jacques Guilleron 2017-07-26 10:10:09 UTC
Hello,

I don't reproduce using Micorsoft Excel Starter 2010.
Saving tt.xls with ods extension give the same filter when opened into 
LO 5.4.0.2 Build ID: 2b906d450a44f2bbe506dcd22c51b3fa11dc65fd
Threads CPU : 2; OS : Windows 6.1; UI Render : par défaut; 
Locale : fr-FR (fr_FR); Calc: CL
See tta.ods attachment.
Which OS do you use?
Comment 6 Jacques Guilleron 2017-07-26 10:13:57 UTC
Created attachment 134866 [details]
tt saved in ods format with Microsoft Excel Starter 2010
Comment 7 dumischbaenger 2017-07-26 10:20:23 UTC
I made it the other way round. I started with tt.ods in calc and saved it in exc format for excel.

OS is CentOS Linux release 7.3.1611 (Core).
Comment 8 dumischbaenger 2017-07-26 10:25:19 UTC
(In reply to dumischbaenger from comment #7)
> I made it the other way round. I started with tt.ods in calc and saved it in
> exc format for excel.

I mean XLS.
Comment 9 Jacques Guilleron 2017-07-26 12:19:09 UTC
OK, I reproduce with 
LO 5.4.0.2
Build ID: 2b906d450a44f2bbe506dcd22c51b3fa11dc65fd
Threads CPU : 2; OS : Windows 6.1; UI Render : par défaut; 
Locale : fr-FR (fr_FR); Calc: CL
LO 4.4.7.2 Build ID: f3153a8b245191196a4b6b9abd1d0da16eead600
Locale : fr_FR
and
LO 3.5.3.2 Version ID : 235ab8a-3802056-4a8fed3-2d66ea8-e241b80
so prOobably inherited from OOo.
Comment 10 QA Administrators 2018-07-27 02:42:13 UTC Comment hidden (obsolete)
Comment 11 dumischbaenger 2018-08-14 13:02:53 UTC
Bug is still present with 6.0.5.2
Comment 12 Roman Kuznetsov 2019-02-03 19:23:45 UTC
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