Inserting PALO Functions into Spreadsheets

image_pdfimage_print

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. Jedox is preselected as the category, and all PALO functions are available in in the listbox. 

Almost all Jedox Spreadsheet functions are programmed in the same way as the corresponding Excel counterparts. There are two exceptions:

  • The Jedox Web HYPERLINK() function has more functionality than its Excel counterpart. For more information on this function, see HYPERLINK Function.
  • The Jedox INFO() function returns different information than its Excel counterpart. For more information on this function, see INFO Function.
image_pdfimage_print