https://bugs.documentfoundation.org/show_bug.cgi?id=92503
Bug ID: 92503
Summary: FILEOPEN: CSV - Certain date fields not imported
correctly, pattern detected
Product: LibreOffice
Version: Inherited From OOo
Hardware: Other
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Created attachment 117001
--> https://bugs.documentfoundation.org/attachment.cgi?id=117001&action=edit
CSV example file containing identically formatted dates, some correctly
imported and some not.
How to reproduce:
- Import the example CSV file (Insert -> Sheet from file)
- Set language to "English (UK)" or "English (US)"
- Import as single column (deselect all Separator options)
- Set the column type to "Date (DMY)"
- Press OK
Expected result: All rows are interpreted correctly as date values
Actual result: 3 rows are not imported as date values:
31 Mar 2013, 02:00
30 Mar 2014, 02:00
29 Mar 2015, 02:00
The offending pattern seems to be: (31-n) + " Mar " + (2013+n) + ", 02:00"
Other date fields with 02:00 seem unaffected.
Seen in:
- OpenOffice.org 3.3.0; OOO330m20 (Build:9567) on Windows 7 (64-bit)
- LibreOffice 4.4.3.2, Build ID: 40m0(Build:2), Locale: en_GB on openSuSE 13.1
(64-bit)
- LibreOffice 5.0.0.2.0+, Build ID: 2fa23d10c32f77da121ecf03f77ff3f10ca0d580,
Locale: en-GB (en_GB.UTF-8) on openSuSE 13.1 (64-bit)
--
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
