Yegor - Thanks so much!
In running POI through the Eclipse debugger I stumbled on the UDF feature. Thanks for the pointer on the testcase because I was at a loss on how exactly to take advantage of that (though I thought that I would just continue to play around in the debugger until I got it). I am sure the test case will make that easier. If after reading the code and the docs I can see how I might be of assistance I will do as you suggested. Outside of the test case, is this feature documented? I don't recall reading about this. Again, thanks so much for the reply!! Sincerely, Jon ----- Original Message ---- From: Yegor Kozlov <[email protected]> To: [email protected] Sent: Sun, October 3, 2010 9:20:39 AM Subject: Re: how to add functions to POI > 1. Is this a recommended approach for this sort of issue? Is there another > approach that works better and requires less customization of the library? > 2. Does POI already have a facility for adding new functions to the library or > overriding existing ones? > The feature you want is called User-Defined Function (UDF) and is supported by POI. A good example how to use UDF can be found in POI test cases: https://svn.apache.org/repos/asf/poi/trunk/src/testcases/org/apache/poi/hssf/record/formula/eval/TestExternalFunction.java This code was contributed a year back in https://issues.apache.org/bugzilla/show_bug.cgi?id=47809 Please read the last comment by Josh Micich to better understand how this API is organized. > > I'll also throw this out there: my team might be able to contribute something >to > POI that formalizes this - the ability to add or override existing functions > provided it doesn't force us to re-design/re-write large portions of POI. As > such we're interested in knowing what would need to be done (assuming this is a > good idea). > Patches are always welcome. If you have an idea how to improve the work with UDF - please share it on poi-dev or submit a patch to Bugzilla. Regards, Yegor --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
