> > >Not really ;-) See your point. But what would be really >helpful is a hook where a calculator could be installed >(for example a setCalculator() on the workbook). A >recalc() method on the workbook could walk the cells >(don't know excactly the strategy of excel), manage >a calculation stack, call the calculator and assign the >calculated values to the cells. > >-werner. > > I plan on writing a formula evaluator at some point. It depends on some of the commercial work on when I do this. 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:[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]>
