Werner Froidevaux wrote: >>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). > > Oh no dude, go right ahead if you're game to go on this. My statement was more of a "I support doing this and will contribute to the effort" and a +1. If you've got the will to implement it, go for it and I'll commit the changes and offer what help I can.
-Andy >-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]> > > > > -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
