Created attachment 171421 [details] Example file from Excel Attached file contains an autofilter on fractional values. When opened in Calc the value 0.0 is not marked, unlike in Excel. Steps to reproduce: 1. Open attached file 2. Open the autofilter on column A Actual results: The value 0.0 is not marked as to be included. Expected results: The value 0.0 should be marked as to be included. LibreOffice details: Version: 7.2.0.0.alpha0+ (x64) / LibreOffice Community Build ID: 15a9bee9ef26ce13ed1e26319306a88b6d886158 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.1 and older.
Created attachment 171422 [details] The autofilter conditions in Excel
Created attachment 171423 [details] The autofilter conditions in Calc
Balazs Varga committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/d5c2584bf36d21580db677b231c57f99f49aa2cb Related: tdf#140968 avoid duplicated filter values 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.
It's ok in Version: 7.2.0.0.alpha0+ / LibreOffice Community Build ID: 1a99b4e44190e182d56a04678850d62635d74c65 CPU threads: 4; OS: Linux 5.8; UI render: default; VCL: gtk3 Locale: ro-RO (ro_RO.UTF-8); UI: en-US Calc: threaded