Creating a New Widget

image_pdfimage_print

To create a new widget in a Jedox spreadsheet, open Tools→Widgets→Custom Widget. The following dialog appears: 

General tab
Widget Name Name of the widget. This will also be the named formula by which you could access data received from the widget code (if any).
Content The content (code) of the widget. This can be retrieved directly from an external URL, or you can define the HTML code yourself. To link to content in the Report Designer, use the @ character. For example, @//Default/Public Files/mywidget.html
Note: the @ syntax will only work for HTML/JavaScript-based widgets, NOT for widgets using PHP code. 
Source The source of the data that you want to pass to the widget (if any). This can be a cell (or cell range), named range, variable, macro function, or a subset list.
Target The target to which the widget will return data. It can be a cell (or cell range), a named range, or a variable.
Size & Position tab

Here you can customize the size and position of your widget. Settings are in pixels.

Layout options tab

In the Layout options tab, you can toggle the following options:

  • Show borders in user mode: selecting this option displays
  • Transparent background: if set, the <body> of the document inside the widget should also have transparent background or it should be set to transparent, as in: <body STYLE=”background-color: transparent;”>)

 

image_pdfimage_print