Eric Wood wrote:
Unfortunately, many people have discovered this limitation in Calc.
soffice's file loader doesn't detect delimited text files (at all?)
and therefor always hands over control to Writer (even if you pass it
the -calc parameter which should have been good enough to persuade
it). On windows you must create a file association of .cvs for calc
(the installer doesn't give you this option which would have been
nice). However, once association is done, a tab delimited .csv file
will open into Calc after choosing the right delimiter in the parse
dialog. Again, the parse dialog doesn't correctly detect the right
delimiters of the file you're loading. So, yes, automation isn't
quite at the level of Excel and Quatro Pro in this regard.
-eric wood
And just to continue my griping, over 30 issues about CSV/TAB delimited
stuff:
http://www.openoffice.org/issues/buglist.cgi?issue_status=NEW&issue_status=STARTED&issue_status=REOPENED&issue_status=RESOLVED&issue_status=VERIFIED&issue_status=UNCONFIRMED&short_desc_type=allwords&long_desc_type=allwords&cmdtype=doit&short_desc=csv&long_desc=
most notably:
http://www.openoffice.org/issues/show_bug.cgi?id=15274
http://www.openoffice.org/issues/show_bug.cgi?id=4925
http://www.openoffice.org/issues/show_bug.cgi?id=34078
I just can figure out why we haven't perfected a 20 year old delimiter
standard!
-eric wood
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
