网上抄了一个自定义函数撮合着用用
function removeFun() {
this.name = 'removeString';
this.maxArgs = 2;
this.minArgs = 1;
}
removeFun.prototype = new GC.Spread.CalcEngine.Functions.Function();
removeFun.prototype.evaluate = function (str){
var ar2 = str.split(";");
var array = new Array();
var j=0
for(var i=0;i<ar2.length;i++){
if((array == "" || array.toString().match(new RegExp(ar2,"g")) == null)&&ar2!=""){
array[j] =ar2;
array.sort();
j++;
}
}
return array.toString().replace(/,/g, ";");
}
GC.Spread.CalcEngine.Functions.defineGlobalCustomFunction("removeString", new removeFun());// JavaScript source code
|