XLCubed is now FluenceXL. The new wiki can be found here: https://help.fluencexl.com/

Difference between revisions of "XL3WebReportLink"

(Initial version)
 
(Parameters)
Line 21: Line 21:
 
| The type of link. Only used from the XLCubed Web Edition
 
| The type of link. Only used from the XLCubed Web Edition
 
{|
 
{|
| 1 || Existing window (default)
+
| 0 || Existing window (default)
 
|-
 
|-
| 2 || New window
+
| 1 || New window
 
|}
 
|}
 
|-
 
|-

Revision as of 10:58, 28 September 2011

Creates a hyperlink that opens an XLCubed Web report and optionally sets web parameters.

Use the Insert Formula > XL3WebReportLink menu or ribbon item to insert the formula using a wizard.

Syntax

XL3WebReportLink( Report, [Link Text], [Link Type], [Param1], [Value1],…, [Param13], [Value13] )

Parameters

Parameter Description
Report A piece of text, indicating the relative path of the report
Link Text The jump text or numeric value that is displayed in the cell. If Link Text is omitted, the cell displays the full web address as the text
Link Type The type of link. Only used from the XLCubed Web Edition
0 Existing window (default)
1 New window
Param1,…, ParamN The name of the web parameter where the following Value is placed when the link is followed
Value,…, ValueN The value that will passed to the corresponding web parameter

See Also