CODEWITHSUNDEEP
hyperlinkopenoffice-calc
UKUser35
UKUser35

Reputation: 163

How to formulate a hyperlink in OpenDocument/ OpenOffice Calc

I am using Open Office Calc and trying to create a link to another worksheet but using the HYPERLINK formula function.

For some reason the following won't work and I cannot find the solution anywhere on the web.

=HYPERLINK(#New.A1,'new') and I've also tried =HYPERLINK(#New.A1;'new')

What is the correct way to do this?

Upvotes: 0

Views: 404

Answers (1)

Jim K
Jim K

Reputation: 13819

Use double quotes.

=HYPERLINK("#New.A1"; "new")

There is an example at https://help.libreoffice.org/Calc/Spreadsheet_Functions#HYPERLINK.

Upvotes: 1

Related Questions