You can navigate using arrow keys when the sheet is in edit mode.
If the editor is in edit mode, the status is Enter or Edit. If the editor is not in edit mode, the status is Ready.
In Enter status, Spread commits the current input and navigates or selects other cells if the user uses navigate or select actions. In Edit status, Spread does not commit the current input and navigates or selects other cells if the user uses navigate or select actions.
Typing and double-clicking on an empty cell will cause the cell to go into the Enter status. Double-clicking on a non-empty cell causes the cell to go into the Edit status. If the cell is in Enter status and you click in the editor using the left mouse button, the status changes to Edit. Using the startEdit method is similar to double-clicking.
You can use the editorStatus type to check the edit mode.
Using Code
The following example displays the editor status.
JavaScript |
Copy Code |
|
<script type="text/javascript"> window.onload = function () { var spread = new GC.Spread.Sheets.Workbook(document.getElementById("ss")); var activeSheet = spread.getActiveSheet(); |
activeSheet.editorStatus(); if (statusnow === GC.Spread.Sheets.EditorStatus.ready) { $("#status").text("Ready"); } else if (statusnow === GC.Spread.Sheets.EditorStatus.enter) { $("#status").text("Enter"); } else if (statusnow === GC.Spread.Sheets.EditorStatus.edit) { $("#status").text("Edit"); } }</script><label id="status" style="margin: 10px"> |
|
---|
See Also
EnterCell Event