Inserting Hyperlinks


You can add a hyperlink to a Jedox Web Spreadsheet from the Insert tab:

The following dialog box is displayed. The various fields in the dialog are described below the screenshot.

Destination Tab

Fill in the Text to display field to add the name of the hyperlink to be displayed in the cell. Screen tip lets you choose the text that is displayed when you move the mouse over the link. The Default option also shows the path to the target file, while the Simple option shows nothing.

Note: Text to display cannot be used as a reference in a formula.

Instead of text, you can also select a cell reference. But a cell reference will only be updated when you create or edit the hyperlink. If you want continuous updating, use the HYPERLINK() function with the Function Wizard.

Named ranges can’t be used at all for these values, although you can use them with the HYPERLINK() function in the Function Wizard.

Transfer Tab

In addition to the standard hyperlinks from worksheet cells, worksheets, files, websites or email addresses, a second tab called Transfer is available. You can transfer cell contents to new cells with this tab:

This hyperlink will copy the contents of the cells Sheet1!A1:A5 of the actual file to the cells Sheet5!G1:G12 of the file that is defined in the “Destination” tab. Before clicking OK, you have to confirm your transfer entries with the update button (note that these cell references will update each time you run the hyperlink).

Note: if a spreadsheet cell contains a PALO.DATA formula, and a value is set in this cell via a hyperlink transfer, the formula will not be overwritten. Instead, the set value is sent to OLAP for writeback.

If you want the value to be splashed, you need to prefix the value with a splashing-command character (such as # or !). For example, in a hyperlink, you could use concatenation like this (given that the value from cell A1 is to be transferred): …,”#”&A1,…

In Display in frame – Options, the following options are available:

Target type Target is in Jedox Web Target is external URL
_new Opens target link in new WSS tab (DEFAULT). Opens target in a new browser window or tab with limited browser UI.
_blank Opens target link in new browser window.
Note: after executing the function with this target, the same report cannot be opened within Jedox in some other context for the remainder of the current session.
Opens target in a new browser tab
_self Closes current file and opens target link in the same tab. Not supported as types for external hyperlink targets.
_top Closes the current frameset (or current file) and opens target link in the same tab. Not supported as types for external hyperlink targets.
FrameN Should only be used in a frameset context. Opens the linked document in FrameN of the same WSS window Not supported as types for external hyperlink targets.

If you select “_new” or “_blank”, then the tab “Destination Window” will be activated. There you can enter additional information on the destination window of the link, e.g. size and location of the window.
With the option #_blank you can determine which elements should be displayed in the browser window (note: Jedox Spreadsheets always have scroll bars).    
Please note that not all browsers support all of the options. The functionality of a specific option depends on both the used browser and that browser’s specific version.                  

You also receive the dialog “Insert Hyperlink” when you right-click a standard chart and select from the context menu “Hyperlink …”. The Insert Hyperlink dialog is also displayed when you right-click a standard chart and select Hyperlink… from the context menu.

In addition to the recent transfer options, it is possible to transfer chart data from here:

Thus, it is possible to transfer a category label or a series label by clicking a chart element, and thus to start a command that marks the corresponding values in the associated table.

Hyperlinks between reports work better in combination with bundle exports/imports. By default, Hyperlinks created via the dialog Insert Hyperlink first try to locate the target workbook relative to the source workbook. If this lookup fails, the hyperlink will attempt to locate the target workbook based on the full, literal path, and finally it will look up by node ID, enabling a working hyperlink even if the target workbook was renamed.

Note: popular browsers (including Chrome and Firefox) block local links (e.g. to network drives) for safety reasons. This restriction doesn’t come from Jedox itself.
Destination Window Tab

This tab allows you to select the display settings of the window that opens when you link to a web page.