In formula arguments, ifempty cells are passed as argument, its value is 0 in desktop and null in office web about office-js

[shanshanzheng-dev]

Hi @didu9898 Thanks for reporting this issue. But I can't repro your problem, for my side, the behavior is similar in excel web and excel desktop. They all show "null" on console log, and show "0" as result.
Desktop:

Online:

My excel desktop version is :

for web, you can check if your custom function is registered successfully. Thanks.

{
"functions": [
{
"description": "Check param value if empty cell is passed as param.",
"id": "BLANKSNIPPET1.CHECKPARAM",
"name": "BLANKSNIPPET1.CHECKPARAM",
"parameters": [
{
"name": "param",
"type": "any"
}
],
"result": {}
},
{
"description": "Check param value if empty cell is passed as param.",
"id": "BLANKSNIPPET.CHECKPARAM",
"name": "BLANKSNIPPET.CHECKPARAM",
"parameters": [
{
"name": "param",
"type": "any"
}
],
"result": {}
}
],
"allowCustomDataForDataTypeAny": true
}

[didu9898]

I checked and the custom function is registered successfully.

My excel version is this:

I checked with my colleagues, they also are experiencing similar behavior i.e. 0 in desktop and null in web.

[didu9898]

Can you please share screenshot with the cell formulas too?

[shanshanzheng-dev]

Desktop：=SCRIPTLAB.BLANKSNIPPET.CHECKPARAM(A1)
Web：=SCRIPTLAB.BLANKSNIPPET.CHECKPARAM(A1)
Hi @didu9898 seem our excel version is different, I'll check with my colleagues, too. Or I'm not sure if you can update a new version?

[MiaofeiWang]

Hi @didu9898 , thank you for pointing this out. This change is part of a recent improvement we implemented to address feedback from customers who wanted a way to differentiate between empty cells and cells containing the number "0" in custom functions.

This update has been fully deployed to Excel Online and is available in the Win32 version starting from build 17723.20000. This explains the discrepancy you're observing. For users on the Monthly Enterprise Channel, this feature should be available before mid-August.

Please let us know if you have any further concerns or questions. Thank you.

[didu9898]

@MiaofeiWang thank you for informing about the upcoming update.