[Libreoffice-bugs] [Bug 140968] New: FILEOPEN XLSX Autofilter does not take number formatting in account

[bugzilla-daemon at bugs.documentfoundation.org]

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: libreoffice-bugs at lists.freedesktop.org
          Reporter: libreoffice at nisz.hu
                CC: nemeth at numbertext.org, varga.balazs3 at nisz.hu
            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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20210312/af5a8f0a/attachment.htm>