Hello list,
This is my first message to the POI developers' list. I had a little problem
with overriding excel functions that I partially managed to solve. The function
MINVERSE is not implemented on the POI side so I found out that I can register
it to FunctionEval as follows:
FunctionEval.registerFunction("MINVERSE", new Minverse());
where Minverse is a class implementing the interface "Function" and defines
functionality for the method:
public ValueEval evaluate(ValueEval[] args, int srcRowIndex, int srcColumnIndex)
there exactly is my question. MINVERSE admits an *area* of cells - not an
array. How is this 2-dimensional input passed to the above method. Can I use
the input argument of type ValueEval[] to access this area that is passed as
input to MINVERSE? And then, how do I output an area back to the Excel
spreadsheet?
Note: I noticed there is an interface called "AreaEval" but I can't figure out
how to use it.
Also I believe it would be good to extend the tutorial at
http://poi.apache.org/spreadsheet/user-defined-functions.html to include
information on how to implement excel functions that are not supported yet. I
would be happy to contribute with an illustrative example.
Best regards,
Pantelis Sopasakis
P.S. I am using POI version 3.8.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
