Created attachment 169802 [details] Example file from Calc with autofiltered date column This is a followup to bug #116818 – this time the problem happens in ODS format too. If there is an autofiltered date column in a sheet, autofilters on other column types, like text and number are empty. Steps to reproduce: 1. Open attached file. Actual results: Autofilters on columns B and C are empty. Expected results: Autofilters on columns B and C display possible values. LibreOffice details: Version: 7.2.0.0.alpha0+ (x64) / LibreOffice Community Build ID: 28555fc345ac2ccdda0e4e0f3c812c646befe68b CPU threads: 4; OS: Windows 10.0 Build 18363; UI render: default; VCL: win Locale: en-US (hu_HU); UI: en-GB Calc: CL
Created attachment 169803 [details] Screenshot of the problem in Calc
Confirm for first opening but if you select all dates in A column Autofilter and then select only December 2012, then you'll see correct values in B and C Autofilter windows. But after save/reopen - bug is still here =( Version: 7.2.0.0.alpha0+ (x64) / LibreOffice Community Build ID: 6ab1feb2604d2620435a2aecbafff1d8c21255e9 CPU threads: 4; OS: Windows 10.0 Build 18363; UI render: Skia/Raster; VCL: win Locale: ru-RU (ru_RU); UI: en-US Calc: threaded
Balazs Varga committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/f37f159f2e0c7abe45ac7a3eec447f1234ad1662 tdf#140462 sc ODF import: fix empty autofilter 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.
Verified in: Version: 7.2.0.0.alpha0+ (x64) / LibreOffice Community Build ID: ea4fb1559f7b99a0bfaf18f26cb3b6972c9cde1c CPU threads: 4; OS: Windows 10.0 Build 17134; UI render: default; VCL: win Locale: hu-HU (hu_HU); UI: hu-HU Calc: threaded