Hi, I have lots of hyperlinks in a spreadsheet what have to be renamed in the same way (“file:///G:/” to “file:///U:/”). Most elegant way would be some ‘Edit → Find and Replace’, but I think that is not possible. Is there any other way, at least to find hyperlinks with a particular string in it?
CU, Rainer
When I solve a similar problem, I open a workbook with the archiver (7-Zip) and use the Find/Replace directly in file content.xml.
Hi John, I already tried similar tricks with unzipping, but I have had too much trouble iwth the rezipped documents.
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:
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”)
Thx for Ideas. I know HYPERLINK(), but that’s too sophisticated for a simple Link collection. I submitted “Bug 58096 - Allow to find and replace (hidden) properties like hyperlinks, picture names and descriptions, …” https://bugs.freedesktop.org/show_bug.cgi?id=58096
Why do you think it is no possible with F & R? Have you tried?
Search: file:///G:/
Replace: file:///U:/
Disable entire cell.
In more options disable regular expression an activate search formulas.
Hm, that really works for you? Not for me with parallel installation of “LOdev 4.0.0.0.beta1”. May be I should have written explicitly "Not text looking like hyperlink, but real hyperlink in a word not looking like the link itself?