search

OfficeDev / Office-Addin-Scripts

A set of scripts and packages that are consumed in Office add-ins projects.
MIT License
156 stars 99 forks source link

shared run time add-in parameter problem #866

Open nadeemAshfaq opened 3 months ago

nadeemAshfaq commented 3 months ago

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 commented 3 months ago

@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 commented 3 months ago

@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 Screenshot 2024-06-14 234033

nadeemAshfaq commented 3 months ago

any solution @Adrian-MSFT ?

Adrian-MSFT commented 3 months ago

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

MiaofeiWang commented 3 months ago

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 commented 3 months ago

okay @MiaofeiWang