Leonard Mada wrote:
Dear developers,
this issue slowly drives me crazy.
Unfortunately it is after *much work* that I discover again and again
that OOo Calc transforms perfectly valid code string into dates, like
in the example below.
These are international lab-codes from the LOINC database, but upon
importing Calc decies to transform them into DATES. Manually verifying
54,000 rows for OOo quirks is NOT going to be practical.
I still have some hope that Calc will once and for all remove the
automatic date identification.
Sincerely,
Leonard
LOINC table from:
http://loinc.org/downloads/files/loinc-table-ascii-text-format/gotoCopyrightedFile
Imported in Calc (after sorting and a lot of headache to find what was
wrong):
LOINC_NUM
01/08/09
08/03/09
11/07/09
03/04/09
05/09/09
12/05/09
06/07/09
02/06/09
09/01/09
10/09/09
04/02/09
07/05/09
13-3
[...]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
------------------------------------------------------------------------
No virus found in this incoming message.
Checked by AVG - http://www.avg.com
Version: 8.0.176 / Virus Database: 270.10.4/1880 - Release Date: 1/7/2009 8:49 AM
Hello Leonard:
When you import the file to Calc, change the field type of that column
to from "Standard" to "Text". This will import the file without
changing some of them into "Date" type.
TomW
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
