On Tue, 18 Oct 2011, ctraversa wrote:
2. Why internal (standard) excel functions cannot be overwritten even if
they are not implemented? Is there any way to do it?
Built in functions are stored in the file and loaded somewhat differently
to UDFs. There's a file that defines the mapping for them:
src/java/org/apache/poi/ss/formula/eval/FunctionEval.java
You'll want to grab the POI source, edit that file, and list your function
class in place of the NotImplemented one for Rate. Then, build POI from
that patched source, and your function should be used
Nick
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
