ConstructionCost/web/bills/scripts/setSheets.js

/**
 * Created by vian on 2017/3/16.
 */
//初始表单
function initSheet(spread, sheet, chRowCount, vpRowCount, vpColCount){
    var spreadNS = GC.Spread.Sheets;
    spread.options.showHorizontalScrollbar = false;
    spread.options.showVerticalScrollbar =false;
    spread.options.tabStripVisible = false;
    spread.options.scrollbarMaxAlign = true;
    sheet.showRowOutline(false);
    sheet.defaults.rowHeight = 30;
    sheet.setRowCount(chRowCount, spreadNS.SheetArea.colHeader);
    sheet.setRowCount(vpRowCount, spreadNS.SheetArea.viewport);
    sheet.setColumnCount(vpColCount, spreadNS.SheetArea.viewport);

}
//设置初始行高
function initRowHeight(sheet){
    /*var rowCount = sheet.getRowCount();
    for(var i=0; i<rowCount; i++){
        sheet.setRowHeight(i, 30);
    }*/
}

//单元格设置
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);
    });
    //EditChange
   /* sheet.bind(events.EditChange, function(e, args){
        console.log("EditChange!");
    });*/
    //EditEnded
   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);
    });
    //EditEnding
    /*sheet.bind(events.EditEnding, function(e, args){
        console.log("EEing");
    });*/
}
//滚动条
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);
    //down,最后一行down添加新行
    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);
}