OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

removing hyperlinks

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc
View previous topic :: View next topic  
Author Message
malkyr
General User
General User


Joined: 07 Jun 2007
Posts: 5

PostPosted: Mon Nov 05, 2007 4:15 pm    Post subject: removing hyperlinks Reply with quote

This may be a stupid question but how can i remove hyperlinks from text I paste into scalc? I am copying text online and then pasting into scalc but even if I do paste special and select only text the hyperlinks remain. Deleting the url does not seem tot work either.
Back to top
View user's profile Send private message
peymanjahanbazi
General User
General User


Joined: 13 Oct 2007
Posts: 7

PostPosted: Mon Nov 05, 2007 10:52 pm    Post subject: Reply with quote

OpenOffice automatically detects Links in copied text or if you just input http://www.laliluna.de

Deleting or removing of this links is not very obvious. Here are two solutions to this.

1)

Click with the right mouse button, choose Character from the context menu. Select the tab Hyperlink and delete the URL.

2)

Select the hyperlink text and open the menu Format then choose Default. All formats including the hyperlink are deleted.

I hope I could help,
Back to top
View user's profile Send private message
wanwisa_u
Newbie
Newbie


Joined: 11 Jan 2010
Posts: 2
Location: Bangkok, Thailand

PostPosted: Mon Jan 11, 2010 6:05 am    Post subject: Reply with quote

peymanjahanbazi, non of your answer exist in my Calc. Shocked
Am I doing anything wrong?
_________________
Wanwisa U.
Back to top
View user's profile Send private message Visit poster's website Yahoo Messenger MSN Messenger
JohnV
Administrator
Administrator


Joined: 07 Mar 2003
Posts: 9183
Location: Lexinton, Kentucky, USA

PostPosted: Mon Jan 11, 2010 7:52 am    Post subject: Reply with quote

Use the arrow keys to move into the cell and do Ctrl+M.
Back to top
View user's profile Send private message
wanwisa_u
Newbie
Newbie


Joined: 11 Jan 2010
Posts: 2
Location: Bangkok, Thailand

PostPosted: Mon Jan 11, 2010 9:26 pm    Post subject: Reply with quote

JonhV, Thanks. It works by using Ctrl+M.
The reason that I can't follow peymanjahanbazi's suggestion because I don't have the same Context Menu. I installed OO 3.2 today but still don't have "hyperlink management" in the context. I suppose it comes from some extension. Thanks anyway.
_________________
Wanwisa U.
Back to top
View user's profile Send private message Visit poster's website Yahoo Messenger MSN Messenger
JohnV
Administrator
Administrator


Joined: 07 Mar 2003
Posts: 9183
Location: Lexinton, Kentucky, USA

PostPosted: Tue Jan 12, 2010 7:13 am    Post subject: Reply with quote

It's just getting into the cell without triggering the hyperlink that's tricky. Once in the cell plain Format > Default should also be available (not right click, Format > Default).
Back to top
View user's profile Send private message
kaoc
General User
General User


Joined: 22 May 2009
Posts: 5

PostPosted: Thu Mar 08, 2012 6:55 pm    Post subject: Reply with quote

Not clear what is the (1) way (in using Calc)

But, (2) works. And, it's very easy.

Ctrl-M = Default Formatting

peymanjahanbazi, Thanks

peymanjahanbazi wrote:
OpenOffice automatically detects Links in copied text or if you just input http://www.laliluna.de

Deleting or removing of this links is not very obvious. Here are two solutions to this.

1)

Click with the right mouse button, choose Character from the context menu. Select the tab Hyperlink and delete the URL.

2)

Select the hyperlink text and open the menu Format then choose Default. All formats including the hyperlink are deleted.

I hope I could help,
Back to top
View user's profile Send private message
ppetrovic
Newbie
Newbie


Joined: 09 Sep 2013
Posts: 1
Location: Bratislava

PostPosted: Mon Sep 09, 2013 12:17 am    Post subject: not in oo4 Reply with quote

none of these methods work in OO 4.0.0.
In addition, before saving, the cell contained something like this:

blablabla,
linked text

(linked text was on a new line because of wrapping of the cell content)

after re-openning the xls file, the cell contained:

blablabla, linked text

and the whole cell was hyperlinked, and wrapping did not work

the feature to remove hyperlink does not seem to be in any of the menus,
and default formatting changes colors of the text in the cell, but definitely
does not remove hyperlink.
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group