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 In-Memory DB and to create appropriate reports.

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

Creating a New Spreadsheet

The quickest way to create a new spreadsheet is to click
the button  on Jedox start screen. You will receive an empty workbook.

Or you can navigate to Designer – Default – Public Files on the left-side navigation pane. Then click on New – New Spreadsheet in the 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 User Settings.

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 Designer and select Hide. The sheet is no longer visible in Reports, Designer and the generated PDFs. To view and edit the sheet again, right-click any sheet on the sheet selector in 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 include the hidden sheets as well. In the Excel Add-in, hidden sheets will not be included in the search results.

Using Color Picker

Color Picker can be used for fonts, cell borders and to fill cells.

You can start Color Picker in Simple Ribbon – Design with the red signed buttons:

or with right-click in a spreadsheet cell and “Format cells…“:

The Color Picker displays two color sets: standard colors and design system colors. The latter includes colors that are part of the Models design system.
Furthermore there are displayed recent used colors. The last ten colors chosen by individual users are retained by the Color Picker, even after logout/login. 
And you can use the button “More colors” to define your own color.

Defining Styles for Jedox Spreadsheets

In Jedox Spreadsheets, styles are configured very much like in other commonly used spreadsheet programs.
You select the area to which you wish to apply a style and click on the Cell styles icon in the Design-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 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.