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
Created attachment 166879 [details] ODS downloaded from google with IMPORTHTML fuction
The function it's not supported by LibreOffice, what you can do its change the bug in the 'importance' to enhancement.
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.