在Spread里面如何自定一个公式函数
需要注意的 typeName, 缺少typeName调用上函数会出现问题
verifyXB: function (aSheet) {
function verifyXBFunctionInfo() {
this.name = "checkXB";
this.maxArgs = 1;
this.minArgs = 0;
this.typeName = "verifyXBFunctionInfo";
}
verifyXBFunctionInfo.prototype = new GC.Spread.CalcEngine.Functions.Function();
//来个校验规则
verifyXBFunctionInfo.prototype.evaluate = function (val) {
if (val == "男" || val == "女")
return val
debugger
return "#VALUE!";
}
var verify = new verifyXBFunctionInfo();
aSheet.addCustomFunction(verify);
}
将该实例进行注册
两种方式:全局注册或者单独sheet注册
单独sheet注册:sheet.addCustomFunction(customFunction);
全局注册:
GC.Spread.CalcEngine.Functions.defineGlobalCustomFunction("CustomFunction", customFunction );