Bug 139809

Summary:	FILESAVE XLSX Autofilter with filtered dates
Product:	LibreOffice	Reporter:	NISZ LibreOffice Team <libreoffice>
Component:	Calc	Assignee:	Not Assigned <libreoffice-bugs>
Status:	VERIFIED FIXED
Severity:	normal	CC:	marina.latini, nemeth, varga.balazs3
Priority:	medium	Keywords:	filter:xlsx
Version:	Inherited From OOo
Hardware:	All
OS:	All
See Also:	https://bugs.documentfoundation.org/show_bug.cgi?id=116818 https://bugs.documentfoundation.org/show_bug.cgi?id=116633
Whiteboard:	target:7.2.0
Crash report or crash signature:		Regression By:
Bug Depends on:
Bug Blocks:	123807

Description NISZ LibreOffice Team 2021-01-21 13:15:15 UTC

This is a followup to bug #116818
Now that autofilter settings are imported correctly from XLSX files, it would be necessary to save these back to XLSX as well.

Steps to reproduce:
    1. Open attachment #141122 [details]
    2. Save as XLSX, reopen

Actual results:
Autofilter disappears.

Expected results:
Autofilter and its settings are kept.

Comment 1 Commit Notification 2021-01-26 12:45:02 UTC

Balazs Varga committed a patch related to this issue.
It has been pushed to "master":

https://git.libreoffice.org/core/commit/eea523b686b27b4807ab21b62805ce9fbddf74ef

tdf#139809 sc ooxml export 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 2 Balázs Varga 2021-01-26 13:17:09 UTC

*** Bug 116633 has been marked as a duplicate of this bug. ***

Comment 3 NISZ LibreOffice Team 2021-02-08 11:41:11 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