Created attachment 171424 [details]
attachment #171308 [details] after changing filter conditions
This is a followup to bug #141775
Changing autofilter selection in a column containing fractional values is not saved to ODS format correctly.
Steps to reproduce:
1. Open attachment #171308 [details]
2. Change the autofilter on column A to not include 0.046 value
3. Save the file and reload
Autofilter displays only the 0.0 value as checked.
Autofilter displays the 0.0 and 0.516 values as checked.
Version: 18.104.22.168.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
Created attachment 171425 [details]
attachment #171308 [details] after removing one filter condition
Created attachment 171426 [details]
The example file after saving and reloading: attachment #171424 [details]
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.
Working well in
Version: 22.214.171.124.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