Bernard Marcelly wrote:
Message de Fernand Vanrie date 2007-05-21 10:09 :
I am still waiting for some information about the logic off how csv
data-files are imported into a OO-flat-text-database
the format of the columns depend one data found on the second row of
the imported file, by trial and error i found that
"aaa" gives "text"
"10" gives "numeric"
"10/10/10" gives "date"
then i found other strange behavior but before i make an issue i wont
to now what is the exact logic behind this import-format behavior
thanks for any answer :-)
Hi Fernand,
This depends on the filter options, see Developer's Guide chapter
"Saving spreadsheet documents", section "Filter options for the CSV
filter"
<http://api.openoffice.org/docs/DevelopersGuide/Spreadsheet/Spreadsheet.xhtml#1_2_2_3_Filter_Options>
Bernard
Hello Bernard,
Thanks for this hint, but the doc you refferd to explains how to ad
options to the csv filter with tha API. what I want to understand is
how the OO-import-Wizard (the aplication who handles the conection
between a flat-text-database and a csv-file) transform the information
found on the second row to this famous formatcodes
1 = num
2= text
3= YY/MM/DD
etc....
I saw also that 9 = ignoring and that can explains why some colums als
simply ignored
thanks any how
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
