Number of argument

[errorscript]

Function help is not available in Excel when deploying function with more than 9 arguments.

Temporary solution is to use array as function argument, but it is not perfectly what we want.

The java server, send the full description, so I think it is either in Excel or in the addin that the problem occurs.
Is it an excel or an addin limitation ? Can it be override ?

Thanks

[poidasmith]

Actually, in the addin we limit to 20 arguments. So it will be Excel that has the limitation, although I can't find a reference anyway that specifies it.

[errorscript]

So I assume that my temporary solution will be permanent ;)
Thanks a lot.

[antoineconze]

I recently started to use XLLoop to call my java code from Excel. I ran into the 9 arguments limit (exporting a function with more arguments results in the function as well as all the functions that come next not to register).

Looking at the code I believe there is an improper array size line 199 of XLLoop.cpp. The code declares
static LPXLOPER input[20];
whereas the proper size should be 30.

After changing the size to 30 and rebuilding the library I can now use up to 20 arguments.

[poidasmith]

Thanks, for the information.