Page tree
Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Next »

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><label id="status" style="margin: 10px">

 

See Also
EnterCell Event

  • No labels