插入函数按钮添加自定义公式

function FactorialFunction() {
  this.name = "FACTORIAL";
  this.maxArgs = 1;
  this.minArgs = 1;
  this.description = function () {
    return {
      description: "菲波那切数列",
      parameters: [
        {
          name: "number01",
          repeatable: false,
          optional: false,
        },
      ],
    };
  };
}
FactorialFunction.prototype = new GC.Spread.CalcEngine.Functions.Function();
FactorialFunction.prototype.evaluate = function (arg) {
  var result = 1;
  if (arguments.length === 1 && !isNaN(parseInt(arg))) {
    for (var i = 1; i <= arg; i++) {
      result = i * result;
    }
    return result;
  }
  return "#VALUE!";
};

var factorial = new FactorialFunction();
GC.Spread.CalcEngine.Functions.defineGlobalCustomFunction(
  "FACTORIAL",
  new FactorialFunction()
);
spread.addCustomFunction(factorial);

function customFontFamilyInFormatDialogTemplate(templateNode) {
  if (
    templateNode.bindingPath &&
    templateNode.bindingPath === "functionDesc.allFunction" &&
    templateNode.items
  ) {
    templateNode.items.unshift({ text: "FACTORIAL", value: "FACTORIAL" });

    return;
  }
  let nodes = templateNode.content || templateNode.children;
  if (nodes && nodes instanceof Array) {
    nodes.forEach((subNode) => customFontFamilyInFormatDialogTemplate(subNode));
  }
}

GC.Spread.Sheets.Designer.registerTemplate(GC.Spread.Sheets.Designer.TemplateNames.InsertFunctionDialogTemplate, template);