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
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