https://bugs.documentfoundation.org/show_bug.cgi?id=146954
Bug ID: 146954
Summary: CSV import not recognizing date (regression)
Product: LibreOffice
Version: 7.3.0.2 rc
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: miho...@miho.im
I have ods file created with older LO versions, which use (Sheet - Link to
outside data...) and pull data from CSV file.
It worked without issues in 7.2.5, but when I upgraded to 7.3.0.2 date isn't
recognized.
This is sample data:
2022-01-22T06:50:59.400Z,buy,XYZ,36.991,16,591.856,USD,-0.373905028,1.1351
2022-01-22T10:57:25.501Z,buy,ZYX,33.968,8.8,298.9184,EUR,-0.0015884,1.13275
When linking CSV for first time, first column (date/time) was marked as "Date
(YMD)", while columns 4, 5, 6, 8 and 9 were marked as US ENGLISH.
This automatically converted first column to DATE format, and other columns to
NUMBER format.
As of 7.3.0.2 conversion to DATE isn't working any more (it just shows text
string as it is), while conversion to NUMBER seams ok.
--
You are receiving this mail because:
You are the assignee for the bug.
