var formulaObj = new formulaEncapsulation();	//主表特有，存储整个表单所有公式

/**
 * formula公式对象封装
 */
function formulaEncapsulation(){
    var formula = {};
    return {
        setOneFormula: function(key, value){
            formula[key] = value;
        },
        getOneFormula: function(key){
            return formula[key];
        },
        delOneFormula: function(key){
            delete formula[key];
        },
        getFormulas: function(){
            return formula;
        },
        clearFormulas: function(){
            formula = {};
        }
    }
}

/**
 * 公式方法封装、改造，支持插入/删除行列位移
 * 公式信息全部存储formulaObj中，结构改为key-srcformulatxt，且srcformulatxt串单元格必须带标示(main.)
 * 单元格dataobj[cellid].formula值只放"y"，标志单元格设置有公式
 */
var formulaOperate = (function(){
    var fxContainsLeft = true;
    //模板打开恢复公式,需处理历史公式数据
    function resumeFormulas(formulaJson){
        for(var __key in formulaJson){
            if (__key.indexOf("#new#") == -1) {
                var formulaStr = formulaJson[__key].srcformulatxt;
                var formulaStr_manage = manageHistorySrcFormula(__key, formulaStr);
                formulaObj.setOneFormula(__key, formulaStr_manage);
            } else {
                var formulaStr = formulaJson[__key].srcformulatxt;
                formulaObj.setOneFormula(__key, formulaStr);
            }
        }
    }

    //历史数据处理，针对改造前公式src串含未带标示D4单元格信息替换成symbol.D4,区域不处理
    //正则表达式-反向否定预查，(?<!\.)写的报错，why？。。。故使用占位符替换
    function manageHistorySrcFormula(__key, formulaStr){
        var reg = /((main|tab_\d+|detail_\d+)\.)?[a-zA-Z]+\d+:((main|tab_\d+|detail_\d+)\.)?[a-zA-Z]+\d+|((main|tab_\d+|detail_\d+)\.)?[a-zA-Z]+\d+/g;
        var add_symbol = __key.substring(0,__key.indexOf(".")).toLowerCase();
        var cellrang = formulaStr.match(reg);
        if(cellrang != null){
            var cellrang_new = new Array();
            for(var i = 0; i < cellrang.length; i++){
                formulaStr = formulaStr.replace(cellrang[i], "placeholder_"+i);
                if(cellrang[i].indexOf(".") > -1)
                    cellrang_new.push(cellrang[i]);
                else
                    cellrang_new.push(add_symbol+"."+cellrang[i]);
            }
            for(var i = 0; i < cellrang_new.length; i++){
                formulaStr = formulaStr.replace("placeholder_"+i, cellrang_new[i]);
            }
        }
        return formulaStr;
    }

    //模板保存拼接公式，生成formulatxt、cellrange、destcell等信息
    function saveFormulas() {
        var reg = /(MAIN|TAB_\d+|DETAIL_\d+)\.[A-Z]+\d+/g;
        var formulas = formulaObj.getFormulas();
        //先预览/导出模板，再点模板保存。多次公式保存会异常，新建公式对象避免此问题
        var formulaObj_new = new formulaEncapsulation();
        var newFormula = {};
        for(var __key in formulas){
            var formulaStr = formulas[__key].trim();
            if (__key.indexOf("#new#") > -1) {
                saveFormulasNew(newFormula, __key);
            } else {
                var _formulaJson = {};
                _formulaJson.srcformulatxt = formulaStr;
                _formulaJson.formulatxt = replaceFormula(formulaStr);
                _formulaJson.cellrange = _formulaJson.formulatxt.match(reg);
                _formulaJson.destcell = __key.replace("FORMULA", "");
                //入库json仍需要destfield，用于计算赋值字段为只读时入库保存
                _formulaJson.destfield = calculateDestfield(_formulaJson.destcell);
                formulaObj_new.setOneFormula(__key, _formulaJson);
            }
        }
        $("#datajsonFormula").val(JSON.stringify(newFormula));
        return JSON.stringify(formulaObj_new.getFormulas());
    }

    //根据公式赋值单元格计算赋值字段ID
    function calculateDestfield(destcell){
        var destfield = "";
        try{
            var symbol = destcell.split(".")[0].toLowerCase();
            var cellletter = destcell.split(".")[1];
            var row = parseInt(cellletter.match(/\d+$/)[0])-1;
            var col = cellletter.match(/^[a-zA-Z]+/)[0];
            col = parseInt(morecharToInt(col))-1;
            var cellid = row+","+col;
            if(symbol === "main" || symbol.indexOf("tab_") > -1){
                var dataobj = globalData.getCacheValue(symbol);
                if(dataobj && dataobj.ecs && dataobj.ecs[cellid] && dataobj.ecs[cellid].etype == celltype.FCONTENT)
                    destfield = dataobj.ecs[cellid].efieldid;
            }else if(symbol.indexOf("detail_") > -1){
                var detailjson = JSON.parse("{"+globalData.getCacheValue(symbol)+"}");
                detailjson = detailjson[symbol];
                if(detailjson && detailjson.ec)
                    for(var len = 0; len<detailjson.ec.length; len++){
                        var ecObj = detailjson.ec[len];
                        if(ecObj.id == cellid && ecObj.etype === transformerEtype(celltype.FCONTENT)){
                            destfield = ecObj.field;
                            break;
                        }
                    }
            }
        }catch(e){}
        return destfield;
    }

    //模板保存拼接公式，生成formulatxt、cellrange、destcell等信息
    function saveFormulasNew(formulaObj_new, __key){
        var formulas = formulaObj.getFormulas();
        //先预览/导出模板，再点模板保存。多次公式保存会异常，新建公式对象避免此问题

        var formulaStr = formulas[__key].trim();
        var _formulaJson = {};
        _formulaJson.srcformulatxt = formulaStr;
        formulaStr = replaceFormulaNew(formulaStr);
        if (formulaStr) {
            var formulaArr = formulaStr.split("###");
            if (formulaArr.length >= 3) {
                if (formulaArr[0]) {
                    _formulaJson.formulatxt = formulaArr[0];
                }
                if (formulaArr[2]) {
                    _formulaJson.triggers = formulaArr[2];
                }
            }
        }
        if (_formulaJson.formulatxt) {
            var tempFormula = _formulaJson.formulatxt;
            var singleFormula = tempFormula.split("#rn#");
            var formulatxt = new Array();
            var cellrange = new Array();
            var destcell = new Array();
            var destfield = new Array();
            for (var i = 0; i < singleFormula.length; i++) {
                var temp = singleFormula[i];
                //公式计算内容
                var ret = getRightValue(temp);
                formulatxt.push(ret.rightFormula);
                cellrange.push(ret.rightValue);
                //公式赋值字段
                var leftValue = getLeftValue(temp).leftValue;
                destcell.push(leftValue);
                destfield.push(leftValue);
            }
            _formulaJson.formulatxt = formulatxt;
            _formulaJson.cellrange = cellrange;
            _formulaJson.destcell = destcell;
            _formulaJson.destfield = destfield;
        } else {
            _formulaJson.cellrange = '';
        }
        formulaObj_new[__key] = _formulaJson;
    }

    /**
     * 返回公式等号右侧，即计算部分或非赋值部分
     */
    function getRightValue(temp) {

        var rightReg = /\[sys\.(-)?(\d)+](.id)?|\[main\.(\d)+](.id)?|\[detail_(\d)+\.(\d)+](.id)?/ig;

        temp = temp.replace(/===/g, "#sandenghao#");
        temp = temp.replace(/==/g, "#shuangdenghao#");
        temp = temp.replace(/>=/g, "#dayudengyu#");
        temp = temp.replace(/<=/g, "#xiaoyudengyu#");
        temp = temp.replace(/!=/g, "#budengyu#");
        //等号右侧：公式部分
        var rightFormula;

        var denghaoIndex = temp.indexOf('=');
        var ifIndex = temp.toUpperCase().indexOf('IF');
        var openParenIndex = temp.toUpperCase().indexOf('(');
        var hasEqual = false;
        if (ifIndex > -1 && denghaoIndex > -1) {
            if (ifIndex > denghaoIndex) {//等号在前，if在后，此时公式为A=IF(true, B, C)
                rightFormula = temp.substring(temp.indexOf('=') + 1);
            } else {// if在前，等号在后的公式模型。此时公式为IF(true, A=B, C=D)
                rightFormula = temp;
            }
            hasEqual = true;
        } else if (ifIndex > -1) {//有if，无等号，此时公式为IF(true, alert(1), alert(2))
            rightFormula = temp;
        } else if (denghaoIndex > -1 && (denghaoIndex < openParenIndex || openParenIndex < 0)) {//有等号，无if，此时公式为A=B
            rightFormula = temp.substring(temp.indexOf('=') + 1);
            hasEqual = true;
        } else {//无等号，无if，此时公式为alert(1)
            if (denghaoIndex >= 0) {
                hasEqual = true;
            }
            rightFormula = temp;
        }

        rightFormula = rightFormula.replace(/#sandenghao#/g, "===");
        rightFormula = rightFormula.replace(/#shuangdenghao#/g, "==");
        rightFormula = rightFormula.replace(/#dayudengyu#/g, ">=");
        rightFormula = rightFormula.replace(/#xiaoyudengyu#/g, "<=");
        rightFormula = rightFormula.replace(/#budengyu#/g, "!=");
        rightFormula = rightFormula.replace(/\.id/ig, ".id");

        var rightValue = rightFormula.match(rightReg);
        if (rightValue && rightValue.length > 0) {
            for(j = 0; j < rightValue.length; j++) {
                rightValue[j] = rightValue[j].replace(/\[/g, "");
                rightValue[j] = rightValue[j].replace(/]/g, "");
                rightValue[j] = rightValue[j].replace(/\.id/ig, ".id");
            }
        }
        var ret = {};
        ret.rightFormula = rightFormula;
        ret.rightValue = rightValue;
        ret.hasEqual = hasEqual;
        return ret;
    }

    /**
     * 返回公式的赋值字段
     */
    function getLeftValue(temp) {
        var leftReg = /\[sys\.(-)?(\d)+]|\[main\.(\d)+]|\[detail_(\d)+\.(\d)+]/g;

        temp = temp.replace(/===/g, "#sandenghao#");
        temp = temp.replace(/==/g, "#shuangdenghao#");
        temp = temp.replace(/>=/g, "#dayudengyu#");
        temp = temp.replace(/<=/g, "#xiaoyudengyu#");
        temp = temp.replace(/!=/g, "#budengyu#");

        var denghaoIndex = temp.indexOf('=');
        var ifIndex = temp.toUpperCase().indexOf('IF');
        var dotIndex = temp.toUpperCase().indexOf(',');
        var openParenIndex = temp.toUpperCase().indexOf('(');
        //等号左侧：赋值单元格
        if (denghaoIndex > dotIndex && dotIndex > -1) {//此时公式为FomulaA("A=b")
            denghaoIndex = -1;
        }
        if (ifIndex > -1 && denghaoIndex > ifIndex) {//此时公式为IF(true, A=B, C=D)
            denghaoIndex = -1;
        }
        var leftFormula;
        var hasEqual = false;
        if (denghaoIndex > 0 && (denghaoIndex < openParenIndex || openParenIndex < 0)) {
            leftFormula = temp.substring(0, temp.indexOf('='));
            hasEqual = true;
        } else if (denghaoIndex > 0) {
            leftFormula = temp.substring(0, temp.indexOf('='));
            hasEqual = true;
        } else {
            if (denghaoIndex >= 0) {
                hasEqual = true;
            }
            leftFormula = "";
        }

        leftFormula = leftFormula.replace(/#sandenghao#/g, "===");
        leftFormula = leftFormula.replace(/#shuangdenghao#/g, "==");
        leftFormula = leftFormula.replace(/#dayudengyu#/g, ">=");
        leftFormula = leftFormula.replace(/#xiaoyudengyu#/g, "<=");
        leftFormula = leftFormula.replace(/#budengyu#/g, "!=");

        var isMultiLeft = false;
        var leftValue = leftFormula.match(leftReg);
        if (leftValue && leftValue.length > 0) {
            for(j = 0; j < leftValue.length; j++) {
                leftValue[j] = leftValue[j].replace(/\[/g, "");
                leftValue[j] = leftValue[j].replace(/]/g, "");
            }
            if (leftValue.length > 1) {
                isMultiLeft = true;
            } else if (leftValue.length == 1){
                var reg = /(main|tab_\d+|detail_\d+)![a-z]+\d+/g;
                leftFormula = leftFormula.toLowerCase();
                var posLeftValue = leftFormula.match(reg);
                if (posLeftValue && posLeftValue.length > 0) {
                    isMultiLeft = true;
                }
            }
            leftValue = leftValue[0];
        } else {
            //非字段单元格
            var reg = /(main|tab_\d+|detail_\d+)![a-z]+\d+/g;
            leftFormula = leftFormula.toLowerCase();
            leftValue = leftFormula.match(reg);
            if (leftValue && leftValue.length > 0) {
                if (leftValue.length > 1) {
                    isMultiLeft = true;
                } else if (leftValue.length == 1) {
                    var tempLeftValue = leftFormula.match(leftReg);
                    if (tempLeftValue && tempLeftValue.length > 0) {
                        isMultiLeft = true;
                    }
                }
                leftValue = leftValue[0];
            } else {
                leftValue = "";
            }
        }

        var ret = {};
        ret.leftFormula = leftFormula;
        ret.leftValue = leftValue;
        ret.hasEqual = hasEqual;
        ret.isMultiLeft = isMultiLeft;
        return ret;
    }

    //公式字符串替换
    function replaceFormulaNew(formulatxt){
        formulatxt = formulatxt.replace(/≥/ig, ">=");
        formulatxt = formulatxt.replace(/÷/ig, "/");
        formulatxt = formulatxt.replace(/×/ig, "*");
        formulatxt = formulatxt.replace(/≤/ig, "<=");
        formulatxt = formulatxt.replace(/≠/ig, "!=");
        formulatxt = formulatxt.replace(/SUM(\s)*\(/ig, "systemFormulaOperate.SUM(");
        formulatxt = formulatxt.replace(/AVERAGE(\s)*\(/ig, "systemFormulaOperate.AVERAGE(");
        formulatxt = formulatxt.replace(/ABS(\s)*\(/ig, "systemFormulaOperate.ABS(");
        formulatxt = formulatxt.replace(/ROUND(\s)*\(/ig, "systemFormulaOperate.ROUND(");
        formulatxt = formulatxt.replace(/COUNT\(/ig, "systemFormulaOperate.COUNT(");
        formulatxt = formulatxt.replace(/COUNTIF\(/ig, "systemFormulaOperate.COUNTIF_(");
        formulatxt = formulatxt.replace(/SUMIF(\s)*\(/ig, "systemFormulaOperate.SUMIF_(");
        formulatxt = formulatxt.replace(/IF\(/ig, "systemFormulaOperate.IF(");
        formulatxt = formulatxt.replace(/MAX(\s)*\(/ig, "systemFormulaOperate.MAX(");
        formulatxt = formulatxt.replace(/CurrMinute(\s)*\(/ig, "systemFormulaOperate.CurrMinute(");
        formulatxt = formulatxt.replace(/MIN(\s)*\(/ig, "systemFormulaOperate.MIN(");
        formulatxt = formulatxt.replace(/CompareDate(\s)*\(/ig, "systemFormulaOperate.CompareDate(");
        formulatxt = formulatxt.replace(/LENGTH(\s)*\(/ig, "systemFormulaOperate.Length(");
        formulatxt = formulatxt.replace(/IsString(\s)*\(/ig, "systemFormulaOperate.IsString(");
        formulatxt = formulatxt.replace(/LOWER(\s)*\(/ig, "systemFormulaOperate.Lower(");
        formulatxt = formulatxt.replace(/UPPER(\s)*\(/ig, "systemFormulaOperate.Upper(");
        formulatxt = formulatxt.replace(/ToString(\s)*\(/ig, "systemFormulaOperate.ToString(");
        formulatxt = formulatxt.replace(/LTRIM(\s)*\(/ig, "systemFormulaOperate.Ltrim(");
        formulatxt = formulatxt.replace(/RTRIM(\s)*\(/ig, "systemFormulaOperate.Rtrim(");
        formulatxt = formulatxt.replace(/TRIM(\s)*\(/g, "systemFormulaOperate.Trim(");
        formulatxt = formulatxt.replace(/IsJSON(\s)*\(/g, "systemFormulaOperate.IsJSON(");
        formulatxt = formulatxt.replace(/GetJSONValue(\s)*\(/g, "systemFormulaOperate.GetJSONValue(");
        formulatxt = formulatxt.replace(/IsNumber(\s)*\(/ig, "systemFormulaOperate.IsNumber(");
        formulatxt = formulatxt.replace(/IsInt(\s)*\(/ig, "systemFormulaOperate.IsInt(");
        formulatxt = formulatxt.replace(/IsFloat(\s)*\(/ig, "systemFormulaOperate.IsFloat(");
        formulatxt = formulatxt.replace(/ToInt(\s)*\(/ig, "systemFormulaOperate.ToInt(");
        formulatxt = formulatxt.replace(/ToFloat(\s)*\(/ig, "systemFormulaOperate.ToFloat(");
        formulatxt = formulatxt.replace(/ToNumber(\s)*\(/ig, "systemFormulaOperate.ToNumber(");
        formulatxt = formulatxt.replace(/CurrDate(\s)*\(/ig, "systemFormulaOperate.CurrDate(");
        formulatxt = formulatxt.replace(/CurrYear(\s)*\(/ig, "systemFormulaOperate.CurrYear(");
        formulatxt = formulatxt.replace(/CurrMonth(\s)*\(/ig, "systemFormulaOperate.CurrMonth(");
        formulatxt = formulatxt.replace(/CurrDay(\s)*\(/ig, "systemFormulaOperate.CurrDay(");
        formulatxt = formulatxt.replace(/CurrWeek(\s)*\(/ig, "systemFormulaOperate.CurrWeek(");
        formulatxt = formulatxt.replace(/CurrHour(\s)*\(/ig, "systemFormulaOperate.CurrHour(");
        formulatxt = formulatxt.replace(/CurrSecond(\s)*\(/ig, "systemFormulaOperate.CurrSecond(");
        formulatxt = formulatxt.replace(/CurrDateTime(\s)*\(/ig, "systemFormulaOperate.CurrDateTime(");
        formulatxt = formulatxt.replace(/GetDateValue(\s)*\(/ig, "systemFormulaOperate.GetDateValue(");
        formulatxt = formulatxt.replace(/CompareWorkDate(\s)*\(/ig, "systemFormulaOperate.CompareWorkDate(");
        formulatxt = formulatxt.replace(/GetHrmLoginid(\s)*\(/ig, "dbFormulaOperate.GetHrmLoginid(");
        formulatxt = formulatxt.replace(/GetHrmName(\s)*\(/ig, "dbFormulaOperate.GetHrmName(");
        formulatxt = formulatxt.replace(/GetHrmMobile(\s)*\(/ig, "dbFormulaOperate.GetHrmMobile(");
        formulatxt = formulatxt.replace(/GetHrmEmail(\s)*\(/ig, "dbFormulaOperate.GetHrmEmail(");
        formulatxt = formulatxt.replace(/GetHrmSeclevel(\s)*\(/ig, "dbFormulaOperate.GetHrmSeclevel(");
        formulatxt = formulatxt.replace(/GetHrmWorkcode(\s)*\(/ig, "dbFormulaOperate.GetHrmWorkcode(");
        formulatxt = formulatxt.replace(/GetHrmManager(\s)*\(/ig, "dbFormulaOperate.GetHrmManager(");
        formulatxt = formulatxt.replace(/GetHrmAllManager(\s)*\(/ig, "dbFormulaOperate.GetHrmAllManager(");
        formulatxt = formulatxt.replace(/GetHrmDepartment(\s)*\(/ig, "dbFormulaOperate.GetHrmDepartment(");
        formulatxt = formulatxt.replace(/GetHrmSubcompany(\s)*\(/ig, "dbFormulaOperate.GetHrmSubcompany(");
        formulatxt = formulatxt.replace(/GetDepartmentName(\s)*\(/ig, "dbFormulaOperate.GetDepartmentName(");
        formulatxt = formulatxt.replace(/GetDepartmentCode(\s)*\(/ig, "dbFormulaOperate.GetDepartmentCode(");
        formulatxt = formulatxt.replace(/GetSuperDepartment(\s)*\(/ig, "dbFormulaOperate.GetSuperDepartment(");
        formulatxt = formulatxt.replace(/GetAllSuperDepartment(\s)*\(/ig, "dbFormulaOperate.GetAllSuperDepartment(");
        formulatxt = formulatxt.replace(/GetSubcompanyName(\s)*\(/ig, "dbFormulaOperate.GetSubcompanyName(");
        formulatxt = formulatxt.replace(/GetSubcompanyCode(\s)*\(/ig, "dbFormulaOperate.GetSubcompanyCode(");
        formulatxt = formulatxt.replace(/GetSuperSubcompany(\s)*\(/ig, "dbFormulaOperate.GetSuperSubcompany(");
        formulatxt = formulatxt.replace(/GetAllSuperSubcompany(\s)*\(/ig, "dbFormulaOperate.GetAllSuperSubcompany(");
        formulatxt = formulatxt.replace(/GetRequestStatus(\s)*\(/ig, "dbFormulaOperate.GetRequestStatus(");
        formulatxt = formulatxt.replace(/GetRequestMark(\s)*\(/ig, "dbFormulaOperate.GetRequestMark(");
        formulatxt = formulatxt.replace(/GetDocCode(\s)*\(/ig, "dbFormulaOperate.GetDocCode(");
        formulatxt = formulatxt.replace(/GetCrmCode(\s)*\(/ig, "dbFormulaOperate.GetCrmCode(");
        formulatxt = formulatxt.replace(/GetPrjCode(\s)*\(/ig, "dbFormulaOperate.GetPrjCode(");
        formulatxt = formulatxt.replace(/GetFnaBudgetfeeCode(\s)*\(/ig, "dbFormulaOperate.GetFnaBudgetfeeCode(");
        formulatxt = formulatxt.replace(/DoCustomSQL(\s)*\(/ig, "dbFormulaOperate.DoCustomSQL(");
        formulatxt = formulatxt.replace(/RAND(\s)*\(/ig, "systemFormulaOperate.RAND(");
        formulatxt = formulatxt.replace(/MOD(\s)*\(/ig, "systemFormulaOperate.MOD(");
        formulatxt = formulatxt.replace(/SUBSTR(\s)*\(/ig, "systemFormulaOperate.SUBSTR(");
        formulatxt = formulatxt.replace(/MAXDATE(\s)*\(/ig, "systemFormulaOperate.MAXDATE(");
        formulatxt = formulatxt.replace(/MINDATE(\s)*\(/ig, "systemFormulaOperate.MINDATE(");
        return formulatxt;
    }

    //弹窗插入新版公式
    function openFormulaNewWin(oldKey, oldFormulaTxt){
        var _dobj = getCurrentDataObj();
        var sheet = getCurrentSheet();
        var ar = sheet.getActiveRowIndex();		///当前活动单元格
        var ac = sheet.getActiveColumnIndex();
        var cellletter = getColHeader(sheet, ac)+(ar+1);
        var fieldid = "";
        var fieldname = "";
        var width = $(window).width()-150;
        var height = $(window).height();
        if (width > 800) width = 800;
        if (height > 700) height = 700;

        //main或detail_2
        var curSymbol = globalData.getCacheValue("symbol").toUpperCase();
        //10,1:{id: "10,1", etype: "Fcontent", efieldid: "8053", efieldtype: "text", formula: "y"}
        if(_dobj.ecs && _dobj.ecs[ar+","+ac] && _dobj.ecs[ar+","+ac].etype === celltype.FCONTENT){
            fieldid = _dobj.ecs[ar+","+ac].efieldid;
            fieldname = getFieldName(_dobj.ecs[ar+","+ac].efieldid);
            if(isDetail === "on" && curSymbol.toUpperCase().indexOf("DETAIL_") > -1){
                fieldname = SystemEnv.getHtmlNoteName("6026",languageId) + getDetailIndexByKey(curSymbol.toUpperCase()) + "." + fieldname;//明细表1.字段名
            } else if (fieldid < 0) {
                fieldname = SystemEnv.getHtmlNoteName("6086", languageId) + "." + fieldname;//系统.字段名
            } else {
                fieldname = SystemEnv.getHtmlNoteName("6027",languageId) + "." + fieldname;//主表.字段名
            }
        }
        isEditFormulaing = true;

        //MAIN.FORMULAB7#new#:"[main.6309]=Lower('ABDcEfghi')###[主表.z4]=Lower('ABDcEfghi')###1#6306##2#6307#_#值改变时  (触发字段：  z1)##获取输入焦点时  (触发字段：  z2)###公式名"
        var _formulaObj = isDetail==="on" ? parentWin_Main.formulaObj : formulaObj;

        var __key = curSymbol+".FORMULA"+cellletter+ "#new#";
        var paramtxt = "";

        //[MAIN.FORMULAB7#new#],[MAIN.FORMULAB10#new#]
        var formulaKeys = containsFormulaKeys();

        if (formulaKeys && formulaKeys.length > 0) {
            //只有一个新版公式时，打开新版公式界面
            if (formulaKeys.length == 1 && !oldFormulaTxt) {
                var tempkey = formulaKeys[0];
                if(_formulaObj.getFormulas() && _formulaObj.getOneFormula(tempkey))
                    paramtxt = _formulaObj.getOneFormula(tempkey);

                paramtxt = encodeURIComponent(paramtxt);

                var formula_dialog = new window.top.Dialog("excelDesignFormulaDialog");
                formula_dialog.currentWindow = window;
                window.top.formula_dialog = formula_dialog;

                var url = "/spa/workflow/static4engine/engine.html#/main/workflowengine/workflowFormula/formular";
                formula_dialog.getparam = function() {
                    return {"isDetail": isDetail, "detailIdenty":detailIdenty, "formid": wfinfo.formid, "isbill": wfinfo.isbill, "wfid":wfinfo.wfid, "fieldid":fieldid, "fieldname":fieldname, "paramtxt": paramtxt, "layouttype": wfinfo.layouttype, "formulaKey": tempkey};
                }
                var titlename = SystemEnv.getHtmlNoteName("5100",languageId);
                if (!titlename) {
                    if (languageId == 8) {
                        titlename = "Insert Formula";
                    } else {
                        titlename = "插入公式";
                    }
                }
                formula_dialog.Title = titlename;//插入公式
                formula_dialog.Width = width;
                formula_dialog.Height = height;
                formula_dialog.Drag = true;
                formula_dialog.Modal = true;
                formula_dialog.normalDialog = false;
                formula_dialog.URL = url;
                formula_dialog.show();
                formula_dialog.closeHandle = function () {
                    $("#formulaMasking1").hide();
                    $("#formulaMasking2").hide();
                    isEditFormulaing = false;
                    sheet.setSelection(ar,ac,1,1);
                };
                formula_dialog.callbackfunc4CloseBtn=function(){        //点击关闭按钮，应还原之前的状态
                    formula_dialog.callbackfunc4CloseBtn = null;
                    var formulaDialogDiv = getFormulaDialogDiv();
                    if (formulaDialogDiv) {
                        formulaDialogDiv.contentWindow.doBSWorkflowAction.closeFormulaWindow();
                    }
                }
                formula_dialog.callbackfun=function(paramobj, result){
                    formula_dialog.callbackfunc4CloseBtn = null;
                    sheet = getCurrentSheet();
                    var dataObj = getCurrentDataObj();
                    var formulaStr = jQuery.trim(result.formula);
                    //公式清除
                    deleteFormulaAndSign(tempkey);
                    //公式保存
                    addFormulaAndSign(tempkey, formulaStr);
                }
            } else if (formulaKeys.length > 1) {
                var formula_dialog = new window.top.Dialog();
                formula_dialog.currentWindow = window;
                window.top.formula_dialog = formula_dialog;
                var listKeys = formulaKeys.join("#_#");

                var formulas = _formulaObj.getFormulas();
                formulas = sortFormulaListKeys(formulas);
                formulas = filterKeys(formulas, listKeys);
                formulas = encodeURIComponent(JSON.stringify(formulas));
                listKeys = encodeURIComponent(listKeys);
                var url = "/spa/workflow/static4engine/engine.html#/main/workflowengine/workflowFormula/FormularList";
                //var url = "/workflow/exceldesign/excelUploadFormulaList.jsp?isDetail="+isDetail+"&formulas="+formulas;
                formula_dialog.getparam = function() {
                    return {"isDetail": isDetail, "detailIdenty":detailIdenty, "formulas": formulas,"formid":wfinfo.formid,"isbill":wfinfo.isbill,"wfid":wfinfo.wfid,"fieldid":fieldid, "fieldname":fieldname, "layouttype": wfinfo.layouttype };
                }
                var titlename = SystemEnv.getHtmlNoteName("5199",languageId);//公式列表
                if (!titlename) {
                    if (languageId == 8) {
                        titlename = "Formula List";
                    } else {
                        titlename = "公式列表";
                    }
                }
                formula_dialog.Title = titlename;
                formula_dialog.Width = 860;
                formula_dialog.Height = 550;
                formula_dialog.formulas = formulas;
                formula_dialog.formid = wfinfo.formid;
                formula_dialog.isbill = wfinfo.isbill;
                formula_dialog.wfid = wfinfo.wfid;
                formula_dialog.globalData = globalData;
                formula_dialog.contentType = celltype.FCONTENT;
                formula_dialog.Drag = true;
                formula_dialog.Modal = true;
                formula_dialog.normalDialog = false;
                formula_dialog.URL = url;
                formula_dialog.show();
                formula_dialog.closeHandle = function () {
                    $("#formulaMasking1").hide();
                    $("#formulaMasking2").hide();
                    isEditFormulaing = false;
                    sheet.setSelection(ar,ac,1,1);
                };
            } else {
                //打开老版公式界面
                return false;
            }
        } else if (!oldFormulaTxt) {
            //新版和老版公式都没有时，打开新版公式新建界面
            var formula_dialog = new window.top.Dialog("excelDesignFormulaDialog");
            formula_dialog.currentWindow = window;
            window.top.formula_dialog = formula_dialog;

            var url = "/spa/workflow/static4engine/engine.html#/main/workflowengine/workflowFormula/formular";
            formula_dialog.getparam = function() {
                return {"isDetail": isDetail, "detailIdenty":detailIdenty, "formid": wfinfo.formid, "isbill": wfinfo.isbill, "wfid":wfinfo.wfid, "fieldid":fieldid, "fieldname":fieldname, "formula": paramtxt, "layouttype": wfinfo.layouttype};
            }
            //var url = "/workflow/exceldesign/excelUploadFormulaNew.jsp?"+
            //    "&formid="+wfinfo.formid+"&isbill="+wfinfo.isbill+"&wfid="+wfinfo.wfid+"&fieldid="+fieldid+"&fieldname="+fieldname;
            var titlename = SystemEnv.getHtmlNoteName("5100",languageId);
            if (!titlename) {
                if (languageId == 8) {
                    titlename = "Insert Formula";
                } else {
                    titlename = "插入公式";
                }
            }
            formula_dialog.Title = titlename;//插入公式
            formula_dialog.Width = width;
            formula_dialog.Height = height;
            formula_dialog.Drag = true;
            formula_dialog.Modal = true;
            formula_dialog.normalDialog = false;
            formula_dialog.URL = url;
            formula_dialog.show();
            formula_dialog.closeHandle = function () {
                $("#formulaMasking1").hide();
                $("#formulaMasking2").hide();
                isEditFormulaing = false;
                sheet.setSelection(ar,ac,1,1);
            };
            formula_dialog.callbackfunc4CloseBtn=function(){        //点击关闭按钮，应还原之前的状态
                formula_dialog.callbackfunc4CloseBtn = null;
                var formulaDialogDiv = getFormulaDialogDiv();
                if (formulaDialogDiv) {
                    formulaDialogDiv.contentWindow.doBSWorkflowAction.closeFormulaWindow(false);
                }
            }
            formula_dialog.callbackfun=function(paramobj, result){
                formula_dialog.callbackfunc4CloseBtn = null;
                sheet = getCurrentSheet();
                var dataObj = getCurrentDataObj();
                var formulaStr = jQuery.trim(result.formula);
                //公式保存
                var newKey = generateFormulaKey();
                addFormulaAndSign(newKey, formulaStr);
            }
        } else {
            //打开老版公式界面
            return false;
        }
    }

    function checkFormula(formulatxt) {
        var options = {
            undef: true
        }
        var predef = {
            x: true
        }
        var result = JSHINT(formulatxt, options, predef);
    }

    /**
     * 公式列表排序
     */
    function sortFormulaListKeys(obj){
        var tmp={};
        Object.keys(obj).sort(function (a,b){
            a = a.toUpperCase();
            b = b.toUpperCase();

            if (a.indexOf("MAIN") > -1 && b.indexOf("DETAIL") > -1) {
                return -1;
            } else if (a.indexOf("DETAIL") > -1 && b.indexOf("MAIN") > -1) {
                return 1;
            } else if (a.indexOf("MAIN") > -1 && b.indexOf("MAIN") > -1) {
                var aPosition = getCellPositionByKey(a);
                var bPosition = getCellPositionByKey(b);
                return sortCellPosition(aPosition, bPosition);
            } else if (a.indexOf("DETAIL") > -1 && b.indexOf("DETAIL") > -1) {
                var aDetailIndex = Number(getDetailIndexByKey(a));
                var bDetailIndex = Number(getDetailIndexByKey(b));
                if (aDetailIndex > bDetailIndex) {
                    return 1;
                } else if (aDetailIndex < bDetailIndex) {
                    return -1;
                } else {
                    var aPosition = getCellPositionByKey(a);
                    var bPosition = getCellPositionByKey(b);
                    return sortCellPosition(aPosition, bPosition);
                }
            }
        }).forEach(function(k){tmp[k]=obj[k]});
        return tmp;
    }

    /**
     * 若传入参数，则列表中只显示所传入KEY的数据
     */
    function filterKeys(obj, formulaKeys) {
        var tmp={};
        var keys;
        //MAIN.FORMULAB7#new##_#MAIN.FORMULAB10#new#
        if (formulaKeys) {
            keys = formulaKeys.split("#_#");
            if (keys && keys.length > 0) {
                Object.keys(obj).forEach(
                    function(k){
                        for (var m = 0; m < keys.length; m++) {
                            if (keys[m] == k) {
                                tmp[k]=obj[k];
                            }
                        }
                    }
                );
            } else {
                tmp = obj;
            }
        } else {
            tmp = obj;
        }

        return tmp;
    }

    function getCellPositionByKey(__key) {
        if (__key.indexOf("#") > -1) {
            return __key.substring(__key.indexOf('FORMULA') + 7, __key.indexOf('#'));
        } else {
            return __key.substring(__key.indexOf('FORMULA') + 7);
        }
    }

    function getDetailIndexByKey(__key) {
        if (__key.indexOf('.') < 0) {
            return  __key.substring(__key.indexOf('DETAIL_') + 7);
        } else {
            return  __key.substring(__key.indexOf('DETAIL_') + 7, __key.indexOf('.'));
        }
    }

    function sortCellPosition(a, b) {
        a = a.toUpperCase();
        b = b.toUpperCase();
        var aCol = a.match(/[A-Z]+/);
        var aRow = Number(a.match(/[0-9]+/));
        var bCol = b.match(/[A-Z]+/);
        var bRow = Number(b.match(/[0-9]+/));
        if (aCol.length > bCol.length) {
            return 1;
        } else if (aCol.length < bCol.length) {
            return -1;
        } else if (a.charCodeAt() < b.charCodeAt()) {
            return -1;
        } else if (a.charCodeAt() > b.charCodeAt()) {
            return 1;
        } else if (aRow > bRow) {
            return 1;
        } else {
            return -1;
        }
    }

    /**
     * 新版公式的key
     */
    function generateFormulaKey() {
        var currdate = new Date();
        //返回的时间戳，精确到了毫秒
        return Number(currdate) + "#new#";
    }

    /**
     * 参数所指定单元格中包含的公式key，若参数为空，则是当前单元格
     */
    function containsFormulaKeys(row, col, symbol) {
        var formulaKeys = new Array();

        var curSymbol = globalData.getCacheValue("symbol").toUpperCase();

        var _dobj;
        var sheet;
        if (symbol && symbol.toUpperCase() != curSymbol) {
            if(!globalData.hasCache(symbol))
                return "";
            var excelDiv;
            //由于拼接datajson需要用到对应的sheet面板内容，故每次拼接需将sheetjson恢复在隐藏的面板中，只用于保存
            if(symbol.indexOf("detail_") > -1){
                excelDiv = jQuery("#excelDiv");
            }else{
                excelDiv = jQuery("#excelDiv_hidden");
                var sheetJson = globalSheet.getCacheValue(symbol+"_sheet");
                formOperate.onlyResumePanelFace(excelDiv, sheetJson);
            }
            sheet = excelDiv.wijspread("spread").getActiveSheet();
            _dobj = globalData.getCacheValue(symbol);
        } else {
            _dobj = getCurrentDataObj();
            sheet = getCurrentSheet();
        }
        var ar;
        var ac;
        if (typeof row != "undefined") {
            ar = row;
        } else {
            ar = sheet.getActiveRowIndex();     ///当前活动单元格
        }
        if (typeof col != "undefined") {
            ac = col;
        } else {
            ac = sheet.getActiveColumnIndex();
        }
        var fieldid = "";
        //10,1:{id: "10,1", etype: "Fcontent", efieldid: "8053", efieldtype: "text", formula: "y"}
        if(_dobj.ecs && _dobj.ecs[ar+","+ac] && _dobj.ecs[ar+","+ac].etype === celltype.FCONTENT){
            fieldid = _dobj.ecs[ar+","+ac].efieldid;
        }

        var cellletter = getColHeader(sheet, ac)+(ar+1);
        if (symbol && symbol.toUpperCase() != curSymbol) {
            curSymbol = symbol.toUpperCase();
        }
        var __oldkey = curSymbol+".FORMULA"+cellletter;

        var reg = /(main|tab_\d+|detail_\d+)![a-z]+\d+/g;
        //MAIN.FORMULAB7#new#:"[main.6309]=Lower('ABDcEfghi')###[主表.z4]=Lower('ABDcEfghi')###1#6306##2#6307#_#值改变时  (触发字段：  z1)##获取输入焦点时  (触发字段：  z2)###公式名"
        var _formulaObj = isDetail==="on" ? parentWin_Main.formulaObj : formulaObj;
        var paramtxt = "";
        var formulas = _formulaObj.getFormulas();
        //MAIN.FORMULAB7#new##_#MAIN.FORMULAB10#new#
        if (formulas) {
            for(var __key in formulas){
                var formulaStr = formulas[__key].trim();
                if (formulaStr) {
                    //MAIN.FORMULAB7#new#:"[main.6309]=Lower('ABDcEfghi')###[主表.z4]=Lower('ABDcEfghi')###1#6306##2#6307#_#值改变时  (触发字段：  z1)##获取输入焦点时  (触发字段：  z2)###公式名"
                    //MAIN.FORMULAB7#new#:"[main.6309]=Lower('ABDcEfghi')###[主表.z4]=Lower('ABDcEfghi')###1#6306##2#6307#_#值改变时  (触发字段：  z1)##获取输入焦点时  (触发字段：  z2)###公式名"
                    var formulaArr = formulaStr.split("###");
                    if (formulaArr && formulaArr.length >= 3) {
                        if (fxContainsLeft == true) {
                            var singleFormula = formulaArr[0].split("#rn#");
                            for (var i = 0; i < singleFormula.length; i++) {
                                var temp = singleFormula[i];
                                var leftValue = getLeftValue(temp).leftValue;

                                if (leftValue) {
                                    var newleftValue = leftValue;
                                    if (leftValue.indexOf(".") > -1) {
                                        newleftValue = leftValue.substring(leftValue.indexOf(".") + 1);
                                    } else if (leftValue.indexOf("!") > -1) {
                                        newleftValue = leftValue.substring(leftValue.indexOf("!") + 1);
                                    }
                                    if (fieldid == newleftValue) {
                                        formulaKeys.push(__key);
                                    } else {
                                        leftValue = leftValue.toLowerCase();
                                        leftValue = leftValue.match(reg);
                                        if (leftValue && leftValue.length > 0) {
                                            if (curSymbol == leftValue[0].split("!")[0].toUpperCase()) {
                                                var newCellIndex = getCellIndexByLetter(sheet, leftValue[0].split("!")[1].toUpperCase());
                                                if (newCellIndex == ar + "," + ac) {
                                                    formulaKeys.push(__key);
                                                }
                                            }
                                        }
                                    }
                                }
                            }
                        }
                    } else if (__key == __oldkey) {
                        formulaKeys.push(__key);
                    }
                }
            }
        }
        return formulaKeys;
    }

    /**
     * 返回单元格与公式数量的json数据
     */
    function getFormulaCountJson() {
        var cellCountJson = {};

        //MAIN.FORMULAB7#new#:"[main.6309]=Lower('ABDcEfghi')###[主表.z4]=Lower('ABDcEfghi')###1#6306##2#6307#_#值改变时  (触发字段：  z1)##获取输入焦点时  (触发字段：  z2)###公式名"
        var _formulaObj = isDetail==="on" ? parentWin_Main.formulaObj : formulaObj;
        var paramtxt = "";
        var formulas = _formulaObj.getFormulas();
        //MAIN.FORMULAB7#new##_#MAIN.FORMULAB10#new#
        if (formulas) {
            for(var __key in formulas){
                var formulaStr = formulas[__key].trim();
                if (formulaStr) {
                    //MAIN.FORMULAB7#new#:"[main.6309]=Lower('ABDcEfghi')###[主表.z4]=Lower('ABDcEfghi')###1#6306##2#6307#_#值改变时  (触发字段：  z1)##获取输入焦点时  (触发字段：  z2)###公式名"
                    //MAIN.FORMULAB7#new#:"[main.6309]=Lower('ABDcEfghi')###[主表.z4]=Lower('ABDcEfghi')###1#6306##2#6307#_#值改变时  (触发字段：  z1)##获取输入焦点时  (触发字段：  z2)###公式名"
                    var formulaArr = formulaStr.split("###");
                    //新版公式
                    if (formulaArr && formulaArr.length >= 3) {
                        if (fxContainsLeft == true) {
                            var singleFormula = formulaArr[0].split("#rn#");
                            for (var i = 0; i < singleFormula.length; i++) {
                                var temp = singleFormula[i];
                                var leftValue = getLeftValue(temp).leftValue;
                                if (leftValue) {
                                    if (leftValue.indexOf(".") > -1) {
                                        leftValue = leftValue.substring(leftValue.indexOf(".") + 1);
                                    } else if (leftValue.indexOf("!") > -1) {
                                        leftValue = leftValue.substring(leftValue.indexOf("!") + 1);
                                    }
                                    //系统函数是负数，转换成下划线
                                    if (leftValue.indexOf("-") > -1) {
                                        leftValue = leftValue.replace("-", "_");
                                    }
                                    var tempCount = eval("cellCountJson.cell" + leftValue);
                                    if (tempCount) {
                                        eval("cellCountJson.cell" + leftValue + "=" + (Number(tempCount) + 1));
                                    } else {
                                        eval("cellCountJson.cell" + leftValue + "=" + 1);
                                    }
                                }
                            }
                        }
                    } else if (formulaArr) {
                        //老版公式
                        var cellletter = __key.substring(__key.indexOf(".FORMULA") + 8);
                        //将B8转换为1,7
                        var row = parseInt(cellletter.match(/\d+$/)[0])-1;
                        var col = cellletter.match(/^[a-zA-Z]+/)[0];
                        col = parseInt(morecharToInt(col))-1;
                        var cellid = row+","+col;

                        var fieldid;
                        //MAIN.FORMULAB9:"=SUM(main.B9)"
                        var symbol = __key.substring(0, __key.indexOf("."));
                        var _dobj = getDataObjBySymbolNew(symbol.toLowerCase());
                        if (_dobj) {
                            if (_dobj.ecs && _dobj.ecs[cellid] && _dobj.ecs[cellid].etype === celltype.FCONTENT) {
                                fieldid = _dobj.ecs[cellid].efieldid;
                                //系统函数是负数，转换成下划线
                                if (fieldid.indexOf("-") > -1) {
                                    fieldid = fieldid.replace("-", "_");
                                }
                                var tempCount = eval("cellCountJson.cell" + fieldid);
                                if (tempCount) {
                                    eval("cellCountJson.cell" + fieldid + "=" + (Number(tempCount) + 1));
                                } else {
                                    eval("cellCountJson.cell" + fieldid + "=" + 1);
                                }
                            }
                        }
                    }
                }
            }
        }
        return cellCountJson;
    }

    /**
     * 删除指定key的公式，并刷新当前页面相应单元格的fx状态
     */
    //MAIN.FORMULAB7#new#
    function deleteFormulaAndSign(__key) {
        //MAIN.FORMULAB7#new#:"[main.6309]=Lower('ABDcEfghi')###[主表.z4]=Lower('ABDcEfghi')###1#dt1.6306##2#6307#_#值改变时  (触发字段：  明细1.z1)##获取输入焦点时  (触发字段：  z2)###公式名"
        var _formulaObj = isDetail==="on" ? parentWin_Main.formulaObj : formulaObj;
        var paramtxt = _formulaObj.getOneFormula(__key);

        var formulaArr = paramtxt.split("###");
        var fieldArray = new Array();

        var cellCountJson = getFormulaCountJson();
        if (formulaArr && formulaArr.length >= 3) {
            if (fxContainsLeft == true) {
                var singleFormula = formulaArr[0].split("#rn#");
                for (var i = 0; i < singleFormula.length; i++) {
                    var temp = singleFormula[i];
                    var leftValue = getLeftValue(temp).leftValue;
                    if (leftValue) {
                        var varTemp = "";
                        if (leftValue.indexOf(".") > -1) {
                            //main.5778变成5778
                            varTemp = leftValue.substring(leftValue.indexOf(".") + 1);
                        } else if (leftValue.indexOf("!") > -1) {
                            //main!b5变成b5
                            varTemp = leftValue.substring(leftValue.indexOf("!") + 1);
                        }
                        //系统函数是负数，转换成下划线
                        if (varTemp.indexOf("-") > -1) {
                            varTemp = varTemp.replace("-", "_");
                        }
                        if (leftValue.indexOf(".") > -1) {
                            if (leftValue.indexOf("main") > -1) {
                                //main.5778变成5778
                                leftValue = leftValue.substring(leftValue.indexOf(".") + 1);
                            } else if (leftValue.indexOf("detail") > -1) {
                                //detail_2.5778变成dt2.5778
                                leftValue = "dt" + leftValue.substring(leftValue.indexOf("_") + 1);
                            } else if (leftValue.indexOf("tab") > -1) {
                                //tab_2.5778变成tab_2.5778
                                leftValue = leftValue;
                            }
                        } else if (leftValue.indexOf("!") > -1) {
                            if (leftValue.indexOf("main") > -1) {
                                //main!b5变成b5
                                leftValue = leftValue.substring(leftValue.indexOf("!") + 1);
                            } else if (leftValue.indexOf("detail") > -1) {
                                //detail_2!b5变成dt2.b5
                                leftValue = ("dt" + leftValue.substring(leftValue.indexOf("_") + 1)).replace("!",".");
                            } else if (leftValue.indexOf("tab") > -1) {
                                //tab_2!b5变成tab_2.b5
                                leftValue = leftValue.replace("!",".");
                            }
                        }
                        var tempCount = eval("cellCountJson.cell" + varTemp);
                        if (tempCount && Number(tempCount) == 1) {
                            fieldArray.push(leftValue);
                        }
                    }
                }
            }
            _formulaObj.delOneFormula(__key);

            var cur_symbol = globalData.getCacheValue("symbol");
            var sheet = getCurrentSheet();
            var dataObj = getCurrentDataObj();

            for (var i = 0; i < fieldArray.length; i++) {
                var ret = getCellIndex(fieldArray[i]);
                if (ret && !!!ret.symbol) {//ret.symbol所设置的公式不在当前面板，并且被赋值单元格为非字段单元格
                    var ar = ret.row;
                    var ac = ret.col;
                    controlFormulaSign(sheet, ar, ac, "remove");
                    if(dataObj.ecs[ar+","+ac] && dataObj.ecs[ar+","+ac].formula)
                        delete dataObj.ecs[ar+","+ac].formula;
                }
            }
        } else {
            _formulaObj.delOneFormula(__key);
            //detail_1
            var cur_symbol = globalData.getCacheValue("symbol");
            var detailNum = 0;
            if (cur_symbol.indexOf("detail_") > -1) {
                var tempdetailNum = cur_symbol.substring(cur_symbol.indexOf("detail_") + 6 + 1);
                detailNum = tempdetailNum;
            }

            var keyDetailNum = 0;
            if (__key.indexOf("DETAIL_") > -1) {
                var tempdetailNum = __key.substring(__key.indexOf("DETAIL_") + 6 + 1, __key.indexOf("."));
                keyDetailNum = tempdetailNum;
            }
            if (detailNum == keyDetailNum) {
                var cellPosition = getCellPositionByKey(__key);

                var ar = parseInt(cellPosition.match(/\d+$/)[0]) - 1;
                var ac = cellPosition.match(/^[a-zA-Z]+/)[0];
                ac = parseInt(morecharToInt(ac)) - 1;

                var sheet = getCurrentSheet();
                var dataObj = getCurrentDataObj();

                controlFormulaSign(sheet, ar, ac, "remove");
                if (dataObj.ecs[ar + "," + ac] && dataObj.ecs[ar + "," + ac].formula)
                    delete dataObj.ecs[ar + "," + ac].formula;
            }
            return;
        }
    }

    /**
     * 将指定公式内容按所传参数KEY保存到公式缓存中，并且刷新当前页面fx状态
     */
    function addFormulaAndSign(__key, formulaStr) {

        if (!formulaStr) {
            return;
        }
        var formulaArr = formulaStr.split("###");
        var fieldArray = new Array();
        if (formulaArr && formulaArr.length >= 3) {
            if (fxContainsLeft == true) {
                var singleFormula = formulaArr[0].split("#rn#");
                for (var i = 0; i < singleFormula.length; i++) {
                    var temp = singleFormula[i];
                    var leftValue = getLeftValue(temp).leftValue;
                    if (leftValue) {
                        if (leftValue.indexOf(".") > -1) {
                            if (leftValue.indexOf("main") > -1) {
                                //main.5778变成5778
                                leftValue = leftValue.substring(leftValue.indexOf(".") + 1);
                            } else if (leftValue.indexOf("detail") > -1) {
                                //detail_2.5778变成dt2.5778
                                leftValue = "dt" + leftValue.substring(leftValue.indexOf("_") + 1);
                            } else if (leftValue.indexOf("tab") > -1) {
                                //tab_2.5778变成tab_2.5778
                                leftValue = leftValue;
                            }
                        } else if (leftValue.indexOf("!") > -1) {
                            if (leftValue.indexOf("main") > -1) {
                                //main!b5变成b5
                                leftValue = leftValue.substring(leftValue.indexOf("!") + 1);
                            } else if (leftValue.indexOf("detail") > -1) {
                                //detail_2!b5变成dt2.b5
                                leftValue = ("dt" + leftValue.substring(leftValue.indexOf("_") + 1)).replace("!",".");
                            } else if (leftValue.indexOf("tab") > -1) {
                                //tab_2!b5变成tab_2.b5
                                leftValue = leftValue.replace("!",".");
                            }
                        }
                        fieldArray.push(leftValue);
                    }
                }
            }
        }

        var _formulaObj = isDetail==="on" ? parentWin_Main.formulaObj : formulaObj;
        _formulaObj.setOneFormula(__key, formulaStr);
        var sheet = getCurrentSheet();
        for (var i = 0; i < fieldArray.length; i++) {
            var ret = getCellIndex(fieldArray[i]);
            if (ret && !!!ret.symbol) {//ret.symbol所设置的公式不在当前面板，并且被赋值单元格为非字段单元格
                var ar = ret.row;
                var ac = ret.col;
                //公式保存
                try{
                    sheet.isPaintSuspended(true);
                    controlFormulaSign(sheet, ar, ac, "add");
                    sheet.isPaintSuspended(false);
                    setCellProperties(ar+","+ac,"",{"formula":"y"});
                }catch(e){
                    window.top.Dialog.alert(e.message);
                }
            }
        }
    }

    function getCellIndex(cell) {
        if (!cell) {
            return;
        }
        var symbol = "";
        var fieldid = "";
        //dt2.6349
        if (cell.indexOf("dt") > -1) {
            var detailIndex = cell.substring(2, cell.indexOf("."));
            symbol = "detail_" + detailIndex;
            fieldid = cell.substring(cell.indexOf(".") + 1);
        } else if (cell.indexOf("tab") > -1) {
            symbol = cell.substring(0, cell.indexOf("."));
            fieldid = cell.substring(cell.indexOf(".") + 1);
        } else if (cell.indexOf("sys") > -1) {
            symbol = "main";
            fieldid = cell.substring(cell.indexOf(".") + 1);
        } else {
            symbol = "main";
            fieldid = cell;
        }
        //
        if(!globalData.hasCache(symbol))
            return;

        var ret = {};

        var reg = /[a-z]+\d+/g;
        var matchField = fieldid.match(reg);
        if (matchField && matchField.length > 0) {
            if (symbol == globalData.getCacheValue("symbol")) {
                var sheet = getCurrentSheet();
                var letter = getCellIndexByLetter(sheet, matchField[0].toUpperCase());
                if (letter) {
                    var letters = letter.split(",");
                    ret.row = letters[0];
                    ret.col = letters[1];
                    return ret;
                }
            } else {
                var letter = getCellIndexByLetterNew(matchField[0]);
                if (letter) {
                    var letters = letter.split(",");
                    ret.symbol = symbol;
                    ret.row = letters[0];
                    ret.col = letters[1];
                    return ret;
                }
            }
        } else {
            var _dobj = getDataObjBySymbol(symbol);
            var ecs;
            if (_dobj.ecs) {
                ecs = _dobj.ecs;
                for (var item in ecs) {
                    var id_x = item.split(",")[0];
                    var id_y = item.split(",")[1];
                    var efieldid = ecs[item].efieldid;
                    var etype = ecs[item].etype;
                    if (efieldid && efieldid == fieldid && etype === celltype.FCONTENT) {
                        ret.row = id_x;
                        ret.col = id_y;
                        if (symbol != globalData.getCacheValue("symbol")) {
                            ret.symbol = symbol;
                        }
                        return ret;
                    }
                }
            }
            if (symbol == "main") {
                var tablist = tabOperate.getTabListFace();
                for (var key in tablist) {
                    var _dobj = getDataObjBySymbol(key);
                    var ecs;
                    if (_dobj.ecs) {
                        ecs = _dobj.ecs;
                        for (var item in ecs) {
                            var id_x = item.split(",")[0];
                            var id_y = item.split(",")[1];
                            var efieldid = ecs[item].efieldid;
                            var etype = ecs[item].etype;
                            if (efieldid && efieldid == fieldid && etype === celltype.FCONTENT) {
                                ret.row = id_x;
                                ret.col = id_y;
                                if (key != globalData.getCacheValue("symbol")) {
                                    ret.symbol = key;
                                }
                                return ret;
                            }
                        }
                    }
                }
            }
        }
    }
    //转换前的公式：main.B6=sum(main.B8,detail_2.G4)
    //转换后的公式：[main.5801]=sum([main.5803],[detail2.6603])###[主表.预算费用]=sum([主表.出差费用],[明细2.住宿申请金额])###1#5805##1#5797#_#值改变时  (触发字段：  出差费用)##值改变时  (触发字段：  住宿申请金额)
    function transferOldFormulaToNew(oldFormula) {
        var reg = /(MAIN|TAB_\d+|DETAIL_\d+)\.[A-Z]+\d+/g;
        if (oldFormula) {
            oldFormula = oldFormula.toUpperCase();
            var tempJson;
            var fieldid;
            var fieldname;
            var cellid;
            var cellname;
            var formulaid = oldFormula;
            var formulaname = oldFormula;
            var triggerid = "";
            var triggerdesc = "";
            oldFormula.match(reg).forEach(function(value,index,array){
                tempJson = transferOldCellToNew(value);
                //5803
                fieldid = tempJson.fieldid;
                //预算费用
                fieldname = tempJson.fieldname;
                //[main.5803]
                cellid = tempJson.cellid;
                //[主表.预算费用]
                cellname = tempJson.cellname;
                //[main.5801]=sum([main.5803],[detail2.6603])
                formulaid = formulaid.replace(value, cellid);
                //[主表.预算费用]=sum([主表.出差费用],[明细2.住宿申请金额])
                formulaname = formulaname.replace(value, cellname);
                if (fieldid && triggerid.indexOf(fieldid) == -1) {
                    if (triggerid) {
                        triggerid += "##";
                        triggerdesc += "##";
                    }
                    //1#5805##1#5797
                    triggerid += "1#"+fieldid;
                    //值改变时  (触发字段：  出差费用)##值改变时  (触发字段：  住宿申请金额)
                    triggerdesc += "值改变时  (触发字段：  " + fieldname + ")";
                }
            });
            return formulaid + "###" + formulaname + "###" + triggerid + "#_#" + triggerdesc;
        }
    }

    //main.B8 -> {cellid:[main.5803],cellname:[主表.预算费用]}
    //detail_2.G4 -> {cellid:[detail2.6603],cellname:[明细2.住宿申请金额]}
    function transferOldCellToNew(old) {
        var sheet = getCurrentSheet();
        if (old) {
            old = old.toUpperCase();
            var cellid = "[";
            var cellname = "[";
            if (old.indexOf("MAIN") > -1) {
                symbol = "MAIN";
                cellid += "main";
            } else if (old.indexOf("DETAIL_") > -1) {
                var detailNum = old.substring(old.indexOf("DETAIL_") + 6 + 1, old.indexOf("."));
                cellid += "detail" + detailNum;
                cellname += "明细" + detailNum;
            }

            cellid += ".";
            cellname += ".";
            var cellletter = old.substring(old.indexOf(".") + 1);
            //将B8转换为1,7
            var cellIndex = getCellIndexByLetter(sheet, cellletter);
            var fieldid;
            var fieldname;

            var symbol = old.substring(0, old.indexOf(".")).toLowerCase();
            var _dobj = getDataObjBySymbol(symbol);
            if(_dobj.ecs && _dobj.ecs[cellIndex] && _dobj.ecs[cellIndex].etype === celltype.FCONTENT){
                fieldid = _dobj.ecs[cellIndex].efieldid;
                fieldname = getFieldName(_dobj.ecs[cellIndex].efieldid);
            }

            cellid =  cellid + fieldid + "]";
            cellname =  cellname + fieldname + "]";
            return {"cellid":cellid, "cellname": cellname, "fieldid": fieldid, "fieldname": fieldname};
        }
    }

    function getDataObjBySymbolNew(symbol){
        var _globalData = isDetail==="on" ? parentWin_Main.globalData : globalData;
        if(isEditMoreContent){
            var mcpoint = jQuery("input#mcpoint").val();
            if(mcpoint !=="" && _globalData.hasCache(mcpoint))
                return _globalData.getCacheValue(mcpoint);
        }else{
            if(_globalData.hasCache(symbol))
                return _globalData.getCacheValue(symbol)
        }
        return null;
    }

    function getDataObjBySymbol(symbol){
        if(isEditMoreContent){
            var mcpoint = jQuery("input#mcpoint").val();
            if(mcpoint !=="" && globalData.hasCache(mcpoint))
                return globalData.getCacheValue(mcpoint);
        }else{
            if(globalData.hasCache(symbol))
                return globalData.getCacheValue(symbol)
        }
        return null;
    }
    //将B8转换为7,1
    function getCellIndexByLetter(sheet, cellletter){
        var tempLetter;
        for (var i = 0; i < sheet.getRowCount(); i++){
            for (var j = 0; j < sheet.getColumnCount(); j++) {
                tempLetter = getColHeader(sheet, j)+(i+1);
                if (tempLetter && tempLetter == cellletter) {
                    return i+","+j;
                }
            }
        }
    }

    //将B8转换为7,1
    function getCellIndexByLetterNew(cellletter){
        var tempLetter;

        cellletter = cellletter.toLowerCase();
        var reg = /[a-z]+\d+/g;
        var matchField = cellletter.match(reg);
        if (matchField && matchField.length > 0) {
            var row = 0;
            var column = 0;

            reg = /[a-z]+/g;
            var columnField = matchField[0].match(reg);
            if (columnField && columnField.length > 0) {
                column = convertNum(columnField[0])
                column = column - 1;
            }

            reg = /\d+/g;
            var rowField = matchField[0].match(reg);
            if (rowField && rowField.length > 0) {
                row = parseInt(rowField[0]) - 1;
            }
            return row+","+column;
        }
    }

    function convertNum(str) {
        var n = 0;
        var s = str.match(/./g);//求出字符数组
        var j = 0;
        for (var i = str.length - 1, j = 1; i >= 0; i--, j *= 26) {
            var c = s[i].toUpperCase();
            if (c < 'A' || c > 'Z') {
                return 0;
            }
            n += (c.charCodeAt(0) - 64) * j;
        }
        return n;
    }

    //公式字符串替换
    function replaceNewFormula(formulatxt){
        formulatxt = formulatxt.replace(/main./ig, "MAIN.");
        formulatxt = formulatxt.replace(/(tab_)(\d+)\./ig, "TAB_$2.");
        formulatxt = formulatxt.replace(/(detail_)(\d+)\./ig, "DETAIL_$2.");
        for (var i = formulaNames.length - 1; i >= 0; i--){
            var temp = new RegExp( formulaNames[i].name + "(\\s)*\\(", "ig");
            formulatxt = formulatxt.replace(temp, formulaNames[i].funcname + "(");
        }
        return formulatxt;
    }

    //弹窗插入公式
    function openFormulaWin(){
        jQuery.ajax({
            url : "/workflow/exceldesign/excelUploadFormula_Property.jsp",
            type : "post",
            processData : false,
            data : "",
            dataType : "text",
            async : false,
            success: function do4Success(msg){
                var _dobj = getCurrentDataObj();
                var sheet = getCurrentSheet();
                var ar = sheet.getActiveRowIndex();     ///当前活动单元格
                var ac = sheet.getActiveColumnIndex();
                var cellletter = getColHeader(sheet, ac)+(ar+1);
                if(_dobj.ecs && _dobj.ecs[ar+","+ac] && _dobj.ecs[ar+","+ac].etype === celltype.FCONTENT){
                }
                //else{
                //  window.top.Dialog.alert("非字段单元格，不支持公式设置！");
                //  return;
                //}
                isEditFormulaing = true;

                var _formulaObj = isDetail==="on" ? parentWin_Main.formulaObj : formulaObj;
                var curSymbol = globalData.getCacheValue("symbol").toUpperCase();
                var __key = curSymbol+".FORMULA"+cellletter;
                var paramtxt = ""
                if(_formulaObj.getFormulas() && _formulaObj.getOneFormula(__key)) {
                    paramtxt = _formulaObj.getOneFormula(__key);
                }

                // if (msg == 1) {
                    var formulaNewValue = openFormulaNewWin(__key, paramtxt);
                    if (formulaNewValue != false || !paramtxt) {
                        return;
                    }
                // }

                paramtxt = encodeURIComponent(paramtxt)

                var formula_dialog = new window.top.Dialog("excelDesignFormulaDialog");
                formula_dialog.currentWindow = window;
                window.top.formula_dialog = formula_dialog;
                var url = "/workflow/exceldesign/excelUploadFormula.jsp?isDetail="+isDetail+"&detailIdenty="+detailIdenty+"&paramtxt="+paramtxt;
                formula_dialog.Title = SystemEnv.getHtmlNoteName("5100",languageId);//插入公式
                formula_dialog.Width = 630;
                formula_dialog.Height = 550;
                formula_dialog.Drag = true;
                formula_dialog.Modal = true;
                formula_dialog.normalDialog = false;
                formula_dialog.URL = url;
                formula_dialog.show();
                formula_dialog.closeHandle = function () {
                    $("#formulaMasking1").hide();
                    $("#formulaMasking2").hide();
                    isEditFormulaing = false;
                    sheet.setSelection(ar,ac,1,1);
                };
                formula_dialog.callbackfunc4CloseBtn=function(){        //点击关闭按钮，应还原之前的状态
                    formula_dialog.callbackfunc4CloseBtn = null;
                    formula_dialog.innerWin.setFormula(false);
                }
                formula_dialog.callbackfun=function(paramobj, result){
                    formula_dialog.callbackfunc4CloseBtn = null;
                    sheet = getCurrentSheet();
                    var dataObj = getCurrentDataObj();
                    var formulaStr = jQuery.trim(result.formula);
                    //公式清除
                    if(!formulaStr){
                        _formulaObj.delOneFormula(__key);
                        controlFormulaSign(sheet, ar, ac, "remove");
                        if(dataObj.ecs[ar+","+ac].formula)
                            delete dataObj.ecs[ar+","+ac].formula;
                        return;
                    }
                    //公式保存
                    try{
                        sheet.isPaintSuspended(true);
                        _formulaObj.setOneFormula(__key, formulaStr);
                        controlFormulaSign(sheet, ar, ac, "add");
                        sheet.isPaintSuspended(false);
                        //理论上明细点击关闭应去掉明细设置的公式，暂未实现
                        //if(isDetail === "on")
                        //  detailFormulaTempAry.push(__key);
                        setCellProperties(ar+","+ac,"",{"formula":"y"});
                    }catch(e){
                        window.top.Dialog.alert(e.message);
                    }
                }
            }
        });
    }

    //插入/删除行列，需对公式位移
    function formulaOffset_changeRC(rc, opreation, activenum, movenum){
        var symbol = globalData.getCacheValue("symbol")+".";
        var	keyHead = symbol.toUpperCase()+"FORMULA";
        var reg = eval("/"+symbol+"[A-Z]+\\d+/g");

        var _formulaObj = isDetail==="on" ? parentWin_Main.formulaObj : formulaObj;
        var _formulaObj_new = new formulaEncapsulation();
        for(var __key in _formulaObj.getFormulas()){
            var formulaStr = jQuery.trim(_formulaObj.getOneFormula(__key));
            _formulaObj.delOneFormula(__key);
            var __key_offset = __key;
            var formulaStr_offset = formulaStr;
            if (__key.indexOf("#new#") > -1) {
                formulaStr_offset = formulaOffset_changeRCNew(rc, opreation, activenum, movenum, formulaStr);
            } else {
                if (__key.indexOf(keyHead) > -1) {	//__key需位移
                    var cellletter = __key.replace(keyHead, "");
                    var cellletter_offset = getCellletter_offset(rc, opreation, activenum, movenum, cellletter);
                    __key_offset = keyHead + cellletter_offset;
                }
                if (formulaStr.match(reg)) {	//公式串需位移
                    //需使用占位符两次替换，避免(B18,B19)增加行时被替换成(B20,B20)
                    var cellrange = formulaStr.match(reg);
                    var cellrange_new = new Array();
                    for (var i = 0; i < cellrange.length; i++) {
                        formulaStr_offset = formulaStr_offset.replace(cellrange[i], "placeholder_" + i);
                        var cellletter = cellrange[i].replace(symbol, "");
                        var cellletter_offset = symbol + getCellletter_offset(rc, opreation, activenum, movenum, cellletter);
                        cellrange_new.push(cellletter_offset);
                    }
                    for (var i = 0; i < cellrange_new.length; i++) {
                        formulaStr_offset = formulaStr_offset.replace("placeholder_" + i, cellrange_new[i]);
                    }
                }
            }
            _formulaObj_new.setOneFormula(__key_offset, formulaStr_offset);
        }
        jQuery.extend(true, _formulaObj.getFormulas(), _formulaObj_new.getFormulas());
    }

    //插入/删除行列，需对公式位移
    function formulaOffset_changeRCNew(rc, opreation, activenum, movenum, formulaStr) {
        var symbol = globalData.getCacheValue("symbol")+"!";
        var reg = eval("/"+symbol+"[A-Z]+\\d+/g");
        var formulaStr_offset = formulaStr;
        if (formulaStr.match(reg)) {	//公式串需位移
            //需使用占位符两次替换，避免(B18,B19)增加行时被替换成(B20,B20)
            var cellrange = formulaStr.match(reg);
            var cellrange_new = new Array();
            for (var i = 0; i < cellrange.length; i++) {
                formulaStr_offset = formulaStr_offset.replace(cellrange[i], "placeholder_" + i);
                var cellletter = cellrange[i].replace(symbol, "");
                var cellletter_offset = symbol + getCellletter_offset(rc, opreation, activenum, movenum, cellletter);
                cellrange_new.push(cellletter_offset);
            }
            for (var i = 0; i < cellrange_new.length; i++) {
                formulaStr_offset = formulaStr_offset.replace("placeholder_" + i, cellrange_new[i]);
            }
        }
        return formulaStr_offset;
    }

    //公式串位移计算
    function getCellletter_offset(rc, opreation, activenum, movenum, cellletter){
        var row = parseInt(cellletter.match(/\d+$/)[0]);
        var col = cellletter.match(/^[a-zA-Z]+/)[0];
        col = morecharToInt(col);
        if(rc == "row" && row > activenum){
            if(opreation == "insert"){
                row = row+movenum;
            }else if(opreation == "delete"){
                row = row-movenum;
            }
        }else if(rc == "col" && col > activenum){
            if(opreation == "insert"){
                col = col+movenum;
            }else if(opreation == "delete"){
                col = col-movenum;
            }
        }
        col = moreIntToChar(parseInt(col)-1);
        return col+row;
    }

    //删除单元格需删除公式
    function deleteCellFormula(cellid, symbol){
        if(typeof symbol === "undefined" || !symbol)
            symbol = globalData.getCacheValue("symbol");
        var r = parseInt(cellid.split(",")[0]);
        var c = parseInt(cellid.split(",")[1]);
        var sheet = getCurrentSheet();
        var cellletter = getColHeader(sheet, c)+(r+1);
        var __key = symbol.toUpperCase()+".FORMULA"+cellletter;
        var _formulaObj = isDetail==="on" ? parentWin_Main.formulaObj : formulaObj;
        _formulaObj.delOneFormula(__key);
        var dataObj = globalData.getCacheValue(symbol);
        if(dataObj.ecs[cellid] && dataObj.ecs[cellid].formula)
            delete dataObj.ecs[cellid].formula;
    }

    //公式选择时绑定表格事件
    function bindSpreadEvent4Formula(spread){
        var sheet = spread.getActiveSheet();
        sheet.bind($.wijmo.wijspread.Events.SelectionChanged,function(event,data){
            var sels = sheet.getSelections();
            var restr = "";
            if(sels && sels.length > 1){
                for(var i=0;i<sels.length;i++){
                    var rc = sels[i].rowCount;
                    var cc = sels[i].colCount;
                    if(rc > 1 || cc > 1){
                        var ar = sels[i].row;
                        var ac = sels[i].col;
                        if(ac < 1) ac = 0;
                        if(ar < 1) ar = 0;
                        if(!!restr){
                            restr += ","+getColHeader(sheet, ac)+(ar+1);
                            restr += ":"+getColHeader(sheet, ac+cc-1)+(ar+rc);
                        }else{
                            restr = getColHeader(sheet, ac)+(ar+1);
                            restr += ":"+getColHeader(sheet, ac+cc-1)+(ar+rc);
                        }
                    }else{
                        var ar = sels[i].row;
                        var ac = sels[i].col;
                        if(!!restr)
                            restr += ","+getColHeader(sheet, ac)+(ar+1);
                        else
                            restr = getColHeader(sheet, ac)+(ar+1);
                    }
                }
            }else if(sels && sels.length == 1){
                var rc = sels[0].rowCount;
                var cc = sels[0].colCount;
                if(rc > 1 || cc > 1){
                    ac = sels[0].col;
                    ar = sels[0].row;
                    if(ac < 1) ac = 0;
                    if(ar < 1) ar = 0;
                    restr = getColHeader(sheet, ac)+(ar+1);
                    restr += ":"+getColHeader(sheet, ac+cc-1)+(ar+rc)
                }else{
                    var ar = sels[0].row;
                    var ac = sels[0].col;
                    restr = getColHeader(sheet, ac)+(ar+1);
                }
            }
            $(window.top.formula_dialog.innerDoc).find("#selectcellTxt").val(restr);
        });
    }

    //公式选择时绑定表格事件
    function bindSpreadEvent4FormulaNew(spread, isDialog){
        var sheet = spread.getActiveSheet();
        sheet.bind($.wijmo.wijspread.Events.CellClick,function(event,data){
            var sels = sheet.getSelections();
            var restr = "";
            if(sels && sels.length == 1){
                var ar = sels[0].row;
                var ac = sels[0].col;
                if (ar >= 0 && ac >= 0) {
                    restr = getColHeader(sheet, ac) + (ar + 1);
                }
            }

            if (!!restr && restr.length > 0) {
                var symbol = currentSymbol4NewFormula;
                var ecObj = getFieldId(symbol, sheet, restr);
                var currSheetName = getCurrentSheetName();
                //含标签页，用于非字段单元格
                var positionSheetName =  currSheetName;
                if (currentSymbol4NewFormula.indexOf("tab_") > -1) {
                    var tablist = tabOperate.getTabListFace();
                    positionSheetName = "标签页-" + tablist[currentSymbol4NewFormula];
                }

                if (!!ecObj) {
                    var fieldid = ecObj.fieldid;
                    var etype = ecObj.etype;
                    if (fieldid && fieldid != -4) {//-4为签字意见，签字意见不允许设置公式
                        var fieldName = getFieldName(fieldid);
                        if (parseInt(fieldid) < 0) {
                            var systemname = SystemEnv.getHtmlNoteName("6086",languageId);
                            if (!systemname) {
                                if (languageId == 8) {
                                    systemname = "system";
                                } else if (languageId == 9){
                                    systemname = "系統";
                                } else {
                                    systemname = "系统";
                                }
                            }
                            restr = "[" + systemname + "." + fieldName + "]";
                        } else {
                            restr = "[" + currSheetName + "." + fieldName + "]";
                            // restr = "[" + getCurrentSheetName() + "." + fieldName + "(" + restr + ")]";
                        }
                    } else if (etype == "1" || etype == "" || typeof etype == "undefined"){
                        restr = "[" + positionSheetName + "!" + restr + "]";
                    } else {
                        restr = "";
                    }
                } else {
                    restr = "[" + positionSheetName + "!" + restr + "]";
                }

                if (!!restr && restr.length > 0) {
                    var formulaContent;
                    if (isDialog) {
                        formulaContent = $(".wea-formular-area-selectcell #formulaContent", window.parent.document).get(0);
                    } else {
                        var formulaDialogDiv = getFormulaDialogDiv();
                        if (formulaDialogDiv) {
                            formulaContent = formulaDialogDiv.contentWindow.document.getElementById("formulaContent");
                        }
                    }
                    if (formulaContent) {
                        var oldContent = formulaContent.value;
                        var currentIndex = formulaContent.selectionStart;//光标位置
                        var newContent = oldContent.substring(0, currentIndex) + restr + oldContent.substring(currentIndex)
                        if (restr) {
                            currentIndex = currentIndex + restr.length;
                        }

                        if (isDialog) {
                            window.parent.document.getElementById("_DialogFrame_excelDesignFormulaListDialog").contentWindow.doBSWorkflowAction.setFormulaNewValue(newContent, currentIndex);
                        } else {
                            formulaDialogDiv.contentWindow.doBSWorkflowAction.setFormulaNewValue(newContent, currentIndex);
                        }
                        formulaContent.setSelectionRange(currentIndex, currentIndex);
                        formulaContent.focus();
                    }
                }
            }
        });
    }

    var currentSymbol4NewFormula = "";
    function setCurrentSymbol(symbol) {
        currentSymbol4NewFormula = symbol;
    }

    function getCurrentSheetName() {
        var ret = "";
        if(currentSymbol4NewFormula === "main" || currentSymbol4NewFormula.indexOf("tab_") > -1){
            ret = SystemEnv.getHtmlNoteName("6027",languageId);//主表
        } else if (currentSymbol4NewFormula.indexOf("detail_") > -1) {
            ret = SystemEnv.getHtmlNoteName("6026",languageId) + currentSymbol4NewFormula.substring(currentSymbol4NewFormula.indexOf("detail_") + 7);//明细表1
        }
        return ret;
    }

    //cellletter:B7
    function getFieldId(symbol, sheet, cellletter) {
        //将B8转换为1,7
        var cellIndex = getCellIndexByLetter(sheet, cellletter);

        var _dobj = getDataObjBySymbolNew(symbol);
        if(_dobj.ecs && _dobj.ecs[cellIndex]){
            var ecObj = {};
            ecObj.etype = transformerEtype(_dobj.ecs[cellIndex].etype);
            if (_dobj.ecs[cellIndex].etype === celltype.FCONTENT) {
                ecObj.fieldid = _dobj.ecs[cellIndex].efieldid;
            }
            return ecObj;
        } else if (_dobj && _dobj.length > 0) {
            _dobj = "{" + _dobj + "}";
            var dobjJson = JSON.parse(_dobj);
            if (dobjJson[symbol] && dobjJson[symbol].ec) {
                for(var cell in dobjJson[symbol].ec){	//转成字符串加入globalData缓存
                    if (dobjJson[symbol].ec[cell].id === cellIndex) {
                        var ecObj = {};
                        ecObj.etype = dobjJson[symbol].ec[cell].etype;
                        if (dobjJson[symbol].ec[cell].etype === "3") {
                            ecObj.fieldid = dobjJson[symbol].ec[cell].field;
                        }
                        return ecObj;
                    }
                }
            }
        }
    }

    function getFormulaDialogDiv() {
        return window.parent.document.getElementById("_DialogFrame_excelDesignFormulaDialog");
    }

    //分析单元格区域
    function analyzeCellRange(cellrang) {
        var startcell = cellrang.split(":")[0];
        var endcell = cellrang.split(":")[1];
        var start_col = startcell.match(/^[a-zA-Z]+/)[0];
        start_col = morecharToInt(start_col)-1;
        var start_row = parseInt(startcell.substring(startcell.match(/^[a-zA-Z]+/)[0].length,startcell.length))-1;
        var end_col = endcell.match(/^[a-zA-Z]+/)[0];
        end_col = morecharToInt(end_col)-1;
        var end_row = parseInt(endcell.substring(endcell.match(/^[a-zA-Z]+/)[0].length,endcell.length))-1;
        var s_cell = 0;
        var e_cell = 0;
        if(parseInt(start_row) + parseInt(start_col) < parseInt(end_row) + parseInt(end_col)){
            s_cell = start_row + "," + start_col;
            e_cell = end_row + "," + end_col;
        }else{
            s_cell = end_row + "," + end_col;
            e_cell = start_row + "," + start_col;
        }
        return s_cell+";"+e_cell;
    }

    //增加、删除单元格(fx)标示
    function controlFormulaSign(sheet, r, c, operflag){
        var celltext = sheet.getCell(r, c, $.wijmo.wijspread.SheetArea.viewport).value();
        if(operflag === "add"){
            if(!!celltext){
                if(celltext.length>=5 && celltext.substring(celltext.length-5)==" (fx)"){
                }else{
                    celltext = celltext+" (fx)";
                }
            }else{
                celltext = " (fx)";
            }
        }else if(operflag === "remove"){
            if(!!celltext && celltext.length>=5 && celltext.substring(celltext.length-5)==" (fx)")
                celltext = celltext.substring(0, celltext.length-5);
        }
        sheet.getCell(r, c, $.wijmo.wijspread.SheetArea.viewport).value(celltext);
    }

    //判断单元格是否包含公式
    function judgeCellContainFormula(symbol, cellid){
        if(typeof symbol === "undefined" || !symbol)
            symbol = globalData.getCacheValue("symbol");
        var r = parseInt(cellid.split(",")[0]);
        var c = parseInt(cellid.split(",")[1]);
        var cellletter = moreIntToChar(c)+(r+1);
        var __key = symbol.toUpperCase()+".FORMULA"+cellletter;
        var _formulaObj = isDetail==="on" ? parentWin_Main.formulaObj : formulaObj;
        var keys = containsFormulaKeys(r,c, symbol);
        return __key in _formulaObj.getFormulas() || keys.length > 0;
    }

    //字母转数字
    function morecharToInt(value){
        var rtn = 0;
        var powIndex = 0;
        for (var i = value.length - 1; i >= 0; i--){
            var tmpInt = value[i].charCodeAt();
            tmpInt -= 64;
            rtn += Math.pow(26, powIndex) * tmpInt;
            powIndex++;
        }
        return rtn;
    }

    //数字转字母(最多支持到两位ZZ)
    function moreIntToChar(value){
        var colname = "";
        var first = Math.floor(value/26);
        var second = value%26;
        if(first > 0)
            colname += String.fromCharCode(64 + first);
        colname += String.fromCharCode(65 + second);
        return colname;
    }

    //获取列头
    function getColHeader(sheet, col){
        var colheader = sheet.getValue(0, col, $.wijmo.wijspread.SheetArea.colHeader);
        if(colheader.indexOf("%") > -1){
            if(colheader.indexOf(" (") > -1)
                return colheader.substring(0, colheader.indexOf(" ("));
        }else{
            return colheader;
        }
    }

    //公式字符串替换
    function replaceFormula(formulatxt){
        formulatxt = formulatxt.replace(/main./ig, "MAIN.");
        formulatxt = formulatxt.replace(/(tab_)(\d+)\./ig, "TAB_$2.");
        formulatxt = formulatxt.replace(/(detail_)(\d+)\./ig, "DETAIL_$2.");
        formulatxt = formulatxt.replace(/SUM(\s)*\(/ig, "EXCEL_SUM(");
        formulatxt = formulatxt.replace(/AVERAGE(\s)*\(/ig, "EXCEL_AVERAGE(");
        formulatxt = formulatxt.replace(/ABS(\s)*\(/ig, "EXCEL_ABS(");
        formulatxt = formulatxt.replace(/ROUND(\s)*\(/ig, "EXCEL_ROUND(");
        formulatxt = formulatxt.replace(/MAX(\s)*\(/ig, "EXCEL_MAX(");
        formulatxt = formulatxt.replace(/MIN(\s)*\(/ig, "EXCEL_MIN(");
        formulatxt = formulatxt.replace(/IF(\s)*\(/ig, "EXCEL_IF(");
        return formulatxt;
    }

    return {
        //模板打开恢复公式
        resumeFormulasFace: function(formulaStr){
            resumeFormulas(formulaStr);
        },
        //模板保存拼接公式
        saveFormulasFace: function(){
            return saveFormulas();
        },
        //插入公式
        openFormulaWinFace: function(){
            openFormulaWin();
        },
        //插入公式
        openFormulaNewWinFace: function(){
            openFormulaNewWin();
        },
        //公式验证
        checkFormulaFace: function (formulaStr) {
            checkFormula(formulaStr);
        },
        //插入/删除行列，公司需相应位移
        formulaOffset_changeRCFace: function(rc, opreation, activenum, movenum){
            formulaOffset_changeRC(rc, opreation, activenum, movenum);
        },
        //删除单元格需删除公式
        deleteCellFormulaFace: function(cellid, symbol){
            deleteCellFormula(cellid, symbol);
        },
        //公式选择时绑定表格事件
        bindSpreadEvent4FormulaFace: function(spread){
            bindSpreadEvent4Formula(spread);
        },
        //新版公式选择时绑定表格事件
        bindSpreadEvent4FormulaNewFace: function(spread, isDialog){
            bindSpreadEvent4FormulaNew(spread, isDialog);
        },
        //分析单元格区域
        analyzeCellRangeFace: function(cellrang){
            return analyzeCellRange(cellrang);
        },
        //判断单元格是否包含公式
        judgeCellContainFormulaFace: function(symbol, cellid){
            return judgeCellContainFormula(symbol, cellid);
        },
        //数字转字母
        moreIntToCharFace: function(value){
            return moreIntToChar(value);
        },
        // getGlobalDataFace : function() {
        // 	return getGlobalData();
        // }
        calculateDestfieldFace: function(value) {
            return calculateDestfield(value)
        },
        addFormulaAndSignFace: function(key, formulaStr) {
            return addFormulaAndSign(key, formulaStr);
        },
        deleteFormulaAndSignFace: function(key){
            return deleteFormulaAndSign(key);
        },
        getCellIndexByLetterFace: function(sheet, cellletter) {
            return getCellIndexByLetter(sheet, cellletter);
        },
        controlFormulaSignFace : function(sheet, r, c, operflag) {
            return controlFormulaSign(sheet, r, c, operflag);
        },
        containsFormulaKeysFace : function(row, col, symbol) {
            return containsFormulaKeys(row, col, symbol);
        },
        getLeftValueFace : function(formulastr){
            return getLeftValue(formulastr);
        },
        getRightValueFace : function(formulastr) {
            return getRightValue(formulastr);
        },
        generateFormulaKeyFace : function() {
            return generateFormulaKey();
        },
        sortFormulaListKeysFace : function(formulas) {
            return sortFormulaListKeys(formulas);
        },
        filterKeysFace : function(formulas, listKeys) {
            return filterKeys(formulas, listKeys);
        },
        setCurrentSymbolFace : function (symbol) {
            return setCurrentSymbol(symbol);
        }
    }

})();