https://bugs.freedesktop.org/show_bug.cgi?id=69050
Priority: medium
Bug ID: 69050
Keywords: regression
CC: [email protected]
Assignee: [email protected]
Summary: Calc: Import CSV dates are no longer recognized
Severity: normal
Classification: Unclassified
OS: All
Reporter: [email protected]
Hardware: Other
Status: UNCONFIRMED
Version: 4.1.0.4 release
Component: Spreadsheet
Product: LibreOffice
Calc no longer automatically detects dates in a CSV file import as dates, even
when the "Detect Special Characters" is set to "on".
Steps to reproduce:
* Open the sample import.csv file
* Choose Separated by Comma
* Look at the first column, they are not dates (you can prove it with formulas
or formatting)
This was never a problem in OO, or in LibreOffice up through and including
4.0.2. It appears to be a regression as of 4.1.0, and is still a problem in
4.1.1.
The only workaround is to manually tag each date field as a date when
importing, which is very time consuming if you are importing many date fields
(and very confusing for those who never had to do this before).
I also tested various date formats in the import file, MM/DD/YYYY, MM/DD/YY,
YYYY/MM/DD, and YYYY-MM-DD, didn't matter- none of them worked. Language:
"Default - English (USA)"
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
