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.