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

Remove Hyperlinks

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


Joined: 21 Jun 2005
Posts: 5

PostPosted: Tue Jun 21, 2005 10:33 am    Post subject: Remove Hyperlinks Reply with quote

Sorry if this has been asked before but I can't see how to search threads here. I've been trying to find out how to remove a hyperlink in Spreadsheet without success. Anybody able to help?

Regards,
David Lee
Back to top
View user's profile Send private message Send e-mail
Dale
Super User
Super User


Joined: 21 Feb 2005
Posts: 1440
Location: Australia

PostPosted: Tue Jun 21, 2005 6:10 pm    Post subject: Reply with quote

There's probably a more elegant way of doing this, but

Select a cell near that which contains the hyperlink
Use tab/arrow keys to navigate to the cell with the hyperlink
Press the "Delete" key (or your system's equivalent)
Check "Delete All" and click OK
Hyperlink now banished to wherever they go when they die.
_________________
Dale
To err is human, but to destroy your slippers in the process takes a real son of a bitch: Me!

OOo documentation from the source
http://documentation.openoffice.org
Guides, FAQ, How Tos
Back to top
View user's profile Send private message
8daysaweek.co.uk
Super User
Super User


Joined: 29 Nov 2003
Posts: 2130
Location: UK

PostPosted: Wed Jun 22, 2005 1:52 am    Post subject: Reply with quote

Hi nhengineer,

If you want to remove the hyperlink while retaining the text of where the link points to, then select the cell(s) - using the method that Dale describes - then select Format > Default from the menus.

Also see: http://www.8daysaweek.co.uk/forums/viewtopic.php?p=174#174

HTH Smile,
_________________
James
www.8daysaweek.co.uk - A User-Focused OOo site
Back to top
View user's profile Send private message Visit poster's website AIM Address
nhengineer
General User
General User


Joined: 21 Jun 2005
Posts: 5

PostPosted: Wed Jun 22, 2005 6:22 am    Post subject: Reply with quote

James & Dale,

Thank for your quick response. What I had to do all yesterday was copy & paste the cell contents into NotePad, then copy & paste that back into the cell ...300 times. What fun!

Regards,
David Lee
Back to top
View user's profile Send private message Send e-mail
nhengineer
General User
General User


Joined: 21 Jun 2005
Posts: 5

PostPosted: Wed Jun 22, 2005 6:30 am    Post subject: Reply with quote

...and, YAHOO!!!, it WORKS

David Lee
Back to top
View user's profile Send private message Send e-mail
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