https://bugs.documentfoundation.org/show_bug.cgi?id=144324
Bug ID: 144324 Summary: VIEWING Autofilter does not display calculated cell contents according to cell format Product: LibreOffice Version: Inherited From OOo Hardware: All OS: All Status: UNCONFIRMED Severity: normal Priority: medium Component: Calc Assignee: libreoffice-bugs@lists.freedesktop.org Reporter: libreoff...@nisz.hu CC: nem...@numbertext.org, varga.bala...@nisz.hu Blocks: 103512 Created attachment 174805 --> https://bugs.documentfoundation.org/attachment.cgi?id=174805&action=edit 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. Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=103512 [Bug 103512] [META] AutoFilter-related bugs and enhancements -- You are receiving this mail because: You are the assignee for the bug.