Restrictions on Number of Add-in Parameters?
Posted 13 September 2010 - 01:54 AM
I have a add-in function (which extends Func) where I have specified the min and max arguments as 2 and 100.
When I input a formula to call this add-in, I specify more than 29 parameters
eg CUSTOM_ADD_IN(Parm1, Parm2, Parm3, ..., Parm29).
where Parm1 to Parm29 will be references to other cells.
This seems to cause an issue where my formula is replaced and set to cell reference the last parameter (and my add-in function is *NEVER* called).
This is okay if I have 29 parameters or less.
The add-in does *NOT* call setDeterminant().
I am using e.spreadsheet v10 using a workbook within a Java Swing Eclipse application.
Any help appreciated.