Skip to content

CHYPERLINK

The CHYPERLINK formula is used to create a hyperlink in Excel that opens the URL specified in the user’s default web browser.

Syntax

CHYPERLINK (URL, Target, Linktext, Tooltip, WebdisplayStyle, Width, Height, Arg1…Arg20)

Arguments

URL : string (required)

The Hyperlink destination

Target : string

Where to open the linked document (in HTML, the attribute element of the anchor tag).

Leave this argument blank if you are not trying to open in an iframe via the CREPORTFRAME formula

Default value: ""

Linktext : string

The text to display (instead of showing the full text of the URL)

Tooltip : string

The text to display on hover

WebDisplayStyle : string

How to open the linked document (ie display/open style) - choices are:

Value Behavior
“Normal” Uses normal browser behavior and loads the URL into the same tab as it was launched from, replacing the content
“NewTab” Opens in a new CALUMO Tab if in CALUMO Home or in a new browser tab if the report is in its own tab already.
“NewWindow” Opens the link in a new window
“Lightbox” Opens the link in a light box (zooms to the foreground while greying-out the background). The lightbox:close event can be used to be notified - in javascript asset code - when it’s closed.

Default value: Normal

Width : number

Width of display window (applies to WebDisplayStyle “NewWindow” and “Lightbox”)

Default value: -1 (automatically sized to 75% of screen width)

Height : number

Height of the display window (applies to WebDisplayStyle “NewWindow” and “LightBox”)

Default value: -1 (automatically sized to 75% of screen height)

Arg1 : string

First argument - all arguments are appended to the URL as a query string

ArgN : string

The nth argument, you can have up to 20 args.

Usage Scenarios

If WebDisplayStyle is not specified, the normal default will apply. The target is the name of the browser window or frame in which the URL will open and is commonly used in conjunction with the CREPORTFRAME “Name” argument.

The linktext argument can be passed a URI (url address to an image ie http://yourserver/calumo11/images/yourimagefile.jpg), and this image will then render when published.

Images, depending on their size, may create issues with freeze pane - if you cannot resize the image then one solution is ensure the image is rendered on both sides of the freeze pane.