On Sat, 2007-11-10 at 19:57 +0000, Brian Barker wrote: > >But OOCalc can not find any data range to import > >from that file. How to use it?
> >I do: insert -> link to external data, select > >the file, Text Import box appears showing my > I don't think you can do this. CSV is not a real > spreadsheet format, of course, just a way of > listing tabulated data in plain text. So there > is no way to include a data range name in the CSV > file itself. It would be nice to just tell OOCalc, that all the data there should be used as one data range. > o Open your CSV file in a text editor and select and copy all the text. Yes, I do this now, works quite fine > If you particularly didn't want the CSV sheet > itself to appear in the spreadsheet, you could do > this indirectly, pasting the text from the CSV Perhaps there is some other format that is text based, record-per-line but allows to define named ranges? -- Rafał Maj Biuro: +48 505-077-958 [EMAIL PROTECTED] Katarzyna Dela 8:00-16:00 "LimCore" Rafał Maj - Al. Pokoju 29/9, Kraków 31-564 REGON 120338944 NIP 945-194-72-78 --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
