https://bugs.documentfoundation.org/show_bug.cgi?id=140968
Bug ID: 140968
Summary: FILEOPEN XLSX Autofilter does not take number
formatting in account
Product: LibreOffice
Version: Inherited From OOo
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
CC: [email protected], [email protected]
Blocks: 103512
Created attachment 170421
--> https://bugs.documentfoundation.org/attachment.cgi?id=170421&action=edit
Example file from Excel
Attached example file was made in Excel and contains some numbers formatted
with two decimal places, some of which are filtered. Excels filter shows the
numbers as they appear in the cells, with two decimals.
When opened in Calc the filter contains the unformatted numbers and none of
them is selected.
Steps to reproduce:
1. Open attached file
Actual results:
The autofilter dropdown does not show any items selected; numbers should be
formatted as two decimals.
Expected results:
Autofilter should show 0,33 ; 4,00; 563,12; 12,60 selected and all numbers
formatted with two decimals.
LibreOffice details:
Version: 7.2.0.0.alpha0+ (x64) / LibreOffice Community
Build ID: 9d8accf03984a64a4105826e55b221962628eb93
CPU threads: 4; OS: Windows 10.0 Build 18363; UI render: Skia/Raster; VCL: win
Locale: en-US (hu_HU); UI: en-GB
Calc: CL
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._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
