https://bugs.freedesktop.org/show_bug.cgi?id=47331
Bug #: 47331
Summary: Link to External Data doesn't use Accept or
Content-Type and makes N requests
Classification: Unclassified
Product: LibreOffice
Version: LibO 3.4.4 release
Platform: All
OS/Version: All
Status: NEW
Severity: normal
Priority: medium
Component: Spreadsheet
AssignedTo: [email protected]
ReportedBy: [email protected]
When connecting to a data source via "Link to External Data", the Spreadsheet
doesn't set an Accept header, hence there is no way for a web server to know
which response file format is best for the user agent. We send plain text
formatted for human convention in this case... which obviously is the worst
possible case for this feature. If you have a good HTML parser that scans for
a TABLE object, then please add "Accept: text/html" to your request header?
It also seems the import doesn't look at the mimetype when receiving data, we
send back text/csv or text/tsv and your tool plus a marker saying it is UTF-8
encoded the link tool ignores this information, guesses incorrectly about the
structure of the text file, and prompts the user. If someone sets text/csv or
text/tsv they are probably following the RFC.
Furthermore, when we return an HTML file with a _single_ table, it prompts the
user to pick one of 3 tables. This user interface dialog doesn't make sense,
since the file itself has exactly one table. I don't know how it's listing
them.
Finally, this tool sends several PROPFIND and GET requests for a single open.
I'm not sure why PROPFIND is needed, but one GET should be sufficient.
Instead, each request amounts to ~8 PROPFIND, ~3 HEAD, and ~3 GET requests.
Being able to pull in web resources with this tool would be absolutely great.
If you would like to test, feel free to use:
http://demo.htsql.org/school
http://demo.htsql.org/school/:html
http://demo.htsql.org/school/:tsv
http://demo.htsql.org/school/:csv
Thank you kindly!
--
Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
