Created attachment 174805 [details] Example file from Calc This is split off from bug 144253 When a cell contains the results of a calculation and it is formatted, the autofilter dropdown and the Standard filter dialog show the values unformatted. Steps to reproduce: 1. Open attached file, it contains the results of some divisions formatted to 2 decimals and one literal value 2. Open the autofilter dropdown, or the Standard Filter dialog Actual results: Values in Column C are not displayed formatted to 2 decimals except for the literal value. Expected results: All values should appear according to the cell format. LibreOffice details: Version: 7.3.0.0.alpha0+ (x64) / LibreOffice Community Build ID: 4cd3ce9848aa039b8d443a1257d1298231680b01 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.0, 5.0, 3.5.
Created attachment 174806 [details] Screenshot of the document in Calc with formatted values
Created attachment 174807 [details] Screenshot of the Autofilter dropdown on column C
Created attachment 174808 [details] Screenshot of the Standard Filter dialog on column C
Balazs Varga committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/51375b48378915b6e95c1ac26b2ccf8e39880f7e tdf#144253 tdf#144324 sc filter: use formatted values in filters 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.
Balazs Varga committed a patch related to this issue. It has been pushed to "libreoffice-7-2": https://git.libreoffice.org/core/commit/73a0deeda1bc63e78de6aa3df9c3324b4ebe0d3b tdf#144253 tdf#144324 sc filter: use formatted values in filters It will be available in 7.2.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.
2 decimals now. Verified in Version: 7.2.2.1 (x64) / LibreOffice Community Build ID: 0e408af0b27894d652a87aa5f21fe17bf058124c CPU threads: 4; OS: Windows 10.0 Build 19043; UI render: Skia/Raster; VCL: win Locale: ro-RO (ro_RO); UI: en-US Calc: threaded
Verified in: Version: 7.3.0.0.alpha0+ (x64) / LibreOffice Community Build ID: c2de581d1943df2d84f2b71817b6a8bee41f0217 CPU threads: 8; OS: Windows 10.0 Build 18363; UI render: Skia/Vulkan; VCL: win Locale: hu-HU (hu_HU); UI: hu-HU Calc: CL