HYPERLINK Function in LibreOffice Calc — Tested Examples
An explanation of LibreOffice Calc HYPERLINK, including tested formulas, examples, expected results and common mistakes.
Tested: Examples checked in LibreOffice Calc 25.2.3.2. What this means
Construct a Hyperlink. The target in the example is https://example.com, but the cell displays the shorter label Example. This is useful for link directories and documentation indexes.
Syntax and arguments
=HYPERLINK(URL; Cell_text)
LibreOffice Calc formulas generally separate arguments with semicolons (;).
| Argument | Explanation |
|---|---|
URL |
The clickable URL. |
Cell text |
The cell text to be displayed. (optional) |
Worked examples
Example 1: Create a clickable hyperlink with descriptive link text
=HYPERLINK("https://example.com";"Example")
Expected result: Example. This value was returned in the LibreOffice Calc 25.2 test.
How to interpret the result
The target in the example is https://example.com, but the cell displays the shorter label Example. This is useful for link directories and documentation indexes.
Mistakes and troubleshooting
- Check inputs and assumptions: HYPERLINK returns a clickable link, not an HTTP response or confirmation that a website is safe.
- Check argument order and format: Strings go in quotes, cell references do not. Functions that return arrays may require special entry.
- Verify your own data: Reproduce the example first. If your formula returns an error, inspect the referenced cells and individual argument values.
Related functions
Tested version and primary reference
1 example(s) on this page passed real calculations in LibreOffice Calc 25.2.3.2. This is not a claim about every possible input or other spreadsheet applications.