If hyperlinks was made with Menu/Edit/Hyperlink, I think the only option is editing the ods file.
But if the hyperlinks show the link not other text, then it is possible convert the hyperlinks to text and add the HYPERLINK() function:
- select the cells with hyperlink
- clear the format (Ctrl-M)
- Find & Replace:
Change the url
- Find & Replace to add the HYPERLINK() function.
Search: .*
Replace: =HYPERLINK("&")
In more options activate regular expressions.
This is more flexible, beside it is possible create the hyperlink and the text to show from other cells, you can change it with F & R.
Syntax
HYPERLINK(“URL”) or HYPERLINK(“URL”; “CellText”)