I have a spreadsheet with links to other spreadsheets.
I have noted that there is a huge difference in performance according to how I handle the hyperlink: inserting it as Edit → Insert → Hyperlink works very well and superfast. But if I add it as a function, ie = hyperlink(URL,“text in the cell”) it works surprisingly much much slower.
Is this a bug or it is just related to internal evaluation of the function?
I would love to trust the hyperlink as inserted from the Edit menu, but I had a big spreadsheet with links and it started crashing due to the links. Maybe it was due to the fact that the spreadsheet was originally created with OpenOffice, but just in case I want to make sure that it will not crash again, that is why I looked for another way to have links to other files in my spreadsheet.
Bug or not?
[Edit: I am using LibreOffice 220.127.116.11 My OS is Windows 7 64 bits. The document format is ods.]