Bug 141916 - FILESAVE ODS Autofilter conditions with fractional values is not saved
Summary: FILESAVE ODS Autofilter conditions with fractional values is not saved
Status: VERIFIED FIXED
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
Inherited From OOo
Hardware: All All
: medium normal
Assignee: Balázs Varga
URL:
Whiteboard: target:7.2.0
Keywords: filter:ods
Depends on:
Blocks: AutoFilter
  Show dependency tree / graph
 
Reported: 2021-04-26 13:00 UTC by NISZ LibreOffice Team
Modified: 2021-05-07 05:07 UTC (History)
4 users (show)

See Also:
Crash report or crash signature:

Attachments
attachment #171308 after changing filter conditions (11.39 KB, application/vnd.oasis.opendocument.spreadsheet)
2021-04-26 13:00 UTC, NISZ LibreOffice Team 		Details
attachment #171308 after removing one filter condition (6.28 KB, image/png)
2021-04-26 13:01 UTC, NISZ LibreOffice Team 		Details
The example file after saving and reloading: attachment #171424 (6.21 KB, image/png)
2021-04-26 13:01 UTC, NISZ LibreOffice Team 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description NISZ LibreOffice Team 2021-04-26 13:00:55 UTC 
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

Actual results:
Autofilter displays only the 0.0 value as checked.

Expected results:
Autofilter displays the 0.0 and 0.516 values as checked.

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
Comment 1 NISZ LibreOffice Team 2021-04-26 13:01:14 UTC 
Created attachment 171425 [details]
attachment #171308 [details] after removing one filter condition
Comment 2 NISZ LibreOffice Team 2021-04-26 13:01:58 UTC 
Created attachment 171426 [details]
The example file after saving and reloading: attachment #171424 [details]
Comment 3 Balázs Varga 2021-05-04 08:25:37 UTC 
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.
Comment 4 BogdanB 2021-05-07 05:07:11 UTC 
Working well 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
Comment 5 BogdanB 2021-05-07 05:07:21 UTC Comment hidden (obsolete)