Documentation/Calc Functions/HYPERLINK

From The Document Foundation Wiki
Jump to: navigation, search

Function name:

HYPERLINK

Category:

Spreadsheet

Summary:

When you click a cell that contains the HYPERLINK function, the hyperlink opens. If you use the optional CellText parameter, the formula locates the URL and then displays the text or number.

Syntax:

HYPERLINK("URL"[; "CellText"])

Returns:

Takes you to the associated hyperlink contained within the cell. The number 0 is returned for empty cells and matrix elements

Arguments:

URL is a string or a reference to the cell containing that string which specifies the link target.

CellText is the text or a numerical value or a reference to a cell containing that value which is displayed in the cell and will be returned as the result. If the CellText parameter is not specified, the URL is displayed in the cell text and will be returned as the result.

Additional details:

Im-jabber.svg

Note:
To open a hyperlinked cell with the keyboard, select the cell, press F2 to enter the Edit mode, move the cursor in front of the hyperlink, press Shift+F10, and then choose Open Hyperlink.

Examples:

Formula Description
=HYPERLINK("http://www.example.org") The function displays the text "http://www.example.org" in the cell and executes the hyperlink http://www.example.org when clicked.
=HYPERLINK("http://www.example.org") The function displays the text "http://www.example.org" in the cell and executes the hyperlink http://www.example.org when clicked.
=HYPERLINK("http://www.example.org";"Click here") The function displays the text "Click here" in the cell and executes the hyperlink http://www.example.org when clicked.
=HYPERLINK("http://www.example.org";12345) The function displays the number 12345 and executes the hyperlink http://www.example.org when clicked.
=HYPERLINK($B4) where cell B4 contains http://www.example.org The function adds http://www.example.org to the URL of the hyperlink cell and returns the same text which is used as formula result.
=HYPERLINK("http://www.";"Click ") & "example.org" displays the text Click example.org in the cell The function executes the hyperlink http://www.example.org when clicked.
=HYPERLINK("#Sheet1.A1";"Go to top") The function displays the text Go to top and jumps to cell Sheet1.A1 in this document.
=HYPERLINK("file:///C:/writer.odt#Specification";"Go to Writer bookmark") The function displays the text "Go to Writer bookmark", loads the specified text document, and jumps to bookmark "Specification".

Related LibreOffice functions:

None

ODF standard:

Section 6.11.3, part 2

Equivalent Excel functions:

HYPERLINK