search

poidasmith / xlloop

XLLoop Excel Function (UDF) Server
104 stars 50 forks source link

Number of argument #4

Open errorscript opened 12 years ago

errorscript commented 12 years ago

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 commented 12 years ago

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 commented 12 years ago

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

antoineconze commented 7 years ago

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 commented 7 years ago

Thanks, for the information.