[Libreoffice-bugs] [Bug 142215] New: FILEOPEN XLSX Autofilter does not check values ending with zeroes

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=142215

            Bug ID: 142215
           Summary: FILEOPEN XLSX Autofilter does not check values ending
                    with zeroes
           Product: LibreOffice
           Version: 7.2.0.0.alpha0+ Master
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Keywords: filter:xlsx, implementationError
          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: 123807

Created attachment 171873
  --> https://bugs.documentfoundation.org/attachment.cgi?id=171873&action=edit
Screenshot of the original document in Excel

This is a followup to bug 140968
attachment 170421 contains some fractional values that are filtered to be
displayed.
In Calc the ones ending with zeroes do appear as visible on the sheet, but they
are not checked in the autofilter dropdown.

Steps to reproduce:
    1. Open attachment 170421
    2. Open the autofilter dropdown on column A

Actual results:
4,00 and 12,60 are not checked.

Expected results:
4,00 and 12,60 should be checked in the autofilter.

LibreOffice details:
Version: 7.2.0.0.alpha0+ (x64) / LibreOffice Community
Build ID: d7f734db2c078ced3ce08ad58cd816a79abe3bcf
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


Referenced Bugs:

https://bugs.documentfoundation.org/show_bug.cgi?id=123807
[Bug 123807] [META] XLSX Autofilter-related bugs
-- 
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/20210511/fb3ae5dc/attachment.htm>