Apache OpenOffice (AOO) Bugzilla – Full Text Issue Listing |
Summary: | Date recognition broken - "feature" should be configurable | ||
---|---|---|---|
Product: | Calc | Reporter: | issues@www <issues> |
Component: | code | Assignee: | frank |
Status: | CLOSED FIXED | QA Contact: | issues@sc <issues> |
Severity: | Trivial | ||
Priority: | P2 | CC: | issues, rene |
Version: | 632 | ||
Target Milestone: | --- | ||
Hardware: | PC | ||
OS: | Linux, all | ||
Issue Type: | DEFECT | Latest Confirmation in: | --- |
Developer Difficulty: | --- |
Description
issues@www
2001-06-29 23:24:49 UTC
Hi Didier, it's yet configurable. If you have such values in a column, select the range (column) where these values appear, choose format cells from the context menu and go to the Tabpage Numbers. Select the category Text and press Ok. That's it. Best regards Frank It's not an Issue. Hi Didier, I've found out, that you import comma separated values. To avoid date recognition on import of such files simply select the column with such values (in the import dialog) and set the column type to text. This should solve your problem. Best regards Frank Hi Frank, thanks for your feedback. If I specify a column of type text when importing my CSV file, this works at first. But then I try to make a pivot table (DataPilot) from this data, and my headers are corrupted again because they're being mistaken for dates. So I stand by my original statement that the automatic date recognition is too intrusive. IMHO, there should never be a feature which corrupts data unless you take special care to avoid it. Why not consider as dates only what the user specified as such ? Best regards, Didier Hi Didier, as I stated in my first answer, it's configurable. The bug is that Datapilot changes textformat to Date format. So I reopened the Issue. Frank . Must change the data pilot field name handling. changing QA contact from bugs@ to issues@ nothing for ms_interop., so no blocking of 21783 *** Issue 22315 has been marked as a duplicate of this issue. *** *** Issue 25201 has been marked as a duplicate of this issue. *** Fixed with the changes for numerical grouping on CWS "grouping". reopening to reassign reassigning to QA for verification reset resolution to fixed verified in internal build cws_grouping found integrated on src680m50 using Linux, Solaris and Windows version if you stumble on this issue, you might want to check http://www.openoffice.org/issues/show_bug.cgi?id=87999 (which is still open) and vote for it. |