I am using LibreOffice Calc
I have copied some data into a spreadsheet
And there are some hyperlinks involved
I want the SRC URL to actually show up in the spreadsheet, rather than the clickable hyperlink
So, instead of this
It would show this
I want to get rid of the text overlay in the hyperlink and only show the raw URL
I could write a PHP script to do this myself…but I was hoping there is a way to do this in LibreOffice
Hi
You can Save As▸Flat XML ODF (.fods), then open the file with a text editor (e.g. NotePad++) to find & replace (enable regular expressions):
(http.*)(" xlink:type="simple">)([^<]*)(</text:a>)
$1$2$1$4
Regards
I have not enough points to upvote, but thanks, you save my day!
Same here, thanks!
Hi,
have a look at this thread.
https://forum.openoffice.org/en/forum/viewtopic.php?f=21&t=2762
There are some UDF (User defined Functions). One of them called “CELL_URL”. So, maybe your URL is in Cell “A1”, then
write in “B1” this:
=CELL_URL(2;1;1) → 2 = Sheet2 → 1=Row Index → 1=Column Index