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 Menu.
- 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 ComboBoxes, ListBoxes, CheckBoxes, Buttons, DatePicker, and Labels.
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 ListBoxes.
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 a picture in a spreadsheet? See Inserting Pictures.
- 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 September 27, 2022