Convert clickable hyperlink to viewable URL

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

Google

It would show this

http://www.google.com

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 AsFlat XML ODF (.fods), then open the file with a text editor (e.g. NotePad++) to find & replace (enable regular expressions):

  • Find: (http.*)(" xlink:type="simple">)([^<]*)(</text:a>)
  • Replace: $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