关于自定义函数hasFormula的返回值

收藏

我定义了一个自定义函数，然后我直接在单元格里面输入=setcell("aa","bb")，这个时候，单元格里显示出了函数的结果，但是，在js里我通过hasFormula判断这个单元格，发现结果是false
但如果我在单元格里输入=sum(2,3)，然后通过hasFormula判断，结果是true，
这个问题如何解决，就是自定义函数在单元格中hasFormula函数是false的问题，我想让hasFormula是true。

自定义函数是下面这个:
function SetCellFunction() {
this.name = "SETCELL";
this.maxArgs = 9999999;
this.minArgs = 1;
}
SetCellFunction.prototype = new GC.Spread.CalcEngine.Functions.Function();
SetCellFunction.prototype.evaluate = function (arg) {

var scriptStr = "";

if (arguments.length % 2 != 0) {
if (arguments.length != 1) {
return "#VALUE!";
} else {
return arguments[0];
}

}

var count = arguments.length / 2;
scriptStr = arguments[0] + "{'" + arguments[1] + "'}";

console.log(arguments.length);

for (var i = 1; i < count; i++) {
var columnNameId = i * 2;
var dimensionMemberId = i * 2 + 1;
//console.log(arguments[columnNameId] + "{'" + arguments[dimensionMemberId] + "'}");
scriptStr += "," + arguments[columnNameId] + "{'" + arguments[dimensionMemberId] + "'}";
}

return scriptStr;
};
var setcell = new SetCellFunction();

KevinChen · KevinChen

您好，我这边没能重现您的问题，如图：

image.png241638488.png

代码如下：

$(document).ready(function () {
var spread = new GC.Spread.Sheets.Workbook(document.getElementById('ss'), {
sheetCount: 1
});
initSpread(spread);
});
function SetCellFunction() {
this.name = "SETCELL";
this.maxArgs = 9999999;
this.minArgs = 1;
}
SetCellFunction.prototype = new GC.Spread.CalcEngine.Functions.Function();
SetCellFunction.prototype.evaluate = function (arg) {
var scriptStr = "";
if (arguments.length % 2 != 0) {
if (arguments.length != 1) {
return "#VALUE!";
} else {
return arguments[0];
}
}
var count = arguments.length / 2;
scriptStr = arguments[0] + "{'" + arguments[1] + "'}";
console.log(arguments.length);
for (var i = 1; i < count; i++) {
var columnNameId = i * 2;
var dimensionMemberId = i * 2 + 1;
//console.log(arguments[columnNameId] + "{'" + arguments[dimensionMemberId] + "'}");
scriptStr += "," + arguments[columnNameId] + "{'" + arguments[dimensionMemberId] + "'}";
}
return scriptStr;
};
function initSpread(spread) {
var activeSheet = spread.getSheet(0);
activeSheet.suspendPaint();
var setcell = new SetCellFunction();
activeSheet.addCustomFunction(setcell);
activeSheet.setFormula(1, 1, "=SETCELL('aa','bb')");
activeSheet.resumePaint();
}

复制代码

		自动登录	找回密码
密码			立即注册

[已处理] 关于自定义函数hasFormula的返回值

1 个回复

讲师达人

悬赏达人

元老葡萄

SpreadJS 认证

SpreadJS 高级认证

微信认证勋章