[Libreoffice-bugs] [Bug 127484] New: use HTML caption tag to name externally linked tables from URL

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=127484

            Bug ID: 127484
           Summary: use HTML caption tag to name externally linked tables
                    from URL
           Product: LibreOffice
           Version: 6.3.1.2 release
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: enhancement
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: stephane.guillou at member.fsf.org

Description:
Currently, using a website URL in "Sheet > Link to External Data..." only shows
a list of generic identifiers of the type "HTML_1", which makes it difficult to
identify the right table when there are many available.

The HTML <caption> tag could help telling the tables apart.

Steps to Reproduce:
1. Open Calc
2. Go to "Sheet > Link to External Data..."
3. Paste a URL in "URL of External Data Source", for example
https://en.wikipedia.org/wiki/QS_World_University_Rankings
4. Press Enter on the keyboard
5. Use defaults in the "Import Options" dialog and click "OK".

Actual Results:
The "Available Tables/Ranges" show a list of tables named
"HTML_<positional_number>. (see attached screenshot)

Expected Results:
Naming the tables in the list with whatever is between the corresponding
<caption></caption> – if found when parsing – could help identify the right
one. For example, the tables could be named with the pattern:

HTML_<positional_number> - <first 40 characters of caption>...


Reproducible: Always


User Profile Reset: No



Additional Info:
Tested with:

Version: 6.3.1.2
Build ID: 1:6.3.1~rc2-0ubuntu0.18.04.1~lo1
CPU threads: 8; OS: Linux 4.15; UI render: default; VCL: gtk3; 
Locale: en-AU (en_AU.UTF-8); UI-Language: en-GB
Calc: threaded

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20190910/9004ce07/attachment.html>