[Solved] How to delete or remove a hyperlink

Discuss the spreadsheet application

[Solved] How to delete or remove a hyperlink

Postby tamalita » Wed Jan 02, 2008 5:57 am

I have a list of email addresses in one of my columns; I do not want them to be hyperlinked. I imported the data from MS Office Excel and the imported data are not hyperlinked; however, new entries into Calc are hyperlinked. I have looked at the hyperlink options and remove hyperlink does not seem to be an option. Is there a way to remove a hyperlink while keeping the text? Is there a way to turn off hyperlink recognition in Calc? I have read that you can do this in the word processing software.

Thanks!
Last edited by Hagar Delest on Tue Jun 10, 2008 3:51 pm, edited 2 times in total.
Reason: tagged the thread as Solved.
Tamalita
OpenOffice 4.2.6.3 | Win 7 Pro
tamalita
 
Posts: 8
Joined: Mon Dec 31, 2007 8:43 pm

Re: How to delete or remove a hyperlink

Postby acknak » Wed Jan 02, 2008 6:17 am

To convert the links to plain text, select the cells containing links and do: Format > Default

To turn off the recognition, do: Tools > Autocorrect > Options > URL Recognition = OFF

That setting will apply to all the OOo apps.
AOO4/LO5 • Linux • Fedora 23
User avatar
acknak
Moderator
 
Posts: 22756
Joined: Mon Oct 08, 2007 1:25 am
Location: USA:NJ:E3

Re: How to delete or remove a hyperlink

Postby tamalita » Sun Jan 13, 2008 9:06 pm

thank you!
Tamalita
OpenOffice 4.2.6.3 | Win 7 Pro
tamalita
 
Posts: 8
Joined: Mon Dec 31, 2007 8:43 pm

Re: [Solved] How to delete or remove a hyperlink

Postby FeraTechInc » Fri Feb 08, 2008 1:38 am

Wow that isn't the least bit intuitive or easy to use.
FeraTechInc
 
Posts: 9
Joined: Fri Feb 08, 2008 1:23 am

Re: [Solved] How to delete or remove a hyperlink

Postby EllyHood » Sun May 29, 2016 11:25 pm

I know I'm resurrecting a dead thread, but this is the first thing that pops up in a google search for this issue.
Unfortunately, "default formatting" removes specialized bullets in a slideshow (and I cannot for the life of me figure out how to insert those specific blue arrow bullets, no not the ones with a shadow from the bullets menu) and URL recognition is already off. This is infuriating...
OpenOffice 3.4.1 on MacOS 10.11.3
EllyHood
 
Posts: 3
Joined: Fri Mar 11, 2016 8:18 am

Re: [Solved] How to delete or remove a hyperlink

Postby acknak » Tue May 31, 2016 3:23 pm

Sorry, I'm not sure I understand what you're doing/looking for.

Why don't you start a new topic and explain exactly what you're doing and what the problem is. Are you using Calc? You mentioned a presentation?

It might be simpler to explain if you attach a small sample document on the new topic, so we can see just what you're working with.
AOO4/LO5 • Linux • Fedora 23
User avatar
acknak
Moderator
 
Posts: 22756
Joined: Mon Oct 08, 2007 1:25 am
Location: USA:NJ:E3

Re: [Solved] How to delete or remove a hyperlink

Postby newperson » Thu Jan 12, 2017 11:48 pm

The viewer asked if you can remove URLs then not have the appearance of the cell change.
Software openoffice 3.1 windows 10 from
newperson
 
Posts: 10
Joined: Thu Jan 12, 2017 11:42 pm


Return to Calc

Who is online

Users browsing this forum: robleyd and 35 guests