I want to write a macro that updates a sheets link to external data. The data is a table in an HTML-file.
I’ve looked at Document.SheetLink
but it seems there is no actual link there altough there is one entry, and I can’t seem to write to that.
I’ve also tried Sheet.Link(url, sheet, filter, filter_options, mode)
and it seems that updates some type of link because if the URL is incorrect Calc displays “Link could not be updated” and shows the incorrect link. But if the link is correct nothing changes.
I’m doing this in LibreOffice Basic.