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