Author Topic: Open Office Calc tips - How to change a URL field to a clickable link?  (Read 1341 times)

Offline certforumz

  • Cert Exams
  • Administrator
  • Hero Member
  • *****
  • Posts: 826
  • Ask me a question ...
    • CertExams - CCNA, A+, Network+, and Others
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
« Last Edit: June 26, 2015, 12:34:19 PM by certforumz »

Offline certforumz

  • Cert Exams
  • Administrator
  • Hero Member
  • *****
  • Posts: 826
  • Ask me a question ...
    • CertExams - CCNA, A+, Network+, and Others
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
« Last Edit: July 07, 2016, 05:25:41 AM by certforumz »