Apache OpenOffice (AOO) Bugzilla – Full Text Issue Listing |
Summary: | Date field in csv/txt file not imported completely | ||||||
---|---|---|---|---|---|---|---|
Product: | Calc | Reporter: | jmodzel <jmodzel> | ||||
Component: | code | Assignee: | frank | ||||
Status: | CLOSED FIXED | QA Contact: | issues@sc <issues> | ||||
Severity: | Trivial | ||||||
Priority: | P3 | CC: | issues | ||||
Version: | OOo 1.1 Beta | ||||||
Target Milestone: | --- | ||||||
Hardware: | All | ||||||
OS: | All | ||||||
Issue Type: | DEFECT | Latest Confirmation in: | --- | ||||
Developer Difficulty: | --- | ||||||
Attachments: |
|
Description
jmodzel
2003-04-12 03:53:00 UTC
Hi, this is not a bug. I've tested it and the values came in smoothly. Only thing to do was to set the numberformat to date hh:mm:ss . SoI've to close this as worksforme. Frank closed worksforme Got the file and will attach it. Reopen this Issue as it is reproducible now. Frank Created attachment 5674 [details]
Space separated file
Hi Eike, open the attached file and set the first column to YMD format. The date is imported in the correct way but the time changes. Frank Oooppps, forgot to set the Plattform and OS. Frank Set the Target. Frank First of all, there is no date field in the file. The date/time combination is enclosed in double quotes and as such is explicitly defined to be a text field. That setting the field type to date really does result in a date in this case is more luck than it was intended. However, I understand that it might be desirable to have this as a defined behavior, and to also include the time value then, but this certainly won't make it into OOo1.1 Changing type to Enhancement, lowering priority to P4, and setting target to OOo2.0 I stand corrected. Calc erroneously assumes that fields embedded in quotes have to be literal strings. Instead the string with quotes removed/unescaped should be parsed for numerical values, if not specified otherwise in the import dialog. The problem with CSV is that it is widely used but there's no real standard specification (I like the suggestion that the "V" in the acronym stands for "Vague" instead of "Values"). See also http://www.wotsit.org/download.asp?f=csv http://www.creativyst.com/Doc/Articles/CSV/CSV01.htm http://www.python.org/peps/pep-0305.html Raise prio to P3 (only for statistical reasons to indicate that this really should go into OOo2.0). Actually this is a defect, even if the result will be an enhancement. On branch cws_src680_csvio: sc/source/ui/docshell/impex.cxx 1.29.12.2 Reopen to reassign. Reassign to QA. Restore status. Found fixed on Solaris, Linux and Windows using CWS cvsIO Found fixed on Master src680m62 using Linux, Solaris and Windows Build |