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]
