Jedox Spreadsheet Basics

image_pdfimage_print

Jedox Spreadsheet is a browser-based spreadsheet program, similar to common spreadsheet programs such as Microsoft Excel and OpenOffice.org 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.

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.

image_pdfimage_print