Apache OpenOffice (AOO) Bugzilla – Issue 1145
Date recognition broken - "feature" should be configurable
Last modified: 2013-08-07 15:15:02 UTC
I have had many problems with data files containing text looking vaguely like dates, but _not_ being dates at all. For instance I have a text file with the value 20-29 in a column, by which a mean a _range_. I want this to be considered as text. But the spreadsheet tries to convert those strings into dates, giving meaningless results and corrupting my data. I can't find a way to turn this feature off. The date recognition feature should be configurable (at least at an on/off level).
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.