Created attachment 171308 [details]
Example file from Calc
Attached file contains some fractional values between 0 and 1 that have autofilter applied on some of them.
Adding another condition hides all elements except 0.
Steps to reproduce:
1. Open attached file
2. In column A untick the 0.046 value and close the autofilter
Only the row with value 0 is shown.
The row with value 0.516 should be shown as well.
Version: 220.127.116.11.alpha0+ (x64) / LibreOffice Community
Build ID: eac00017e34e77343b9ac3638bed9c75115a23fe
CPU threads: 4; OS: Windows 10.0 Build 18363; UI render: Skia/Raster; VCL: win
Locale: hu-HU (hu_HU); UI: en-US
Bibisected using bibisect-win64-7.2 to:
author Balazs Varga <firstname.lastname@example.org> 2021-03-11 14:44:49 +0100
committer László Németh <email@example.com> 2021-03-25 15:00:31 +0100
tdf#140968 tdf#140978 XLSX import: fix lost rounded filters
Adding CC to: Balázs Varga
Created attachment 171309 [details]
The example file before changing filtering conditions
Created attachment 171310 [details]
The example file after changing filtering conditions
Balazs Varga committed a patch related to this issue.
It has been pushed to "master":
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:
Affected users are encouraged to test the fix and report feedback.
Version: 18.104.22.168.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