Issue 6624 - OpenOffice Calc - Insert External Data not possible?
Summary: OpenOffice Calc - Insert External Data not possible?
Alias: None
Product: Calc
Classification: Application
Component: code (show other issues)
Version: OOo 1.0.0
Hardware: PC Windows 98
: P3 Trivial (vote)
Target Milestone: ---
Assignee: niklas.nebel
QA Contact: issues@sc
: 10393 (view as issue list)
Depends on:
Reported: 2002-07-28 17:03 UTC by trewitt
Modified: 2003-09-08 16:55 UTC (History)
1 user (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Screenshot of errant Insert External Data dialog (13.73 KB, image/jpeg)
2002-07-28 17:13 UTC, trewitt
no flags Details
simple HTML table which cannot be inserted (1.24 KB, text/html)
2002-07-29 17:48 UTC, trewitt
no flags Details
... (1.17 KB, text/plain)
2002-07-29 20:58 UTC, lars
no flags Details
screenshot: file+no extension enables OK button (20.48 KB, image/jpeg)
2002-07-29 21:32 UTC, trewitt
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description trewitt 2002-07-28 17:03:31 UTC
I am attempting to import a table from a saved web page file (.htm) into
OpenOffice Calc (spreadsheet), with no luck.

The "OK" button in the (Insert) External Data dialog always remains inactive
(greyed out), regardless of  data source or file type.  In addition, there
appears to be no mwans available for entry of data into the "Available
tables/ranges" field.

This dialog does NOT function as described in the Help system.

The symptoms remain unchanged after re-installation with v 1.0.1.

Thanks for any pointers...
Comment 1 trewitt 2002-07-28 17:13:11 UTC
Created attachment 2377 [details]
Screenshot of errant Insert External Data dialog
Comment 2 lars 2002-07-28 18:24:48 UTC

*** This issue has been marked as a duplicate of 1834 ***
Comment 3 frank 2002-07-29 07:46:03 UTC
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>).

Comment 4 frank 2002-07-29 07:47:04 UTC
I take it

Comment 5 daniel.rentz 2002-07-29 11:02:40 UTC
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.
Comment 6 frank 2002-07-29 11:08:26 UTC
Hi Niklas,

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

Comment 7 trewitt 2002-07-29 17:48:52 UTC
Created attachment 2384 [details]
simple HTML table which cannot be inserted
Comment 8 trewitt 2002-07-29 17:55:00 UTC
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.

Comment 9 lars 2002-07-29 20:56:09 UTC
Uh, oh,  I know the "problem" with issuezilla (see issue 6525), but 

there is code added to popup.htm I think the author didn't intend to 
be there...
Comment 10 lars 2002-07-29 20:58:16 UTC
Created attachment 2386 [details]
Comment 11 lars 2002-07-29 21:02:46 UTC
[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?
Comment 12 trewitt 2002-07-29 21:32:26 UTC
Created attachment 2387 [details]
screenshot: file+no extension enables OK button
Comment 13 trewitt 2002-07-29 21:53:59 UTC
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
Comment 14 helmerj 2002-11-26 22:41:33 UTC
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. 
Comment 15 niklas.nebel 2002-12-09 11:05:58 UTC
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.
Comment 16 daniel.rentz 2003-01-06 14:18:46 UTC
*** Issue 10393 has been marked as a duplicate of this issue. ***
Comment 17 olo 2003-06-03 12:22:51 UTC
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.
Comment 18 frank 2003-08-07 15:39:36 UTC
set to verified
Comment 19 frank 2003-08-07 15:41:22 UTC
closed verified