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 )
Ctrl + Delete

As of Jedox Version 7.0 SR2, you can use Ctrl+ Delete in one cell with a PALO.DATA formula to write the value “0” 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 “Report” mode of Jedox Web, you need on unlocked cells only the Delete key to receive the same result.

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 + 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.

 

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
Was this post helpful?
NoYes (No Ratings Yet)
Loading...