Apache OpenOffice (AOO) Bugzilla – Issue 37151
Inserting External Data not possible from TXT file
Last modified: 2004-11-15 08:31:08 UTC
I am trying to insert data from a TXT file into the spreadsheet program. By going to Insert > External Data, I browse my local filesystem, find my .txt file with tabs denoted the columns, and carriage returns denoting the rows. The Text Import window appears and all of the settings are correct. I press OK to get back to the External Data window, but I cannot select the Rows or Columns to import (that field is empty/blank. The OK button is greyed out. There is a slight work around, which is by going to Insert > Sheet, and selecting from File. The same Text Import window appears with the same settings. This will work and write the data from the TXT document to the spreadsheet, but I need the self updating feature of the Insert > External Data to be working.
Hi, using the query facilities of Issuezilla would lead you to Issue 1834 which is a double to this one. FRank *** This issue has been marked as a duplicate of 1834 ***
closed double