> I plan on writing a formula evaluator at some point. It > depends on some > of the commercial work on when I do this. Great. Could you give at least a place/hook where I could put my implementation in the meantime (see last mail) (BTW: I also need a calculator in Java because I don't want to do native calls).
-werner. There are a number of > challanges involved especially for some of the use cases I intend it > for. (evaluate formulas to be displayed in HTML > representations, etc) > It will most likely make it in as a part of HSSF by default, > but it may > be more of a general purpose tool than necessarily Excel format > specific...I think. > > For the record (about "using OLE 2 Automation") I'll be -1ing > lock and > barrel any calls to native code in POI. Thats totally not what this > project is about. If it won't run on UNIX/Linux....forget it! (I'm > sure this goes without saying but just in case it doesn't) > > -Andy > > > > > > >>-----Original Message----- > >>From: Avik Sengupta [mailto:[EMAIL PROTECTED]] > >>Sent: Montag, 27. Mai 2002 13:33 > >>To: POI Developers List; [EMAIL PROTECTED] > >>Subject: Re: recalc for sheets > >> > >> > >>Werner, > >> > >>Thanks for your patches. > >> > >>Abt recalc .. actually, poi does not have any "calc" > >>functionality as yet. The > >>idea (at least mine :) is that poi is an api for reading and > >>writing Excel/OLE2 > >>files, and not a functional replacement for Excel/Word etc. > >> > >>As per this philosophy, poi at the moment just writes the > >>formulas in a string > >>as per the excel format, but does not actually calculate the > >>result value of > >>the formula. the cell value record is set to 0 (of course, > >>we need to change > >>that for string formulas .. but thats another story). We > >>depend on Excel > >>automatically recalculating the sheet on open. (This happens > >>on office 2000+, > >>there is a record we can set to ensure it happens on 97 as well. ) > >> > >>I dont know if it should be any other way. do we want to have > >>an implementation > >>of MMULT for example in poi? > >> > >>That having been said, if you have a better idea, please, fire away. > >> > >>Regards > >>- > >>Avik > >> > >> > >>Quoting Werner Froidevaux <[EMAIL PROTECTED]>: > >> > >> > >> > >>>Is there a way to recalc() a sheet? I've found some > >>>hints in the FormulaRecord class but I'm not sure > >>>whether this is the right place to look at. > >>> > >>>If there is no recalc() function yet, where is the > >>>right place to add it. > >>> > >>>-werner. > >>> > >>> > >>>-- > >>>To unsubscribe, e-mail: > >>> > >>> > >><mailto:poi-dev-> [EMAIL PROTECTED]> > >> > >> > >>>For > >>> > >>> > >>additional commands, > >>e-mail: > >> > >> > >>><mailto:[EMAIL PROTECTED]> > >>> > >>> > >>> > >>> > >> > >> > > > > > >-- > >To unsubscribe, e-mail: > <mailto:poi-dev-> [EMAIL PROTECTED]> > >For > additional commands, > e-mail: > ><mailto:[EMAIL PROTECTED]> > > > > > > > > > > > > > -- > To unsubscribe, e-mail: > <mailto:poi-dev-> [EMAIL PROTECTED]> > For > additional commands, > e-mail: <mailto:[EMAIL PROTECTED]> > -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>