Issue 37151

Summary: Inserting External Data not possible from TXT file
Product: Calc Reporter: cakersq <cakersq>
Component: open-importAssignee: spreadsheet <spreadsheet>
Status: CLOSED DUPLICATE QA Contact: issues@sc <issues>
Severity: Trivial    
Priority: P3 CC: issues
Version: OOo 1.1.3   
Target Milestone: ---   
Hardware: PC   
OS: Windows XP   
Issue Type: DEFECT Latest Confirmation in: ---
Developer Difficulty: ---

Description cakersq 2004-11-15 07:55:29 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.
Comment 1 frank 2004-11-15 08:30:49 UTC
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 ***
Comment 2 frank 2004-11-15 08:31:08 UTC
closed double