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.