Ask Your Question
0

Calc: creating a hyperlink from a web address

asked 2016-10-09 03:50:25 +0200

MikeAgner gravatar image

updated 2016-10-10 12:56:31 +0200

Lupp gravatar image

I am using LO version 5.1.3.2 under Win7. I am trying to insert a hyperlink into Calc from a web address. Under Excel, I would highlight the object {See below: Actually meant was a part of the text content of a cell. - Edited for clarity by Lupp}, then select Insert hyperlink from the insert menu, put in the web address and the highlighted object becomes a hyperlink

This doesn't work in Calc. It simply inserts the URL next to the highlighted object in the cell. How can I replicate Excel's action in Calc.

Thanks

edit retag flag offensive close merge delete

Comments

Actual objects like shapes, images, can also get assigned a hyperlink. They needn't contain any text for this. As you used the term "object" @pierre-yves samyn supposed you meant something of the kind.

Lupp gravatar imageLupp ( 2016-10-10 12:54:52 +0200 )edit

4 Answers

Sort by » oldest newest most voted
1

answered 2016-10-09 08:08:30 +0200

pierre-yves samyn gravatar image

Hi

The problem occurs with what kind of object?

Right Click a shape (rectangle, basic shapes, text box,etc.) or an image then Edit Hyperlink is ok on my platform (windows 7 - 5.2)

Regards

edit flag offensive delete link more
0

answered 2016-10-10 05:17:30 +0200

Ratslinger gravatar image

Running under Xubuntu 16.04 and using LO v5.2.0.4 I had no problem with assigning a Hyperlink to a word (or group of words) in a cell.

With something in a cell, I edited it, selected all text, chose from menu Insert->Hyperlink ( or Ctrl-K) and entered the address. The selected word (or words) changed in color from black on white background to blue on grey background. Ctrl-LeftMouseClick followed the link without problem.

edit flag offensive delete link more
0

answered 2016-10-10 03:35:33 +0200

MikeAgner gravatar image

A shape? No,just simple text in a cell. By way of explanation and description, try this; put a word in a cell that you can use to identify a web page, then highlight the word, then try to put that page's URL in using Insert Hyperlink. It won't work - instead of making that word a hyperlink, as you can in Excel, Calc just tries to put the URL in the cell along with the word you wanted to use.

Mike

edit flag offensive delete link more

Comments

This works perfectly for me. Did the highlighted word show in the line 'Text:' of the 'Insert' > 'Hyperlink' dialogue?
If not, the selection was broken by some inadvertend action - or there is a problem with your specific surroundings (UP e.g.) . Please report again.

Lupp gravatar imageLupp ( 2016-10-10 12:48:43 +0200 )edit

Nope, doesn't show up. Which version are you using? I haven't upgraded to the latest as yet.In the Insert menu, what selection did you make from the left column? Maybe that's my issue here.

MikeAgner gravatar imageMikeAgner ( 2016-10-10 23:41:35 +0200 )edit

OK almost there. I first copy the URL I want to use, then highlight the text I want to make a hyperlink, it shows up at the bottom, and under the Internet selection, I paste the URL, and the word changes to a link. Now how do I get it readable? Right now it's showing up as a grey background surrounding the link, which make it hard to read. I tried to change font, but that didn't work.

MikeAgner gravatar imageMikeAgner ( 2016-10-11 00:05:32 +0200 )edit
0

answered 2016-10-09 10:00:59 +0200

Lupp gravatar image

updated 2016-10-09 10:01:34 +0200

F2 -- Space -- BackSpace ?

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2016-10-09 03:50:25 +0200

Seen: 109 times

Last updated: Oct 10 '16