Hi Fernand, side note: This mail is cc'ed to [EMAIL PROTECTED], where it fits better than [EMAIL PROTECTED] If you don't mind, I'd like to continue the discussion there, since more Base-interested users read there.
> That was the good news, now the bad:during my new testings i found some > strange behaviors ( text who is disappearing in a colum before a > date-formated column, wrong number formats.... ) but please before I > submit a issue http://www.openoffice.org/issues/buglist.cgi?Submit+query=Submit+query&issue_type=DEFECT&issue_type=ENHANCEMENT&issue_type=FEATURE&issue_type=PATCH&component=Database+access&issue_status=UNCONFIRMED&issue_status=NEW&issue_status=STARTED&issue_status=REOPENED&issue_status=RESOLVED&email1=&emailtype1=exact&emailassigned_to1=1&email2=&emailtype2=exact&emailreporter2=1&issueidtype=include&issue_id=&changedin=&votes=&chfieldfrom=&chfieldto=&chfieldvalue=&short_desc=csv&short_desc_type=allwords&long_desc=&long_desc_type=allwords&issue_file_loc=&issue_file_loc_type=fulltext&status_whiteboard=&status_whiteboard_type=fulltext&keywords=&keywords_type=anytokens&field0-0-0=noop&type0-0-0=noop&value0-0-0=&cmdtype=doit&namedcmd=dba9&newqueryname=&order=%27%27 gives you a list of known issues with CSV files, may be the ones you encountered are already knwon ... > give me some information how the 2de row is interpreted > by the filter. All the faulty behavior can come from the way I formated > this 2de row. That's a combination of magic, moon phase, and user name ... Just kidding, of course it's the computer name, not the user name ... Ehm, Roughly: The line is split into chunks, as indicated by the field separator. One chunk assembles one column If a chunk is empty, a string column is assumed. If a chunk contains only numbers and decimal and thousand separators (if they're set, and one at most), the column is considered to be numeric. Otherwise, a number formatter (that's basically the component which in Calc is responsible for displaying your numbers in all the different formats, and interpreting input you do in a cell) is asked whether it can detect any known date/time/datetime format in the chunk. For instance, 2007-12-01 would/should be recognized as date. Especially the last part with the dates might be tricky, I'm not actually sure which locale is used here - probably the system locale. In any case, I suggest you submit an issue for your problem, if you don't find it in the above list. Whether they denote a bug or a request for enhancement can then still be decided. Things like file content which is not shown at all definitely sounds like a bug. (Well, except the "known" cases where the second row contains a numeric value, but later rows contain strings in the same column. This is conceptually impossible to deal with.) Ciao Frank -- - Frank Schönheit, Software Engineer [EMAIL PROTECTED] - - Sun Microsystems http://www.sun.com/staroffice - - OpenOffice.org Base http://dba.openoffice.org - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
