Functions can be inserted into spreadsheets through the Formulas menu item in the toolbar. Click on the Insert function button, as indicated below:
It works in much the same way as in Excel. Select Jedox from the category drop-down list (see screenshot below). This category includes all PALO functions available in Jedox Web.
Almost all Jedox Spreadsheet functions are programmed in the same way as the corresponding Excel counterparts. There are two exceptions: