Created attachment 173003 [details] Example file from Excel with standard filter condition “Earlier than” Attached example file was made in Excel and on the Date column there is a standard filter set of type “Before” resulting in a filter condition of “Earlier than”. When opened in Calc the condition appears to be <> (meaning not equals) instead of <. Steps to reproduce: 1. Open attached file 2. Open the autofilter, select Standard Filter Actual results: The Standard Filter dialog shows the condition as: <> The date is also converted to a plain number, that's bug 142928. Expected results: The condition should be: < LibreOffice details: Version: 7.3.0.0.alpha0+ (x64) / LibreOffice Community Build ID: c703b2d22c3f45825d9c9d790c3b5a4b6f97e776 CPU threads: 4; OS: Windows 10.0 Build 18363; UI render: default; VCL: win Locale: hu-HU (hu_HU); UI: hu-HU Calc: CL Also in 7.0, 6.0, 5.0, 4.0, 3.5
Created attachment 173004 [details] Screenshot of the original document side by side in Excel and Calc
Created attachment 173245 [details] Same example file filtered for plain number being less than 10 Also happens for filtering plain numbers with "less than" condition in Excel.
Created attachment 173246 [details] Filtering numbers with less than condition, also becomes <> in Calc
Tünde Tóth committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/0d3398e5d141b79706653c04f1ab6dc9381a5cc1 tdf#142929 XLSX: fix import of "Less than" filter condition It will be available in 7.3.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.
Tünde Tóth committed a patch related to this issue. It has been pushed to "libreoffice-7-2": https://git.libreoffice.org/core/commit/bbd4d7c1b8a219cd295fd799d39b9cbb7a5b464d tdf#142929 XLSX: fix import of "Less than" filter condition It will be available in 7.2.0.2. 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.3.0.0.alpha0+ (x64) / LibreOffice Community Build ID: d1f1f546b212ecd651146addeb328806bb270d5f 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