meidu2021/daju/WebRoot/webpage/cn/com/lzt/budget/tempsheet/budgetTempSheet-measure.js

//var columnCount = sheet.getColumnCount();
//var rowCount = sheet.getRowCount();
//sheet.deleteRows(1,1); 删除行
//var menuData = spread.contextMenu.menuData;
//workArea ：工作区域，“复制”操作的可用区域为viewport + colHeader + rowHeader + slicer + corner。

$(function(){
    spread = new GC.Spread.Sheets.Workbook(document.getElementById("ss"), { sheetCount: 1 });
    initSpread();
});

function initSpread(){
    spread.suspendPaint();

    if(dbJson){//数据库
        // spread.fromJSON(JSON.parse(dbJson));
        spread.fromJSON(dbJson);
    }
    spread.options.newTabVisible = false;//取消新增sheet按钮
    spread.options.allowExtendPasteRange =true;//扩展粘贴区域
    bindEvent(spread);
    var sheet = spread.getActiveSheet();
    var setting = sheet.tag();

    addContextMenu(spread);
    addDataCellMenu(spread)
    setMenuView(spread);
    // sheet.frozenRowCount(headRowCount);//冻结头部
    // sheet.options.frozenlineColor = 'red';//冻结线颜色
    setDefaultLock(sheet);
    // sheet.selectionPolicy(GC.Spread.Sheets.SelectionPolicy.single);//不让多选
    spread.resumePaint();
}
function bindEvent(spread){
    bindCheckNum(spread);
    spread.bind(GC.Spread.Sheets.Events.EnterCell, function (event, data) {//点击cell事件
        var row = data.row;
        var col = data.col;
        var sheet = data.sheet;
        var cellTag = sheet.getTag(row,col);
        disableBindButton(true);
        if(readOnly=='false') {
            $('#rowInfo').show();
            $('#colInfo').show();
            $('#info3').show();
            $('#info2').hide();
            if(cellTag) {
                var bindDirection=cellTag.bindDirection;
                if(bindDirection){//表头
                    if(bindDirection=='row'){
                        $('#rowTimeInput').val(cellTag.periodDetailName);
                        if(cellTag.measureName) {
                            $('#rowGoalsInput').val(cellTag.customCode + " " + cellTag.measureName);
                        }
                        $('input[name="includeTaxRow"][value=' + cellTag.includeTax + ']').attr('checked', 'checked');
                        $('input[name="expectRow"][value=' + cellTag.expect + ']').attr('checked', 'checked');
                    }else if(bindDirection=='col'){
                        $('#colTimeInput').val(cellTag.periodDetailName);
                        if(cellTag.measureName){
                            $('#colGoalsInput').val(cellTag.customCode+" "+cellTag.measureName);
                        }
                        $('input[name="includeTaxCol"][value=' + cellTag.includeTax + ']').attr('checked', 'checked');
                        $('input[name="expectCol"][value=' + cellTag.expect + ']').attr('checked', 'checked');
                    }
                }else {//非表头
                    showCellBindInfo(sheet,row,col);
                }
            }
        }else if(readOnly=='true'){
            showCellBindInfo(sheet,row,col);
        }
        //单元格属性
        if(cellTag){
            var datatype =cellTag.datatype;
            var datatypeValue= measureDataTypeList[datatype];
            if(!datatypeValue) datatypeValue='';
            $('#goalsDataType').html(datatypeValue);
            if(cellTag.readOnly==1){
                $('#readOnly').html('是');
            }else {
                $('#readOnly').html('否');
            }
            var showFuntionTxt = $('#showFuntionTxt');
            if(cellTag.functionId){
                showFuntionTxt.show();
                showFuntionTxt.find('span').html(cellTag.functionTxt);
            }else{
                showFuntionTxt.hide();
            }
            var controlFlagNameDiv = $('#controlFlagName');
            if(cellTag.controlFlagName){
                controlFlagNameDiv.show();
                controlFlagNameDiv.find('span').html(cellTag.controlFlagName);
            }else {
                controlFlagNameDiv.hide();
            }
        }else {
            $('#readOnly').html('');
            $('#showFuntionTxt').hide();
        }

        // sheet.startEdit(false); //单击修改
    });
  /*  spread.bind(GC.Spread.Sheets.Events.ButtonClicked, function (e, args) {//点击按钮事件
        var sheet = args.sheet, row = args.row, col = args.col;
        var cellType = sheet.getCellType(row, col);
    });*/

    spread.bind(GC.Spread.Sheets.Events.CellChanged, function (e, info) {
        // console.log(info)
        if(info.sheetArea === GC.Spread.Sheets.SheetArea.viewport){
            var sheet =info.sheet;
            var row = info.row;
            var col = info.col;
            if(info.propertyName=='value'){//值变化
            }
            if(info.propertyName=='formula'){//公式
                if(info.newValue==null){
                    sheet.getCell(row,col).backColor('white');
                }else{
                    sheet.getCell(row,col).backColor('yellow');
                }
            }

        }
    });
    // alert("Cell index (" + info.row + "," + info.col + ")");

}
function setDefaultLock(sheet){
    var option = {
        allowSelectLockedCells:true,
        allowSelectUnlockedCells:true,
        allowFilter: true,
        allowSort: false,
        allowResizeRows: true,
        allowResizeColumns: true,
        allowEditObjects: false,
        allowDragInsertRows: false,
        allowDragInsertColumns: false,
        allowInsertRows: true,
        allowInsertColumns: true,
        allowDeleteRows: true,
        allowDeleteColumns: true
    };
    sheet.options.protectionOptions = option;
    sheet.options.isProtected = true;
    var defaultStyle = sheet.getDefaultStyle() //默认的样式，
    defaultStyle.locked=false;
    sheet.setDefaultStyle(defaultStyle);
}

function addContextMenu(){
    for(var i=0;i< spread.contextMenu.menuData.length;i++){
        var menu = spread.contextMenu.menuData[i];
        var menuName=menu.name;
        if(menuName=='gc.spread.filter' || menuName=='gc.spread.sort' ){//去掉过滤、排序
            delete spread.contextMenu.menuData[i];
        }
    }
    // command: showLoginDialog,

}

//固定后 右键菜单
function addDataCellMenu(spread){
    var sheet=spread.getActiveSheet();
    /*var controlFlag ={text: '预算控制方案',name: 'controlFlag',workArea: 'viewport',dataCellMenu:1};
    controlFlag.subMenu=[];
    if(budgetControlArray.length>0) {
        spread.contextMenu.menuData.push(controlFlag);
        for(var i=0;i<budgetControlArray.length;i++){
            let one = budgetControlArray[i];
            controlFlag.subMenu.push({text: one.name,name: 'controlFlag_'+one.id,workArea: 'viewport',command:function(){
                    setSelectionTagValue(sheet,'cell',{controlFlag:one.id,controlFlagName:one.name});
                }});
        }
    }*/

    var readOnly ={text: '只读',name: 'readOnly',workArea: 'viewport',dataCellMenu:1};
    readOnly.subMenu= [{text: '是',name: 'readOnly_yes',workArea: 'viewport',command:setReadonly}
                        ,{text: '否',name: 'readOnly_no',workArea: 'viewport',command:setReadonly}]
    spread.contextMenu.menuData.push(readOnly);

    var clearNotSelectMenu ={text: '清空其他区域',name: 'clearNotSelect',workArea: 'viewport',command:clearNotSelect};
    spread.contextMenu.menuData.push(clearNotSelectMenu);
    addDimFunctionMenu(spread);
    addDimFunctionCostbreakdownMenu(spread);

    var dimMatchMenu ={text: '维度匹配',name: 'dimLike',workArea: 'viewport',command:dimMatch};
    dimMatchMenu.subMenu= [{text: '匹配行维度',name: 'dimLikeRow',workArea: 'viewport',command:dimMatchRow}
        ,{text: '匹配列维度',name: 'dimLikeCol',workArea: 'viewport',command:dimMatchCol}]
    spread.contextMenu.menuData.push(dimMatchMenu);

}


function setMenuView(spread){
    function CustomMenuView() {
    }

    CustomMenuView.prototype = new GC.Spread.Sheets.ContextMenu.MenuView();
    CustomMenuView.prototype.createMenuItemElement = function (menuItemData) {
        var self = this;
        if (menuItemData.name === "bind") {
            /* var containers = GC.Spread.Sheets.ContextMenu.MenuView.prototype.createMenuItemElement.call(self, menuItemData);
             var supMenuItemContainer = containers[0];
             while (supMenuItemContainer.firstChild) {
                 supMenuItemContainer.removeChild(supMenuItemContainer.firstChild);
             }
             var colorPicker = createColorpicker();
             supMenuItemContainer.appendChild(colorPicker);

             return supMenuItemContainer;*/
        } else {
            var menuItemView = GC.Spread.Sheets.ContextMenu.MenuView.prototype.createMenuItemElement.call(self, menuItemData);
            return menuItemView;
        }
    };
    CustomMenuView.prototype.getCommandOptions = function (menuItemData, host, event) {
        var option={};
        if (menuItemData) {
            var name =menuItemData.name;
            if(name && name.indexOf('timeRowMenu')==0) {
                var text = menuItemData.text;
                for(var i=0;i<periodDetailList.length;i++){
                    var detail = periodDetailList[i];
                    if(detail.name==text){
                        option.id=detail.id;
                        option.name=detail.name;
                        break;
                    }
                }
            }
            if(name && name=='controlFlag1') {
                option.controlFlag=1;
            }
            if(name && name=='readOnly_yes') {
                option.readOnly=1;
            }else if(name && name=='readOnly_no'){
                option.readOnly=0;
            }
            /*if(name && name.indexOf('goalsDataType')==0){
                var code = name.substr('goalsDataType_'.length);
                for(var i=0;i<goalsDataTypeList.length;i++){
                    var dataType = goalsDataTypeList[i];
                    if(dataType.code==code){
                        option.goalsDataType=code;
                        option.goalsDataTypeName=dataType.name;
                        break;
                    }
                }
            }*/
        }
        // console.log(option);
        return option;
    };
    spread.contextMenu.menuView = new CustomMenuView();
}

//添加常用style
function addNameStyle(sheet){
    var lockStyle = new GC.Spread.Sheets.Style();
    lockStyle.name='lock';
    lockStyle.locked = true;
    sheet.addNamedStyle(lockStyle);
    var unLockStyle = new GC.Spread.Sheets.Style();
    unLockStyle.name='unLock';
    unLockStyle.locked = false;
    sheet.addNamedStyle(unLockStyle);
}

function save(afterSaveFunction){

    var sheet = spread.getActiveSheet();
    var tag = sheet.tag();
    var hasFix = false;
    if(tag) {
        if(tag.fix==true){
            hasFix=true;
        }
    }
    if(!hasFix){
        _alert('请先生成数据单元格');
        return;
    }
    _commonSave({type:'normal'},afterSaveFunction);
}

function SheetSetting() {
    this.bindTime=false;
    this.bindIncludeTax=false;
    this.bindGoals=false;
}
SheetSetting.prototype.toJSON = function () {
    var settings ={};
    var keys =Object.keys(this);
    for(var i=0;i<keys.length;i++){
        var key =keys[i];
        settings[key]=this[key];
    }
    return settings;
};
SheetSetting.prototype.fromJSON = function (settings) {
};

function CellSetting() {
}

CellSetting.prototype.toJSON = function () {
    var settings ={};
    var keys =Object.keys(this);
    for(var i=0;i<keys.length;i++){
        var key =keys[i];
        settings[key]=this[key];
    }
    return settings;
};
CellSetting.prototype.fromJSON = function (settings) {
    console.log('fromjson');
};


function RowSetting(measureId,measureName) {
    this.measureId = measureId;
    this.measureName= measureName;
}
RowSetting.prototype.toJSON = function () {
    var settings ={};
    var keys =Object.keys(this);
    for(var i=0;i<keys.length;i++){
        var key =keys[i];
        settings[key]=this[key];
    }
    return settings;
};
RowSetting.prototype.fromJSON = function (settings) {
};

function ColSetting() {}
ColSetting.prototype.toJSON = function () {
    var settings ={};
    var keys =Object.keys(this);
    for(var i=0;i<keys.length;i++){
        var key =keys[i];
        settings[key]=this[key];
    }
    return settings;
};
ColSetting.prototype.fromJSON = function (settings) {
    console.log('fromjson');
};

function _openDialog(url,title,okCallback,width,height){
    if(!width){
        width='500px';
    }
    if(!height){
        height='350px';
    }
    if(width=="100%"){
        width = window.top.document.body.offsetWidth;
    }
    if(height=="100%") {
        height =window.top.document.body.offsetHeight-100;
    }
    var _selectDialog= $.dialog({content:'url:'+url
        , zIndex:  getzIndex()
        , title:title , lock: true, width:width, height: height, opacity: 0.4, button: [
            {name: '确定', callback:function () {
                    var iframe = _selectDialog.iframe.contentWindow;
                    if(okCallback){
                        var b = okCallback(iframe);
                        return b;
                    }
                }
                , focus: true},
            {name: '取消', callback: function (){}}
        ]}).zindex();
    return _selectDialog;
}

function setIncludeTaxRow() {
    setIncludeTax('row');
}


function setIncludeTaxCol() {
    setIncludeTax('col');
}

function setIncludeTax(type){
    var sheet = spread.getActiveSheet();
    var itemName='';
    disableBindButton();

    if(type=='row'){
        itemName="includeTaxRow"
    }else {
        itemName="includeTaxCol"
    }
    $('input[name="'+itemName+'"]').removeAttr('disabled');
    var include = $('input[name="'+itemName+'"]:checked').val();

    beforeBindDim(sheet,type);
    setSelectionTagValue(sheet,'cell',{includeTax:include});
    setSelectionTagValue(sheet,'cell',{bindDirection:type});
    setHeader(sheet,type);
}

function setTimeRow(){
    setTime('row');
}
function setTimeCol(){
    setTime('col');
}
function setTime(type){
    var sheet = spread.getActiveSheet();
    var url ='budgetPeriodDetailController.do?select&periodYear='+periodYear;
    _select(url, '选择时间维度', function (selectedRows) {
        var one = selectedRows[0];
        var id = one.id;
        var name = one.name;
        var obj = {periodDetailId:id,periodDetailName:name};
        setTimeValue(sheet,type,obj);
    }, '800px', '600px');
}
function setTimeValue(sheet,type,valueObj){
    var name = valueObj.periodDetailName;
    disableBindButton();
    if(type=='row'){
        $('#rowTimeInput').val(name);
        $('#rowTimeBind').show();
    }else {
        $('#colTimeInput').val(name);
        $('#colTimeBind').show();
    }
    beforeBindDim(sheet,type);
    setSelectionTagValue(sheet,'cell',valueObj);
    setSelectionTagValue(sheet,'cell',{bindDirection:type});
    setHeader(sheet,type);
}
function setMeasureRow() {
    setMeasure('row');
}

function setMeasureCol() {
    setMeasure('col');
}

function setMeasure(type){
    var sheet = spread.getActiveSheet();
    var url = 'budgetMeasureController.do?select';
    _openDialog(url,'选择预算指标',function(iframe){
        var selectedRows = iframe.getSelectedRow();
        if(selectedRows.length==0){
            iframe.tip('请选择预算指标');
            return false;
        }
        var one = selectedRows[0];
        var code = one.code;
        var id = one.id;
        var name = one.name;
        var o={measureId:id,measureName:name};
        o.datatype=one.datatype;
        o.fractionNum=one.fractionNum;
        o.currencySymbol=one.currencySymbol;
        o.showType=one.showType;
        o.thousandth=one.thousandth;
        o.controlFlag=one.controlFlag;
        o.customCode=one.customCode;
        setMeasureValue(sheet,type,o);
    },'800px','600px');
}

function setMeasureValue(sheet,type,valueObj){
    var name = valueObj.customCode+" "+valueObj.measureName;
    disableBindButton();
    if(type=='row'){
        $('#rowGoalsInput').val(name);
        $('#rowGoalsBind').show();
    }else {
        $('#colGoalsInput').val(name);
        $('#colGoalsBind').show();
    }
    beforeBindDim(sheet,type);
    setSelectionTagValue(sheet,'cell',valueObj);
    setSelectionTagValue(sheet,'cell',{bindDirection:type});
    setHeader(sheet,type);
}

//生成数据单元格
function fix() {
    var sheet = spread.getActiveSheet();
    var tag = sheet.tag();
    var headerArr=tag.headerArr;
    for(var i in headerArr){
        var arr=i.split('#');
        var row = arr[0];
        var col = arr[1];
        var cellTag = sheet.getTag(row,col);
        var rcObj = $.extend({},cellTag);
        delete rcObj['bindDirection'];
        delete rcObj['rowHeader'];
        delete rcObj['colHeader'];
        if(cellTag.bindDirection=='row'){
            sheet.setTag(row,-1,rcObj);
        }
        if(cellTag.bindDirection=='col'){
            sheet.setTag(-1,col,rcObj);
        }
    }
   /*
    sheet.getRange(0,-1,dataStartRow,-1).locked(true);
    sheet.getRange(-1,0,-1,dataStartCol).locked(true);
    spread.contextMenu.menuData.forEach(function (item, index) {
        if (item && (item.name == "bindCol" || item.name == "bindRow")) {
           delete spread.contextMenu.menuData.splice(index);
        }
    });
    */
    // addDataCellMenu(spread);
    var selections = sheet.getSelections();
    var changeCell =0;
    for(var i=0;i<selections.length;i++){
        var select = selections[i];
        var row = select.row;
        var col = select.col;
        var rowCount = select.rowCount;
        var colCount = select.colCount;
        for(var r=row;r<row+rowCount;r++){
            for(var c=col;c<col+colCount;c++){
                var rs = sheet.getTag(r,-1);
                var cs = sheet.getTag(-1,c);

                var cellSetting = sheet.getTag(r, c);
                if (!cellSetting) {
                    cellSetting = new CellSetting();
                }
                if(rs) $.extend(cellSetting,rs);
                if(cs) $.extend(cellSetting,cs);
                $.extend(cellSetting,{'dataCell':true});
                var cellString = getCellStr(sheet,r,c);
                cellString=cellString.replace(/\$/g,'');
                if(!cellSetting.measureId) {
                    _alert("单元格:"+cellString+"未绑定指标维度")
                    return;
                }
                if(!cellSetting.periodDetailId) {
                    _alert("单元格:"+cellString+"未绑定时间维度")
                    return;
                }
                if(typeof cellSetting.includeTax =='undefined') {
                    _alert("单元格:"+cellString+"未绑定含税维度")
                    return;
                }
                if(typeof cellSetting.expect =='undefined') {
                    _alert("单元格:"+cellString+"未绑定预实维度")
                    return;
                }
                sheet.setTag(r,c, cellSetting);
                changeCell++;
                if(cellSetting.datatype=='amount'){
                    var currencySymbol = cellSetting.currencySymbol;//货币符号
                    var thousandth = cellSetting.thousandth;//千分位
                    var fractionNum = cellSetting.fractionNum;//小数位
                    var format='';
                    if(currencySymbol) format+=currencySymbol+'* ';
                    if(thousandth) format+='#,###';
                    if(!fractionNum&&fractionNum!=0)  {
                        fractionNum='2';
                    }
                    if(fractionNum!=0){
                        format+='.';
                        for(var n=0;n<fractionNum;n++) {
                            format+='0';
                        }
                    }
                    sheet.setFormatter(r, c, format);
                }
            }
        }
    }
    if(changeCell>0){
        setSheetTag(sheet,{fix:true})
        $.messager.alert('信息','操作成功');
    }else{
        $.messager.alert('信息','请选择单元格');
    }

}
function setControlFlag(spread,options){
    var sheet = spread.getActiveSheet();
    setSelectionTagValue(sheet,'cell',options);
}

function setSheetTag(sheet,value) {
    var setting = sheet.tag();
    if(!setting){
        setting = new SheetSetting();
    }
    $.extend(setting,value);
    sheet.tag(setting);
}

function setDataStartIndex(sheet,type,row,col){
}

function setReadonly(spread,options){
    var sheet = spread.getActiveSheet();
    var selections = sheet.getSelections();
    var select = selections[0];
    var row = select.row;
    var col = select.col;
    if(options.readOnly==1){
        sheet.getCell(row,col).backColor('grey');
    }else {
        sheet.getCell(row,col).backColor('white');
    }
    setSelectionTagValue(sheet,'cell',options);
}

function setHeader(sheet,type){
    var o = {};
    //inst 会用到 显示行表头 或 列表头
    if(type=='row'){
        o[_vars.rowHeader]='true';
    }else if(type=='col'){
        o[_vars.colHeader]='true';
    }
    setSelectionTagValue(sheet,'cell',o);
}

function disableBindButton(clearValue){
    if(clearValue){
        $('#rowTimeInput').val('');
        $('#colTimeInput').val('');
        $('#rowGoalsInput').val('');
        $('#colGoalsInput').val('');
        $('input[name="includeTaxRow"]').removeAttr('checked');
        $('input[name="includeTaxCol"]').removeAttr('checked');
        $('input[name="expectRow"]').removeAttr('checked');
        $('input[name="expectCol"]').removeAttr('checked');
    }
    /*
        $('#rowTimeBind').hide();
        $('#rowGoalsBind').hide();
        $('input[name="includeTaxRow"]').attr('disabled','disabled');
        $('input[name="expectRow"]').attr('disabled','disabled');
        $('#colTimeBind').hide();
        $('#colGoalsBind').hide();
        $('input[name="includeTaxCol"]').attr('disabled','disabled');
        $('input[name="expectCol"]').attr('disabled','disabled');
        */
}

function clearBind(sheet,type,row,col){
    if(type=='row'){
        clearRowBindInput();
    }else {
        clearColBindInput();
    }
    sheet.setTag(row,col,{});
}
function clearRowBindInput(){
    $('#rowTimeInput').val('');
    $('#rowGoalsInput').val('');
    $('input[name="includeTaxRow"]').removeAttr('checked');
    $('input[name="expectRow"]').removeAttr('checked');
}

function clearColBindInput(){
    $('#colTimeInput').val('');
    $('#colGoalsInput').val('');
    $('input[name="includeTaxCol"]').removeAttr('checked');
    $('input[name="expectCol"]').removeAttr('checked');
}

function setExpectRow(){
    setExpect('row');
}
function setExpectCol(){
    setExpect('col');
}
function setExpect(type){
    var sheet = spread.getActiveSheet();
    var itemName='';
    disableBindButton();

    if(type=='row'){
        itemName="expectRow"
    }else {
        itemName="expectCol"
    }
    $('input[name="'+itemName+'"]').removeAttr('disabled');
    var expect = $('input[name="'+itemName+'"]:checked').val();
    beforeBindDim(sheet,type);
    setSelectionTagValue(sheet,'cell',{expect:expect});
    setSelectionTagValue(sheet,'cell',{bindDirection:type});
    setHeader(sheet,type);
}
function dimMatchRow(spread,options){
    dimMatch(spread,options,'row')
}
function dimMatchCol(spread,options){
    dimMatch(spread,options,'col')
}

function dimMatch(spread,options,type) {
    var sheet = spread.getActiveSheet();
    var selections = sheet.getSelections();
    var select = selections[0];
    var row = select.row;
    var col = select.col;
    var rowCount = select.rowCount;
    var colCount = select.colCount;
    var params= {};
    var totalCol = col + colCount;
    var c = 0;
    for(var i=row;i<row+rowCount;i++) {
        for (var j = col; j < totalCol; j++) {
            var cellValue = sheet.getValue(i,j);
            if(cellValue){
                params['list['+c+'].row']=i;
                params['list['+c+'].col']=j;
                params['list['+c+'].cellValue']=cellValue;
                c++;
            }
        }
    }
    params.periodId=periodId;
    $.post('budgetTempSheetController.do?dimMatch',params,function(d){
            if(d.success){
                sheet.clearSelection();
                var list = d.obj.list;
                for(var i=0;i<list.length;i++){
                    var one = list[i];
                    var row =one.row;
                    var col = one.col;
                    var bindDirection =type?type:one.bindDirection;
                    if(one.bindDim=='measure'){
                        sheet.setSelection(row,col, 1, 1);
                        setMeasureValue(sheet,bindDirection,one.bindValue);
                    }
                    if(one.bindDim=='period'){
                        sheet.setSelection(row,col, 1, 1);
                        setTimeValue(sheet,bindDirection,one.bindValue);
                    }
                }
                sheet.clearSelection();
                tip('匹配成功');
            }else {
                tip('匹配失败');
            }
    },'json')

}

function beforeBindDim(sheet,type){
    checkChangeDircetion(sheet,type);
    addHeaderCell(sheet);
}

//检查是否换方向绑定
function checkChangeDircetion(sheet,type){
    var selections = sheet.getSelections();
    var select = selections[0];
    var row = select.row;
    var col = select.col;
    var cellTag=sheet.getTag(row,col);
    if(!cellTag) return;
    var oldBindDirection = cellTag.bindDirection;
    if(oldBindDirection && oldBindDirection!=type){
        clearBind(sheet,oldBindDirection,row,col);
    }

}

function bindCheckNum(spread) {
    spread.bind(GC.Spread.Sheets.Events.EditEnding, function (sender, args) {
        var sheet = args.sheet;
        var row=args.row;
        var col=args.col;
        var cellTag = sheet.getTag(row,col);
        if(cellTag) {
            if(cellTag.dataCell==true && cellTag.datatype && cellTag.datatype!='txt'){
                var value =args.editingText;
                var reg=/^(-?\d+)(\.\d+)?$/;
                if(value){
                    if(value.indexOf('=')!=0){
                        if(!reg.test(value)){
                            args.cancel = true;
                        }
                    }
                }
            }
        }
    });
}

function addHeaderCell(sheet){
    var selections = sheet.getSelections();
    var select = selections[0];
    var row = select.row;
    var col = select.col;

   var tag = sheet.tag();
   if(!tag) tag={};
   var headerArr=tag.headerArr;
   if(!headerArr){
       headerArr={};
       tag.headerArr=headerArr;
       addSheetTagValue(sheet,tag);
   }
   var key = row+"#"+col;
    headerArr[key]='1';
}

function removeHeaderCell(sheet,row,col){
    var tag = sheet.tag();
    var headerArr=tag.headerArr;
    var key = row+"#"+col;
    delete headerArr[key];
}

//清空行维度
function removeRowBind(){
    var sheet=spread.getActiveSheet();
    var selections = sheet.getSelections();
    var select = selections[0];
    var row = select.row;
    var col = select.col;
    var cellTag = sheet.getTag(row,col);
    if(cellTag){
        var bindDirection = cellTag.bindDirection;
        if(bindDirection){
            if(bindDirection=='row'){
                clearRowBindInput();
                sheet.setTag(row,col,{});
                removeHeaderCell(sheet,row,col);
            }
        }
    }
}
//清空列维度
function removeColBind(){
    var sheet=spread.getActiveSheet();
    var selections = sheet.getSelections();
    var select = selections[0];
    var row = select.row;
    var col = select.col;
    var cellTag = sheet.getTag(row,col);
    if(cellTag){
        var bindDirection = cellTag.bindDirection;
        if(bindDirection){
            if(bindDirection=='col'){
                clearColBindInput();
                sheet.setTag(row,col,{});
                removeHeaderCell(sheet,row,col);
            }
        }
    }
}

function showCellBindInfo(sheet,row,col){
    $('#rowInfo').hide();$('#colInfo').hide();
    $('#info3').show();$('#info2').show();
    var cellTag = sheet.getTag(row,col);
    var periodDetailName=cellTag.periodDetailName;
    var measureName=cellTag.customCode+" "+cellTag.measureName;
    var includeTax=cellTag.includeTax;
    var expect = cellTag.expect;

    $('#timeInput').val(periodDetailName);
    $('#goalsInput').val(measureName);
    $('input[name="includeTax"]').removeAttr('checked');
    $('input[name="includeTax"][value=' + includeTax + ']').attr('checked', 'checked');
    $('input[name="expect"]').removeAttr('checked');
    $('input[name="expect"][value=' + expect + ']').attr('checked', 'checked');
}