Designer Mode and User Mode


Two modes are available in a Jedox Spreadsheet: Designer Mode and User Mode.

Designer Mode is used to create an application. A worksheet is created with formulas, formats, etc. The cells available for data input in User Mode are then specified by selecting ‘Locked’ or ‘Unlocked’ (Under Format – Cells… – Protection – Lock Cells).

In User Mode you can now work with this application. You may only enter data into cells that are ‘unlocked’. Other than this, you may not make any changes to the application in User mode.
However, it is not possible in User Mode, to switch to other sheets. Also links to other worksheets are not executed. For tests of cells that leave the current sheet, the modul Reports must be used.

You can switch to User Mode under View:

This command is also available as a button on the toolbar:

The “Close” button in User Mode will take you back to Designer Mode:
At the bottom right-hand side in the Jedox Spreadsheet worksheet, you will see the mode that you are currently in:



As long as a worksheet is open in User Mode, Designer Mode is suspended for this worksheet.