Bug 116818 - XLSX FILEOPEN: Autofiltered date column and another filtered column discard the filtering
Summary: XLSX FILEOPEN: Autofiltered date column and another filtered column discard t...
Status: VERIFIED FIXED
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
Inherited From OOo
Hardware: All All
: medium normal
Assignee: Balázs Varga
URL:
Whiteboard: target:7.2.0
Keywords: filter:xlsx
: 107082 (view as bug list)
Depends on:
Blocks: XLSX-Autofilter
  Show dependency treegraph
 
Reported: 2018-04-05 10:11 UTC by Gabor Kelemen (allotropia)
Modified: 2021-04-07 10:19 UTC (History)
4 users (show)

See Also:
Crash report or crash signature:


Attachments
Example file from Excel 2010 (17.38 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2018-04-05 10:11 UTC, Gabor Kelemen (allotropia)
Details
Example file saved from Calc 6.0 (17.08 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2018-04-05 10:12 UTC, Gabor Kelemen (allotropia)
Details
The original file in Calc and Excel side by side on opening (239.05 KB, image/png)
2018-04-05 10:12 UTC, Gabor Kelemen (allotropia)
Details
The exported file in Calc and Excel side by side (268.32 KB, image/png)
2018-04-05 10:13 UTC, Gabor Kelemen (allotropia)
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Gabor Kelemen (allotropia) 2018-04-05 10:11:28 UTC
Created attachment 141122 [details]
Example file from Excel 2010

Attached XLSX file from Excel 2010 has a Date type column, a text format and a number format column with auto-filter, set to filter out some date from the first column and filter out some text from the second column. Opening the attached file with LibreOffice Calc, the filter list has disappeared in the second and third (text/number) column.

Steps to reproduce:
1. Create a new spreadsheet with Microsoft Excel 2010/2013/2016
2. Set the first column cells format to Date type, the second/third one to text/number
3. Fill the three column with some data. Optional: (the date column should contain at least three different year)
4. Set an autofilter to the three columns, and filter out some year from the date column and filter out something from the second or third column
5. Save the file as *.XLSX and open with LibreOffice Calc
6. Save as the *.XLSX file with LibreOffice Calc and reload the file

Actual results:
After we import the *.XLSX file, the second and third filter list disappeared. The date filter list was just wrong
After we export the *.XLSX file, the filters disappeared from the first row, but the _xlmn._FilterDatabase named range was good.

Expected results:
The combined filtering should work fine, even if we filter date type column and another ones together.

Version: 6.0.4.0.0+
Build ID: 30db8c9b1d9654e62c11657140fac24f0f52c547
CPU threads: 4; OS: Windows 6.1; UI render: default; 
TinderBox: Win-x86@42, Branch:libreoffice-6-0, Time: 2018-03-27_01:00:13
Locale: hu-HU (hu_HU); Calc: group
Comment 1 Gabor Kelemen (allotropia) 2018-04-05 10:12:06 UTC
Created attachment 141123 [details]
Example file saved from Calc 6.0
Comment 2 Gabor Kelemen (allotropia) 2018-04-05 10:12:51 UTC
Created attachment 141124 [details]
The original file in Calc and Excel side by side on opening
Comment 3 Gabor Kelemen (allotropia) 2018-04-05 10:13:47 UTC
Created attachment 141125 [details]
The exported file in Calc and Excel side by side
Comment 4 Buovjaga 2018-04-18 11:23:46 UTC
Repro with file.

Arch Linux 64-bit
Version: 6.1.0.0.alpha0+
Build ID: c8c74a0b4ca6f3a3619f423b6548c80c52392ae0
CPU threads: 8; OS: Linux 4.15; UI render: default; VCL: kde4; 
Locale: fi-FI (fi_FI.UTF-8); Calc: group
Built on April 15th 2018
Comment 5 Commit Notification 2021-01-21 10:36:15 UTC
Balazs Varga committed a patch related to this issue.
It has been pushed to "master":

https://git.libreoffice.org/core/commit/0e751d0cb816197f15a2448ec36c57df17387e40

tdf#116818 sc,offapi,XLSX import: fix autofiltered date columns

It will be available in 7.2.0.

The patch should be included in the daily builds available at
https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More
information about daily builds can be found at:
https://wiki.documentfoundation.org/Testing_Daily_Builds

Affected users are encouraged to test the fix and report feedback.
Comment 6 Balázs Varga 2021-01-21 11:35:54 UTC
*** Bug 107082 has been marked as a duplicate of this bug. ***
Comment 7 NISZ LibreOffice Team 2021-02-08 11:36:59 UTC
Verified in
Version: 7.2.0.0.alpha0+ (x64) / LibreOffice Community
Build ID: 44b914b1e2616ca8f70e896e653a46ca93610234
CPU threads: 4; OS: Windows 10.0 Build 17134; UI render: Skia/Raster; VCL: win
Locale: hu-HU (hu_HU); UI: hu-HU
Calc: threaded
Comment 8 Timur 2021-04-07 10:19:43 UTC
*** Bug 138089 has been marked as a duplicate of this bug. ***