表格操作专题

　　按条件控制表格列是否可编辑

var p = Forguncy.Page
    var listview = p.getListView("表格1");
var activeSheet = listview.getControl().getActiveSheet();
activeSheet.bind(GC.Spread.Sheets.Events.EditStarting, function (sender, args) {

    if (listview.getRowCount() <= args.row) { //新增行
        return;
    }
    var v = listview.getValue(args.row, 1);//类型值

    if (args.col == 2 && v != "客户") { // 客户列
        args.cancel = true;
        return;
    }
    if (args.col == 3 && v != "供应商") { // 供应商列
        args.cancel = true;
        return;
    }

});

　　按条件控制表格是否可编辑

var p = Forguncy.Page
    var listview = p.getListView("表格1");
var activeSheet = listview.getControl().getActiveSheet();
activeSheet.bind(GC.Spread.Sheets.Events.CellClick, function (sender, args) {

    var flag = page.getCell("flag").getValue();
		if(flag==1){
                 activeSheet.options.isProtected = true;
                 }
    else{
                 activeSheet.options.isProtected = false;
                 }


});

　　动态控制表格列隐藏显示

var page = Forguncy.Page;
var cell = page.getCell("billtitle");
var cellValue = cell.getValue();
var mytitle =cellValue.slice(-2);
var listview = Forguncy.Page.getListView("表格1");
if(mytitle!="退货"){
listview.hideColumns(["退换类型"]);//隐藏列
}

if(mytitle=="退货"){
listview.showColumns(["退换类型"]);//显示列
}