Jedox Spreadsheet Basics


Jedox Spreadsheet is a browser-based spreadsheet program, similar to common spreadsheet programs such as Microsoft Excel and Calc. In addition, Jedox Spreadsheet has been enhanced to read and write data directly from Jedox OLAP and create appropriate reports.

Note: Jedox Spreadsheet does not support  R1C1 reference style (cell addresses in row/column reference style)!

Creating a new Spreadsheet

To create a new spreadsheet, navigate to Report Designer – Default – Public Files in the left-side navigation pane. Then click on New – New Spreadsheet in the Report Designer window on the right. 

Name the file ‘Test1’ and start it with a double-click:

You can change the look and feel of the Spreadsheet Editor Toolbar by setting it as a Classic Toolbar, Ribbon or Simple Ribbon. For more information, see Options Dialog.

Note: The Simple Ribbon is the default option.

Hiding and unhiding sheets

You can hide specific sheets in a workbook. This allows you to add meta content which is not meant for a resource workbook. Hiding simplifies the workbook design process.

To hide a sheet, right-click it on the sheet selector in Report Designer and select Hide. The sheet is no longer visible in Reports, Report Designer and the generated PDFs. To view and edit the sheet again, right-click any sheet on the sheet selector in Report Designer and select the sheet you want to display. You also have the option to display all the hidden sheets:

When using the Find command (CTRL+F) in Jedox Web, you have the option to search the entire workbook. To enable this, select Options on the Find and Replace window. On the Within option, select Workbook.

In Jedox Web, this option will only include the hidden sheets as well. In the Excel Add-in, hidden sheets will not be included in the search results.

Defining Styles for Jedox Spreadsheets

In Jedox Spreadsheets, styles are configured very much like in other commonly used spreadsheet programs. You select the area you wish to apply a style to and click on the Cell Styles icon in the toolbar:   

Jedox additionally offers support for inheritance between workbooks, meaning that you can create a consistent look across all of your reports. You can  define styles (colors, number formats, etc.) for a spreadsheet, and use the style on several cells in the spreadsheet. Any change of the style will then be reflected in all the cells where it is used.

If a spreadsheet has another spreadsheet defined as a resource, all styles that are defined in the resource are automatically inherited by the spreadsheet and can be used there.