Created attachment 170433 [details] Example file from Excel Attached Excel-made file contains some time values, some of them are filtered out. When opened in Calc the autofilter shows all entries unselected. Steps to reproduce: 1. Open attached file 2. Look at the autofilter dropdown Actual results: No entries are selected. Expected results: Entries of 8:17; 8:28 and 22:52 should be checked. LibreOffice details: Version: 7.2.0.0.alpha0+ (x64) / LibreOffice Community Build ID: 2fb274950e5207ca55f4f52325fb522bd44024e1 CPU threads: 4; OS: Windows 10.0 Build 18363; UI render: Skia/Raster; VCL: win Locale: hu-HU (hu_HU); UI: en-US Calc: CL Also in: 7.0; 6.0; 5.0; 4.0
Created attachment 170434 [details] Screenshot of the original document side by side in Excel and Calc
confirm in Version: 7.2.0.0.alpha0+ (x64) / LibreOffice Community Build ID: 9d8accf03984a64a4105826e55b221962628eb93 CPU threads: 4; OS: Windows 6.1 Service Pack 1 Build 7601; UI render: default; VCL: win Locale: ru-RU (ru_RU); UI: en-US Calc: CL
Balazs Varga committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/4fd1333ba4bb4f2311e9098291154772bd310429 tdf#140968 tdf#140978 XLSX import: fix lost rounded filters 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
Eike Rathke committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/3172472aa749defc68f51e3436a089f49a496e8b Unnecessary to remember mbFiltering at column, tdf#140968 tdf#140978 follow-up It will be available in 7.5.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.