Custom function not working properly in Excel online

[nadeemAshfaq]

I have an Excel custom function that gets the whole column as a parameter that is working fine on the desktop but in Excel online 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?

you can get all the details from here OfficeDev/Office-Addin-Scripts#866

[shanshanzheng-dev]

Hi @nadeemAshfaq Thanks for reporting this issue, could you share us your code about this custom function? We're trying to repro your issue.

[nadeemAshfaq]

Hi @shanshanzheng-dev this is how my JSDoc written

and when I run npm build this is how my JSON file looks like

It works fine on the desktop and gets (A:A) as a parameter but when I try the same thing in Excel online it returns "#CALC!"

[shanshanzheng-dev]

Hi @nadeemAshfaq could you please share your custom function?

[nadeemAshfaq]

Do you want me to share the whole code with you?

[shanshanzheng-dev]

Yes, if possible. Because we try to repro your issue and that helps us investigate root cause. Meanwhile, could you share your repro steps? Thanks.

[nadeemAshfaq]

Yes, if possible. Because we try to repro your issue and that helps us investigate root cause. Meanwhile, could you share your repro steps? Thanks.

Sorry I cannot share my full code here I think I already provided the necessary information

[shanshanzheng-dev]

OK, Thanks. We'll be looking into this issue. We'll report back if we have an suggestion for you.

[nadeemAshfaq]

any update?

[XuanZhouMSFT]

@nadeemAshfaq Thanks for the waiting and reporting this issue. It has been put on our backlog #9120326. We will update once we have some progress.

[XuanZhouMSFT]

@nadeemAshfaq Currently, the custom function has a limitation in online that the max cells number for input parameter should be less or equal to 10000. So we'd like to suggest you split your inputs when you use it.

[nadeemAshfaq]

@nadeemAshfaq Currently, the custom function has a limitation online that the max cell number for the input parameter should be less or equal to 10000. So we suggest you split your inputs when you use it.

Okay, thanks for this information. Is there any chance in the future that it takes (A: A)?

[XuanZhouMSFT]

Thanks for the good questions. The item to expand the limitation is in our backlog but no plan to fix it in the short term. We recommend you to upvote or submit a new Tech Community New Ideas item, this will give us visibility of the commonality of it and will help with our prioritization. If we end up working on this issue, we will re-activate as needed.