« Help Digg the Great Story about OpenOffice.org 2.3! |
| Web 2.0 and Openoffice.org in the Netherlands »
Some people are having problems inserting data from a CSV or TXT file into a spreadheet, using Insert > Link to External Data.
If this doesn't work for you, try Insert > Sheet From File instead.
Posted at 06:01 AM in Calc, Open source, Opendocument format, OpenOffice, OpenOffice books, OpenOffice training, OpenOffice.org, Spreadsheets, StarOffice | Permalink
This answer and the linked bug solve nothing. I want an externally exported CSV to be inserted just like an HTML table, because a csv file posted under same location is how my bank makes current exchange rates available. Opening a local file is no solution at all, I'd have to manually download csv from the bank every hour or so and re-open it - idiotic.
Andy Brandt |
September 17, 2008 at 09:45 AM
I had the problem with both:
Open Office 1.13 (on XP and Win Me)
Open Office 3.0 (on XP)
"Insert > External Data" would not work with a .txt file exported from an ACT! database. I changed the extension to '.csv' as suggested on another page. It would identify every column correctly in the preview window, but 'ok' would be grayed out in the external data window. The above comment to use "Insert > sheet from file" worked just fine.
December 09, 2008 at 03:40 PM
Thanks, that works. I was having trouble with the latest dev version linking to a txt file, but the above suggestion works.
December 02, 2009 at 12:08 PM
The comments to this entry are closed.