[Libreoffice-bugs] [Bug 142928] New: FILEOPEN XLSX Standard filters date condition appears converted to plain number

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 142928
           Summary: FILEOPEN XLSX Standard filters date condition appears
                    converted to plain number
           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 172996
  --> https://bugs.documentfoundation.org/attachment.cgi?id=172996&action=edit
Example file from Excel with condition “Between”

Attached example file was made in Excel and on the Date column there is a
standard filter set of type “Between two values”, with a “not earlier than” and
a “not later than” condition.
When opened in Calc the two values appear as plain numbers instead of dates.
This also happens with other standard filters like Earlier than, Later than and
Not equals, but not with type Equals.

Steps to reproduce:
    1. Open attached file
    2. Open the autofilter, select Standard Filter

Actual results:
The Standard Filter dialog shows the values of the conditions as 40179 and
44136 instead of 2010.01.01 and 2020.11.01

Expected results:
The conditions should be formatted as dates.

LibreOffice details:
Version: 7.3.0.0.alpha0+ (x64) / LibreOffice Community
Build ID: c703b2d22c3f45825d9c9d790c3b5a4b6f97e776
CPU threads: 4; OS: Windows 10.0 Build 18363; UI render: default; VCL: win
Locale: hu-HU (hu_HU); UI: hu-HU
Calc: CL

Also happens with en-US locale/UI. The example file was made in a Hungarian
Excel.

Also in 7.0, 6.0, 5.0, 4.0, 3.5


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/20210618/785d62e5/attachment.htm>