Removing Openoffice Calc Hyperlinks
This wasn't obvious, so I feel obliged to post. Removing hyperlinks in OpenOffice Writer has been discussed accurately in many weblog posts, but the same is not true for Calc. The only way I've found to remove hyperlinks in Calc is to highlight the text in the formula bar (not in the spreadsheet cell), then click the hyperlink button and clear the hyperlink text (then click "Apply" and "Close"). Also clear the url out of the hyperlink dialog's "mail and news" and document tabs. Turn off url recognition in Tools->Autocorrect->Options. Hope this helps someone.