https://bugs.documentfoundation.org/show_bug.cgi?id=160893
Bug ID: 160893
Summary: XLOOKUP problem with date as text
Product: LibreOffice
Version: 24.8.0.0 alpha0+ Master
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
CC: [email protected]
Created attachment 193922
--> https://bugs.documentfoundation.org/attachment.cgi?id=193922&action=edit
Lookup_array with dates
Open attached file. Save it as .xlsx and open the saved file in Excel. Compare.
Problem:
(1) If the Lookup_value is a text that looks like a date, it is interpreted as
number.
(2) If the Lookup_array contains dates, neither a lookup_value in serial date
form nor as result of the DATE function matches the dates.
--
You are receiving this mail because:
You are the assignee for the bug.
