Open Office Calc tips - How to change a URL field to a clickable link?

Started by certforumz, June 19, 2015, 01:24:02 AM

Previous topic - Next topic

certforumz

In Open Office CALC, you can change a plain url like
http ://www.yoursite.com to a clickable url by using the function =HYPERLINK(field)

To disable auto hyperlinking:
To convert the links to plain text, select the cells containing links and do: Right click and select Default Formatting.

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

That setting will apply to all the OOo apps

To know the length of a field, use =LEN(field) function.


Reference: https://forum.openoffice.org/en/forum/viewtopic.php?f=9&t=1310

certforumz

Suppose that a field contains a URL but it is not clickable. The you can make it clickable by using the following:
=HYPERLINK("http://www.example.org")

    displays http://www.example.org in the cell and opens the hyperlink http://www.example.org when clicked.

=HYPERLINK("http://www.example.org"; "Click here")

    displays Click here in the cell and opens the hyperlink http://www.example.org when clicked.

=HYPERLINK("[*url*]http://www.[*/url*]"; "Click ") & "example.org"

    displays Click example.org in the cell and opens the hyperlink http://www.example.org when clicked.

You may drag the formula to apply the same to all fields in the column.

Support A1=http:// www.anandsoft.com
then, you may be able to make A2 clickable by using the formula: =HYPERLINK(A1)
and dragging it down to all the fields in the column.
(You may need to insert a new column and later remove column 1)

Check this out:
https://wiki.openoffice.org/wiki/Documentation/How_Tos/Calc:_HYPERLINK_function