Created attachment 171873 [details] Screenshot of the original document in Excel This is a followup to bug 140968 attachment 170421 [details] contains some fractional values that are filtered to be displayed. In Calc the ones ending with zeroes do appear as visible on the sheet, but they are not checked in the autofilter dropdown. Steps to reproduce: 1. Open attachment 170421 [details] 2. Open the autofilter dropdown on column A Actual results: 4,00 and 12,60 are not checked. Expected results: 4,00 and 12,60 should be checked in the autofilter. LibreOffice details: Version: 7.2.0.0.alpha0+ (x64) / LibreOffice Community Build ID: d7f734db2c078ced3ce08ad58cd816a79abe3bcf 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
Created attachment 171874 [details] Screenshot of the original document in Calc
repro, add. observation: if you change the amount of decimals displayed -> other values become selected, same already in excel itself, seems better in a fresh calc sheet, selection and checked 'by value', Version: 7.2.0.0.alpha0+ (x64) / LibreOffice Community Build ID: d7f734db2c078ced3ce08ad58cd816a79abe3bcf CPU threads: 8; OS: Windows 6.1 Service Pack 1 Build 7601; UI render: default; VCL: win Locale: de-DE (de_DE); UI: en-US Calc:
Balazs Varga committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/6a2060cef22b19dbe04676c8c16776c4693b4dd8 tdf#141309 tdf#142215 OOXML import: fix double conversion in autofilter 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.
Everything is fine now. Verified with Version: 7.2.0.0.alpha1+ / LibreOffice Community Build ID: f49e5902a3737c02fabf5bec23243ccb126426c4 CPU threads: 4; OS: Linux 5.8; UI render: default; VCL: gtk3 Locale: ro-RO (ro_RO.UTF-8); UI: en-US Calc: threaded Thanks for solving this bug.