Issue 6624

Created attachment 2377 [details]
Screenshot of errant Insert External Data dialog

,

*** This issue has been marked as a duplicate of 1834 ***

Hi Terry,

it's no double so I reopen it.

Could you be so kind and attach the file in question ?

AFAIK the external data dialog works with HTML files if a table inside
the file is defined (<table>...</table>).

Frank

I take it

Frank

While selecting the file in the file open dialog, you have to choose
file type "Web Page Query (OO Calc)".
Bug: This filter should be the default on importing external data.

Hi Niklas,

on the comment of Daniel, I think it's yours

Frank

Created attachment 2384 [details]
simple HTML table which cannot be inserted

In reply to Comments From Daniel Rentz 2002-07-29 03:02 PDT:

  >> While selecting the file in the file open dialog, you have to
  >> choose file type "Web Page Query (OO Calc)".
  >> Bug: This filter should be the default on importing external data.

Selection of file type in the Open dialog makes no difference. 

The OK button NEVER becomes active, and therefore can never be clicked.

To Frank and Niklas:

  I have attached the popup.htm file, as requested.

Uh, oh,  I know the "problem" with issuezilla (see issue 6525), but 
anyway:

there is code added to popup.htm I think the author didn't intend to 
be there...

Created attachment 2386 [details]
...

[You may ignore]

I just wonder:

has my IE filetype extension for downloaded files somehow changed on 
its own to be always html or does Issuezilla now chnage the type of 
all or of text files to be html so that that is the reason the file 
receives the extension html although I selected no extension?

Created attachment 2387 [details]
screenshot: file+no extension enables OK button

After reading the comment by Lars, I played around with file
extensions in relation to the Insert External Data dialog. 

If you rename your html file AND REMOVE THE EXTENSION ENTIRELY, then
the dialog will read the file, and apparently auto-intepret the
contents.  Two options are then presented in the "Available
tables/ranges" field, "HTML_all" and HTML_tables".  After selecting
either of these, the OK button becomes enabled. (See attachment
"calc_bug2.jpg" to see this)

Sadly, clicking OK simply entered the text "The link could not be
updated." in cell A1.

So close, yet so far away...


Lars --

In IssueZilla, you must select one of the available file types in the
radio button list when preparing to upload a file attachment.  This
allows IZ to store it for subsequent display in a browser-friendly
format.  That is, it does not 'trust' the file extension type (if any)
provided by your local native filesystem.  Apparently if you make no
selection, it defaults to 'text'.  Think cross-platform here...

I intentionally ran my sample popup.htm file thru HTML Tidy, to clean
it up for display.  The 'data' is sample only, and the comments are
intentional. 

This is not only true for html table import but also for plain tab - 
delimited text files. I have a very big one that didn't work but I also 
failed to insert data from a short test file: 
 
1       we      erer    wewe 
2       ljkh    lkj     lkjlkj 
3       ljh     lkj     lkj 
4       kjh     kjh     kjh 
 
The file is correctly read and shown in the file import dialog. It 
automatically chooses tab as the defaulkt which is fine for this file and 
the data is shown correctly in a table that looks the way I want it. 
after closing this dialog and returning to the previous one I am 
presented with the proper path the choesen file to import a greayed 
out "OK" and nothing in the file range slector field. This field stays 
empty until eternity.  
 
I tried this on Linux -PC using 1.0.1 and the lates 643C build. 
 
Juergen 
 
 

The problem with the wrong filter for HTML files has been fixed
(internal ID #92296#), the fix will be in a future 644 build.
Plain text files can't be used with Insert/External Data because there
are no named ranges. Use Insert/Sheet instead.

*** Issue 10393 has been marked as a duplicate of this issue. ***

Microsoft Office is able to import data from sources without named
ranges into sheets.

It just slurps all the data it can find (for text files it's obvious,
for spreadsheets without named ranges it determines the boudaries of
sheet area being in use and imports in its entirety, including holes).

I provide MS Office training and consultancy and I know from my
experience that most users intuitively expect this behaviour.

set to verified

closed verified