[Libreoffice-bugs] [Bug 142928] New: FILEOPEN XLSX Standard filters date condition appears converted to plain number
bugzilla-daemon at bugs.documentfoundation.org
bugzilla-daemon at bugs.documentfoundation.org
Fri Jun 18 09:54:10 UTC 2021
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>
More information about the Libreoffice-bugs
mailing list