Removing hyperlinks in Calc

[userjoy]

I'm entering URLs in cells in a spreadsheet. Sometimes (not always! you go figure...) Calc converts them to hyperlinks. I can't figure out how to get rid of the links.

The OO help said I should go to format and then click default formatting - but that changes all kinds of other things without removing the hyperlink.

Also can someone direct me to how to set up the defaults so that URLs I put in cells never come out as hyperlinks unless I directly change them to be linked?

Thanks!

[ken johnson]

[userjoy]

Hmm. It seems that URLs aren't coming in hyperlinked now - but email addresses are. There is no autocorrect option to turn off email recognition.

But it's not consistent - the emails I cut and pasted in earlier were not hyperlinked, but the one I just pasted in is hyperlinked. The URL I just pasted in isn't.

Changing the autocorrect option didn't get rid of the existing hyperlink, but when I deleted it and copied it in again, it did come in unlinked.

[ken johnson]

I don't know if this is a ligitimate method, however, I had some cells formatted bold and with "www.ahyperlink.com" or "www.ahyperlink.org" as hyperlinks.
I selected the .com ones then used Find and Replace with .com in the "Search for" and "Replace with" text boxes. With "Current selection only" the only ticked option, after clicking the "Replace All" button the hyperlink was removed and the Bold formatting was unaffected.
The .org ones just required the same steps with .org in the "Search for" and Replace with" text boxes.

Ken Johnson
_________________
If your problem has been solved please add "[Solved]" to the beginning of your first post title (edit button).

[userjoy]

Yipes, that's pretty complicated to have to do every time I copy in a URL! In Word you right click on the link, and choose "remove hyperlink" and it's gone.

Maybe someone else knows of an efficient way to do the equivalent in OO?

[Jens S]

Just select the hyperlinked cells and then use CTRL+M (default format) - this will not work on the latest LibreOffice.

Jens

[userjoy]

That changes the font, which I don't want to do. At the moment I've gotten rid of the hyperlinks by deleting the hyperlinked ones I'd copied in and then typing them (which is all right if it's short, but a problem when they are convoluted), so I can't check if that would get rid of hyperlinks.

I did try that yesterday (though following the pull-down menus, not using ctrl-m) before I retyped the URLs, and it didn't get rid of the hyperlinks.

[Villeroy]

[Calc, Basic] Introspective cell functions function CELL_URL(sheet# ; row# ; col# ; [link#])
_________________
Rest in peace, oooforum.org
Get help on http://forum.openoffice.org

[userjoy]

Huh??? Do I have to know how to write code to get rid of hyperlinks in OO?

I thought the point of programs like spreadsheets & word processors is that we DON'T have to know how to program to use them!

[ken johnson]