hi nick, thanks for the advice. i updated the jar file to a build jar file from last night and it worked prefectly.
many thanks mark Nick Burch wrote: > > On Mon, 14 Jul 2008, mjw_85uk wrote: >> When i open the file after it has been populated with the information >> using OpenOffice the totals row has the correct values in it. However, >> when i open the file using MS Excel the value in the cell is #VALUE! and >> not the nurmeric value it should be. I am using POI 3.1 and the code i >> use to recalculate the values is: > > It might be worth trying a recent nightly build [1], there have been a few > formula evaluation fixes since 3.1 final > > Nick > > [1] http://encore.torchbox.com/poi-svn-build/ > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > > -- View this message in context: http://www.nabble.com/Cell-Formula-not-refreshed-tp18443463p18446384.html Sent from the POI - User mailing list archive at Nabble.com. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
