shared run time add-in parameter problem

[nadeemAshfaq]

I have an Excel custom function that gets the whole column as a parameter that is working fine on the desktop but in webview2 it's not getting the whole column as a parameter I went through the office documentation but did not find any solution can anybody help me with this?

This is me JSON
"parameters": [
{
"description": "The input data.",
"dimensionality": "matrix",
"name": "IBAN",
"type": "string"
}
],

[Adrian-MSFT]

@nadeemAshfaq can you clarify what scenario works properly? The desktop client also has a webview2 control that is used by some add-ins.

What platform and version is/is not working?

[nadeemAshfaq]

@Adrian-MSFT in the browser when I go to https://www.microsoft.com/en-us/microsoft-365/excel

the addin needs to take the whole column as a parameter (A:A)

this is how my JSDoc

[nadeemAshfaq]

any solution @Adrian-MSFT ?

[Adrian-MSFT]

Hi @nadeemAshfaq I'm reaching out to the Excel online team for assistance on this

[MiaofeiWang]

Hi @nadeemAshfaq , did you get the error "#CALC!" for a function taking whole column as input? This seems to be a bug for Excel on the web, and not only for shared runtime. Would you mind to open an issue in https://github.com/OfficeDev/office-js/issues/ where we have official support process? Thank you.

[nadeemAshfaq]

okay @MiaofeiWang