HYPERLINK in Collabora Office: Create Labeled Web, File, and Workbook Links
Use Collabora HYPERLINK with explicit targets and labels, build internal navigation, and distinguish displayed text from the destination that opens.
Verification status: See the evidence and test scope described in this guide. How formula examples are checked
Quick answer: =HYPERLINK("http://www.example.org";"Open example") displays Open example and opens the specified URL when activated. The label and the destination are separate arguments.
Syntax and return value
=HYPERLINK("URL" [; CellValue])
URL is the required link target. CellValue optionally supplies the text or number displayed and returned as the cell result. If omitted, the URL itself is displayed and returned.
The vendor also says zero is returned for empty cells and matrix elements. That is distinct from omitting CellValue, which displays the URL; do not assume every blank-looking label behaves like an omitted argument.
Creating a formula is not the same as opening its destination. The documented activation opens the hyperlink. This guide does not claim that any web or file link was opened in Collabora.
Example: reproduce three display controls
Enter each formula separately:
| Formula | Documented display/result |
|---|---|
=HYPERLINK("http://www.example.org") |
http://www.example.org |
=HYPERLINK("http://www.example.org";"Click here") |
Click here |
=HYPERLINK("http://www.example.org";12345) |
12345 |
All three point to the same example target despite their different displays. A numeric CellValue does not change the link target into a number.
The example.org address is an illustrative public example, not a destination whose current page contents were verified by this guide. A label can remain visible even when its destination later changes or becomes unavailable.
Example: navigate within the workbook
Create or use a sheet named Sheet1. Enter:
=HYPERLINK("#Sheet1.A1";"Go to top")
The vendor’s documented display is Go to top, and activation jumps to A1 on Sheet1 in the same document. The leading # identifies an internal document target in this example.
Keep the sheet name and target cell explicit. Renaming or removing a destination requires checking the navigation formula; a friendly label alone cannot reveal a broken target.
Advanced application: build a reviewable link directory
Put a complete target in A2 and its intended label in B2, then use:
=HYPERLINK(A2;B2)
For A2=http://www.example.org and B2=Example reference, the expected displayed result is Example reference. Keep both input columns visible while reviewing a link list so the label cannot conceal an unexpected domain.
CONCATENATE can assemble text, but construct and inspect the complete intended target before turning it into a clickable link. Do not assume that a label resembling one domain means the URL points there.
Advanced example: a local document bookmark
The vendor’s example is:
=HYPERLINK("file:///C:/writer.odt#Specification";"Go to Writer bookmark")
Its documented purpose is to open the named Writer document and jump to the Specification bookmark. The expected display is Go to Writer bookmark. Successful navigation requires that the file and bookmark actually exist and are accessible on the user’s system.
The related folder example uses file:///C:/Documents/ to open that folder in the standard file manager. These are conditional local-path examples, not files created or opened for this guide.
Keyboard activation and platform differences
The help documents selecting the hyperlink cell, pressing F2, moving the cursor in front of the link, pressing Shift+F10, and choosing Open Hyperlink. Keyboard details may depend on the platform and configured shortcuts.
The function bridges some platform-specific paths: the source describes Windows c:\path to\file.ext becoming an appropriate file URI, and .. referring to the document’s parent directory. That does not establish that a Windows file path will work on every platform or after sharing the workbook.
Errors, privacy, and troubleshooting
Check the actual URL, path, sheet name, or bookmark rather than only the visible label. Inspect file links before sharing a workbook, because they can disclose private folder and document names. Avoid putting credentials or sensitive data in URLs.
A valid-looking formula does not establish destination safety, permissions, network availability, or file existence. The dedicated section does not provide a complete native error-code or URI-encoding matrix. IF can choose a display label, but a fallback label should not hide an unresolved or unexpected target.
Availability and verification
The exact function is documented in Collabora Office 26.04 desktop help, retrieved and reviewed on October 17, 2026. This establishes a documentation scope, not the first release that introduced the function or the last version in which it works; those versions and any retirement date remain unestablished. Collabora Online and mobile support are not inferred from desktop help, nor is behavior in another spreadsheet product.
The examples are documentation-based expectations with independent calculations. They have not been executed in Collabora Office. No application screenshot or native error/coercion certification is implied. Formulas use English function names and semicolon argument separators.
References
- Collabora Office 26.04: HYPERLINK (checked October 17, 2026).
- Editorial testing standards.