ConstructionCost/web/billsLib/scripts/setSheets.js

/**
 * Created by vian on 2017/3/16.
 */

function initSheet(spread){
    var spreadNS = GC.Spread.Sheets, sheet = spread.getActiveSheet();
    spread.options.showHorizontalScrollbar = false;
    spread.options.showVerticalScrollbar =false;
    spread.options.tabStripVisible = false;
    spread.options.scrollbarMaxAlign = true;
    sheet.showRowOutline(false);
    sheet.defaults.rowHeight = 30;
}

function initHeader(spread, setting){
    var sheet = spread.getActiveSheet();
    sheet.setColumnCount(setting.cols.length);
    sheet.setRowCount();
}

function setCell(sheet){
    var colCount = sheet.getColumnCount();
    var vp = GC.Spread.Sheets.SheetArea.viewport;
    var center = GC.Spread.Sheets.VerticalAlign.center;
    var left =  GC.Spread.Sheets.HorizontalAlign.left;
    for(var i= 0; i<colCount; i++){
        sheet.getRange(-1, i, -1, 1, vp).vAlign(center);
        sheet.getRange(-1, i, -1, 1, vp).hAlign(left);
        sheet.getRange(-1, i, -1, 1, vp).font("12pt ����");
    }
}

function setupEvents(spread, sheet){
    var events = GC.Spread.Sheets.Events;
    $("#aDelete").click(function(){
        var rowIdx = sheet.getActiveRowIndex();
        sheet.deleteRows(rowIdx, 1);
    });

   sheet.bind(events.EditEnded, function(e, args){
       var editRow = args.row;
       var editCol = args.col;
       var eiditVal = sheet.getValue(editRow, editCol);
        console.log("EE: row: "+editRow+"  col: "+editCol +"val: "+eiditVal);
    });

}

function setScrollBar(spread, sheet, initRow){
    var events = GC.Spread.Sheets.Events;
    sheet.bind(events.EnterCell, function(e, data){
        var rowCount = sheet.getRowCount();
        //��ǰ�������ڳ�ʼ����
        if(rowCount >initRow){
            spread.options.showVerticalScrollbar = true;
        }
        else{
            spread.options.showVerticalScrollbar = false;
        }
    });
}


function myCommand(spread, sheet){
    var keys = GC.Spread.Commands.Key;
    //enter,���һ�лس����������
    spread.commandManager().register("myEnter", function(){
        var idxRow = sheet.getActiveRowIndex();
        var rowCount = sheet.getRowCount();
        if(idxRow+1 == rowCount){
            sheet.addRows(rowCount, 1);
            sheet.setRowHeight(rowCount, 30);//�����и�
            sheet.getRange(rowCount, -1, 1, -1).vAlign(GC.Spread.Sheets.VerticalAlign.center);
            sheet.getRange(rowCount, -1, 1, -1).font("10pt ΢���ź�");
        }
    });
    spread.commandManager().setShortcutKey("myEnter", keys.enter, false, false, false, false);
    spread.commandManager().register("myDown", function(){
        var idxRow = sheet.getActiveRowIndex();
        var rowCount = sheet.getRowCount();
        if(idxRow+1 == rowCount){
            sheet.suspendPaint();
            sheet.addRows(rowCount, 1);
            sheet.setRowHeight(rowCount, 30);//�����и�
            sheet.getRange(rowCount, -1, 1, -1).vAlign(GC.Spread.Sheets.VerticalAlign.center);
            sheet.getRange(rowCount, -1, 1, -1).font("10pt ΢���ź�");
            sheet.resumePaint();
        }
    });
    spread.commandManager().setShortcutKey("myDown", keys.down, false, false, false, false);
}