Bug 137884 - IMPORTHTML function is not supported
Summary: IMPORTHTML function is not supported
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
unspecified
Hardware: x86-64 (AMD64) All
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Calc-Function
  Show dependency treegraph
 
Reported: 2020-10-30 17:52 UTC by adomingo
Modified: 2020-11-03 21:47 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments
ODS downloaded from google with IMPORTHTML fuction (10.46 KB, application/vnd.oasis.opendocument.spreadsheet)
2020-10-30 17:54 UTC, adomingo
Details

Note You need to log in before you can comment on or make changes to this bug.
Description adomingo 2020-10-30 17:52:56 UTC
Description:
I have a ods document download from google sheets, which should get some tables from a webpage.

Instead of 

=IMPORTHTML("https://es.investing.com/funds/fundsmith-equity-fund-feeder-t-eurt";"table";1)

the ods appears like this:

=SI.ERROR(__xludf.dummyfunction("IMPORTHTML(""https://es.investing.com/funds/fundsmith-equity-fund-feeder-t-eurt"",""table"",1)");"")




Steps to Reproduce:
1. Open ods downloaded from google sheets
2. The formula with IMPORTHTML function, which should import a table from a webpage, appears like an error and doesn't works.

Actual Results:
The ods shows the formula like this:

=SI.ERROR(__xludf.dummyfunction("IMPORTHTML(""https://es.investing.com/funds/fundsmith-equity-fund-feeder-t-eurt"",""table"",1)");"")


Expected Results:
The formula should be like this:

=IMPORTHTML("https://es.investing.com/funds/fundsmith-equity-fund-feeder-t-eurt";"table";1)

An it should show a table imported from the webpage


Reproducible: Always


User Profile Reset: Yes



Additional Info:
I attach the ods downloaded from google sheets
Comment 1 adomingo 2020-10-30 17:54:28 UTC
Created attachment 166879 [details]
ODS downloaded from google with IMPORTHTML fuction
Comment 2 m.a.riosv 2020-10-30 22:03:12 UTC
The function it's not supported by LibreOffice, what you can do its change the bug in the 'importance' to enhancement.
Comment 3 adomingo 2020-11-01 10:15:07 UTC
I have changed it to enhancement.

Libreoffice currently has the option to import tables from a website:
https://wiki.documentfoundation.org/Faq/Calc/113

But it doesn't have the option to do it from a function. I imagine since is actually implemented this way, it could be easily adapted to be used as a function.

The perks of having this function supported by LibreOffice is that you can use it in common with INDEX function to specify the parameter you want to receive updated from internet, and on the other hand, it will make it compatible with the osd documents generated by google sheets, which at the current moment aren't.