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:[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]>
