[Libreoffice-bugs] [Bug 141309] New: FILEOPEN XLSX Autofiltered time values do not appear in autofilter

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 141309
           Summary: FILEOPEN XLSX Autofiltered time values do not appear
                    in autofilter
           Product: LibreOffice
           Version: Inherited From OOo
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Keywords: filter:xlsx
          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 170800
  --> https://bugs.documentfoundation.org/attachment.cgi?id=170800&action=edit
Example file from Excel

Attached file contains some time values that were autofiltered in Excel.
When opened in Calc the autofilter dropdown shows all values as hidden, while
only some were hidden in Excel.

Steps to reproduce:
    1. Open attached file

Actual results:
The autofilter displays all values as unchecked.
The main sheet however displays the filtering results correctly.

Expected results:
Only values from 12:xx hours should be unchecked in the filter.

LibreOffice details:
Version: 7.2.0.0.alpha0+ (x64) / LibreOffice Community
Build ID: bdbb5d0389642c0d445b5779fe2a18fda3e4a4d4
CPU threads: 4; OS: Windows 10.0 Build 18363; UI render: Skia/Raster; VCL: win
Locale: en-US (hu_HU); UI: en-US
Calc: CL

Also happens in 6.0, 5.0, 4.0


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/20210329/1588ceff/attachment.htm>