Shortcuts and Special Commands in Jedox Spreadsheets

image_pdfimage_print

Keyboard Shortcuts

Alt + Enter

Inserts a line break when entering cell content in Jedox Spreadsheets.
(for Internet Explorer you have to use Ctrl + Alt + Enter )

Alt + F11

Opens the macro window from a spreadsheet in Report Designer.
Ctrl + Delete

In a cell with a PALO.DATA formula, Ctrl + Delete writes the value “0” (zero) in a numeric cell or an empty string in a string cell without deleting the existing formula. On consolidated numeric cells, the whole cube slice will be cleared.
In the Reports mode of Jedox Web, you can achieve the same result in unlocked cells by using the Delete key alone.

Ctrl + Enter
Deactivates an array function by selecting the whole function array and using this shortcut in the formula bar at the end of the function.
Ctrl + selected cells
To add a value to various, noncontinuous cells, select one cell, then hold the Ctrl key and select additional cells. Once the cells have been selected, enter the value and press the ENTER key. The value will then be applied to all of the selected cells.You can also use input via a data validation list or the copy command.
Note: it is not necessary to press Ctrl + Enter, as it is with Microsoft Excel.
Ctrl + Shift + Enter Activates an array function by selecting the whole function array and using this shortcut in the formula bar at the end of the function.
Ctrl + Q Rebuilds a Jedox View.
Esc Cancels changes to a formula (same as clicking the X button on the toolbar).
F4 Changes the type of a cell reference (adds or removes the $ character). It works after you have selected a part of the formula that is either a cell reference (i.e., A1)  or a range reference (i.e., A1:A4).
F9 Evaluates expressions in formulas and parts of formulas.
Page Up, Page Down Navigates up and down in Jedox Spreadsheets.
Shift + selected cells
To add a value to a continuous range of cells, select one cell, then hold the SHIFT key and select the last cell in the range.

 

Context menu command “Show Error”

With right click on a Jedox Spreadsheet cell you can select the command “Show Error”. This command brings up the Cell Error message window. If Jedox recognizes an error, you will receive a more accurate error message. If Jedox recognizes no error, you receive the message: “No error message found”.

image_pdfimage_print