SpreadJS Tab键跳转可编辑单元格

本实例展示如何让SpreadJS按下Tab键后在可编辑（unlocked）单元格之间切换.

SpreadJS 默认按下Tab键后移动至下一个单元格，当设置了表单保护只运行用户编辑部分单元格时，用户会希望可以快速在可编辑单元格中切换，这样可以实现快速填报，提高工作效率。

实现Tab键自定义切换我们需要重新设置按下tab键后的Aciton。下面为重值keymap代码，有关keymap可以参考Using Input Mapping.

activeSheet.addKeyMap(GcSpread.Sheets.Key.tab, false, false, false, false, function() {
    var sheet = this;
    var startRow, startCol, row, col, searchStartRow, searchStartCol;
    var isLocked;
    startRow = sheet.getActiveRowIndex();
    startCol = sheet.getActiveColumnIndex();
    var rowCount = sheet.getRowCount();
    var colCount = sheet.getColumnCount();
    searchStartRow = startRow;
    for (row = startRow; row < rowCount; row++) {
        searchStartCol = row === startRow ? startCol + 1 : 0;
        if (searchStartCol == colCount) {
            row++;
            searchStartCol = 0;
        }
        for (col = searchStartCol; col < colCount; col++) {
            isLocked = sheet.getCell(row, col).locked();
            if (!isLocked) {
                if (!sheet.endEdit()) {
                    return
                }
                sheet.setActiveCell(row, col);
                return;
            }
        }
    }
    for (row = 0; row < rowCount; row++) {
        for (col = 0; col < colCount; col++) {
            if (row === startRow && col === startCol) {
                return
            }
            isLocked = sheet.getCell(row, col).locked();
            if (!isLocked) {
                if (!sheet.endEdit()) {
                    return
                }
                sheet.setActiveCell(row, col);
                return;
            }
        }
    }
});