Ask Your Question
1

Convert clickable hyperlink to viewable URL

asked 2016-11-09 19:20:24 +0200

kingneil gravatar image

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

edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted
1

answered 2016-11-10 09:39:36 +0200

pierre-yves samyn gravatar image

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

edit flag offensive delete link more

Comments

I have not enough points to upvote, but thanks, you save my day!

martaczc gravatar imagemartaczc ( 2018-08-22 15:54:29 +0200 )edit
0

answered 2016-11-09 22:50:20 +0200

Craig22 gravatar image

updated 2016-11-09 22:51:14 +0200

Hi,

have a look at this thread. https://forum.openoffice.org/en/forum... 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

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2016-11-09 19:20:24 +0200

Seen: 3,465 times

Last updated: Nov 10 '16