Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

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


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