Using Rapid Input Mode

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(); spread.commandManager().register("startEditing", { canUndo: false, execute: function (context, options) { var sheet = context.getSheetFromName(options.sheetName); if (sheet && !sheet.isEditing()) { sheet.startEdit(); } } }, 113, false, false, false, false); setstatus(activeSheet); activeSheet.bind(GC.Spread.Sheets.Events.EditorStatusChanged,function(e,args){ setstatus(activeSheet, args.status); }); } function setstatus(activeSheet,status) { var statusnow = status \|\| 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> // Create a label for the status <label id="status" style="margin: 10px">

JavaScript

Copy Code

spread.commandManager().register("startEditing", {
            canUndo: false,
            execute: function (context, options) {
                var sheet = context.getSheetFromName(options.sheetName);
                if (sheet && !sheet.isEditing()) {
                    sheet.startEdit();
                }
            }
        }, 113, false, false, false, false);

        setstatus(activeSheet);
        activeSheet.bind(GC.Spread.Sheets.Events.EditorStatusChanged,function(e,args){
            setstatus(activeSheet, args.status);
        });
    }

// Create a label for the status
<label id="status" style="margin: 10px">