You have landed at the right article if you want to remove hyperlinks from open office from a field or multiple field at once. Here , i will tell you the fastest way with which you can remove hyperlink in OpenOffice.
How to remove a Single Hyperlink from a field in Openoffice Calc
1 – Do a right click on the particular hyperlink you wish to remove.
2 – From the context menu , just click on Default formatting
3 – You have successfully removed the hyperlink.
How to remove Multiple Hyperlinks from a field in Openoffice Calc
Suppose you wish all hyperlinks from given columns at once. Here is how to do it.
1 – Do a right click on any hyperlink in that column.
2 – From the context menu , just click on Default formatting
3 – Now, select the required column , or press CTRL + A to select whole document at once (In case you want to remove hyperlinks from everywhere.)
4 – Finally Press CTRL+SHIFT+Y together.
Thats it. All the hyperlinks will be removed at once.
Note: Actually Pressing CTRL + Shift + Y together actually does a Repeat: Reset attributes on the document.