search

poidasmith / xlloop

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

Support for 3d java arrays? #2

Closed beirtipol closed 12 years ago

beirtipol commented 12 years ago

Hi,

I've currently got a function which returns the following:

    return new Object[][] { { "0,0", "1,0" }, { "0,1", "1,1" } };

This works fine. However, if I change one of the values to an array, it shows up as '#VALUE!' in Excel. 

    return new Object[][] { { "0,0", "1,0" },   { "0,1", new String[] { "1", "1" } } };

Is this something that can be supported such that cell[1][1] is an array which I can then expand by referring to it and 'ctrl+shift+enter'ing it?

Cheers, Beirti

poidasmith commented 12 years ago

Actually, XLLoop returns the complete xloper structure. The #VALUE you are seeing is an Excel limitation. I would suggest you look at returning a 'handle' to an object that could be referred to in another cell (or array).

Take a look at http://xlloop.sourceforge.net/lisphandler.html - notice the class name+timestamp - this is an object reference on the server that can be referred to. See org.boris.xlloop.util.ObjectRegistry.