Even though spreadsheets in Jedox Web and Excel Add-in work in a similar way, there are some functionalities that are available only in Jedox Web or work slightly different than the ones in Excel Add-in. For more information on how to use them, see the questions below.
UI & Menus
- How do I use various Jedox tools to display and model data from a Jedox Database? See Query Tab in Jedox Ribbon.
- How can I use elements such as Comboboxes, Lists, CheckBoxes, Buttons, DatePicker and Labels to better display and access the data in my report? See Form Elements.
Data & Data Sources
- How do I automatically refresh my data? See Recalculate, Periodic Refresh, and Automatic Calculation
- How do I set restrictions for my data input using data validation? See Data Validation.
- How can I prepare data sources for data validation, DynaRanges, Comboboxes, and Lists? See Data Sources for Data Validation, DynaRanges, Comboboxes, and Lists.
Functions
- How do I create a shortcut to another location in my workbook? See HYPERLINK() Function.
- How do I translate keywords in a report? See LOCALIZE() function.
- How do I return various types of information such as user groups or Jedox Spreadsheet Server version? See INFO() Function.
Adding Elements to the spreadsheet
- How do I insert a function in a spreadsheet? See Inserting PALO Functions into Spreadsheets.
- How do I insert an image in a spreadsheet? See Inserting Images.
- How do I insert a hyperlink in a spreadsheet? See Inserting Hyperlinks.
- How do I use DynaRanges in my report? See DynaRanges.
Formatting
- How do I format cells? See Formatting Cells.
- How do I use conditional formatting? See Conditional Formatting.
Updated April 14, 2025