Apache OpenOffice (AOO) Bugzilla – Full Text Issue Listing |
Summary: | Link External data needs graphical user interface | ||||||||
---|---|---|---|---|---|---|---|---|---|
Product: | Calc | Reporter: | xandros1 <npschwarz> | ||||||
Component: | open-import | Assignee: | AOO issues mailing list <issues> | ||||||
Status: | CONFIRMED --- | QA Contact: | |||||||
Severity: | Trivial | ||||||||
Priority: | P3 | CC: | issues, pagalmes.lists | ||||||
Version: | OOo 2.1 | ||||||||
Target Milestone: | --- | ||||||||
Hardware: | Other | ||||||||
OS: | All | ||||||||
Issue Type: | ENHANCEMENT | Latest Confirmation in: | --- | ||||||
Developer Difficulty: | --- | ||||||||
Attachments: |
|
Description
xandros1
2007-02-14 20:27:01 UTC
xandros1, please attach screenshot for how Excel does that. Thanks. *** Issue 74557 has been marked as a duplicate of this issue. *** Functionally the issue here is that the import routine lists the tables in the form as HTML_n where n relates the nth table reference in the form. The problem form most users is that they have to use trial and error to work out which to load as they have absolutely no cues. In fact if you do a show source, find an element in the table that you want and search back counting the "<table" tags, this gives you the "n" you need. A GUI would be nice as per Excel, but the main thing is that the user can simply reference the table that is wanted. A simpler functional alternative to the full GUI might be to parse the DOM and append the text strings from the first row so in the case of http://www.rate.co.uk/exrates.html for example, instead of listing HTML_13 you might get HTML_13 Country Currency $US £Stg €Euro ¥Yen (x100) This is enough to allow you to choose the table. Created attachment 43042 [details]
Image of Excel's import external data screen
You can see in the Excel screen shot that you can choose any one of the yellow arrows scattered through out the page to select that table or cell. In the example shown, the table I have chosen is marked by the green checkbox and highlighted with a gray box surrounding the table. I could have chosen any one of the individual stock prices within the box. But choosing the entire box gives all info within the box. This is much simpler to understand than a text list of 30+/- tables you would get with OOo. I wanted to show how OOo showed the same page but it would not load this page for some reason. Sorry first attachment didn't work I will try again. Attachment is named Excel Import data. Created attachment 43043 [details]
JPEG Image of Excel's import external data screen
Not a defect but an enhancement request, therefore re-assigned to requirements. Frank Newbie fed up with 13 years of Excel - This Issue is a dealbreaker or it's back I have to go. I'm still unable to use OO Calc for most daily chores because of its weak data import skill-set. It looks like Excel is really the Calc of choice for these tasks. I'd really like to see Calc's skill-set expanded as the other users have noted. |