Is this function, the FinanceLib.npv() method, the one used internally by POI when a cell in a spreadsheet specifies the NPV function?
Thanks, Jon ----- Original Message ---- From: Edward Ivanovic <edward...@gmail.com> To: POI Users List <user@poi.apache.org> Sent: Mon, December 6, 2010 4:24:58 PM Subject: Re: Using FinanceLib That's great. Thanks Yegor! On Mon, Dec 6, 2010 at 11:24 AM, Yegor Kozlov <ye...@dinom.ru> wrote: > OK, I got the request. The visibility of the FinanceLib class will be > raised from default to public. > > Thanks for raising this topic. > > Regards, > Yegor > > > That's a shame. Why hide a perfectly good Java financial library? >> >> On Mon, Dec 6, 2010 at 3:03 AM, Yegor Kozlov<ye...@dinom.ru> wrote: >> >> On 12/5/2010 8:42 PM, Edward Ivanovic wrote: >>> >>> That's interesting - it no longer comes up in the classes list on >>>> http://poi.apache.org/apidocs/index.html >>>> I wonder if the direct page link that you can find via a Google search >>>> is >>>> an >>>> orphaned page. >>>> >>>> >>>> I updated the online apidocs to reflect current POI trunk. >>> >>> Looking in the svn code repository, the FinanceLib class is no longer >>> >>>> defined as public: >>>> final class FinanceLib {... >>>> >>>> >>>> >>>>http://svn.apache.org/repos/asf/poi/trunk/src/java/org/apache/poi/ss/formula/functions/FinanceLib.java >>>>a >>>> >>>> I think this is why I can't access any methods out of it even though the >>>> methods themselves are declared as public. >>>> >>>> >>>> It was done intentionally. FinanceLib is intended for POI internal use >>> only. This class can be renamed / re-packaged in future versions of POI >>> or >>> access >>> to its methods can be changed from 'public' to 'default' or less. >>> >>> >>> Yegor >>> >>> As you can see, the javadoc you send me shows the previous FinanceLib >>> >>>> declared as a public class. Can it be reverted to public again? >>>> >>>> Thanks >>>> >>>> On Sun, Dec 5, 2010 at 5:01 AM, Nick Burch<nick.bu...@alfresco.com> >>>> wrote: >>>> >>>> Hi, I'd like to use the pv() function that used to be a static method >>>> in >>>> >>>>> the >>>>>> FinanceLib class. I just upgraded to POI 3.7 and it's no longer >>>>>> available >>>>>> (seems the entire FinanceLib class is no longer public). >>>>>> >>>>>> The methods on FinanceLib are all public static, so you ought to be >>>>>> >>>>> fine: >>>>> >>>>> >>>>> >>>>>http://poi.apache.org/apidocs/org/apache/poi/hssf/record/formula/functions/FinanceLib.html >>>>>l >>>>> >>>>> Note that in 3.8, the package will change to >>>>> org.apache.poi.ss.formula.functions for this class >>>>> >>>>> Nick >>>>> >>>>> --------------------------------------------------------------------- >>>>> To unsubscribe, e-mail: user-unsubscr...@poi.apache.org >>>>> For additional commands, e-mail: user-h...@poi.apache.org >>>>> >>>>> >>>>> >>>>> --------------------------------------------------------------------- >>> To unsubscribe, e-mail: user-unsubscr...@poi.apache.org >>> For additional commands, e-mail: user-h...@poi.apache.org >>> >>> >>> > > --------------------------------------------------------------------- > To unsubscribe, e-mail: user-unsubscr...@poi.apache.org > For additional commands, e-mail: user-h...@poi.apache.org > > --------------------------------------------------------------------- To unsubscribe, e-mail: user-unsubscr...@poi.apache.org For additional commands, e-mail: user-h...@poi.apache.org