Hi, I'm experiencing exactly the same pb on POI 3.1, Excel is showing #VALUE! and not OpenOffice ... So I downloaded some more recent build, alpha, betas up to the very last 3.5. With every recent builds I found, I have this execution error : java.lang.ClassNotFoundException: org.apache.poi.hssf.model.FormulaParser$FormulaParseException
on a simple newCell.setCellFormula(newFormula); Console : XLS Row 131 Col : 28 oldFformula="AC129" newFformula="AC129+Janvier.AC131" the worst is that this FormulaParser$FormulaParseException.class is present in the jar. I don't understant anything and tried all solutions. The formula parsing seems good, cause when I change the new formula, I have parsing errors. So the parsing is right, but an exception is raised ?? Thanks in advance. Thy ----- Original Message ----- From: "Nick Burch" <[EMAIL PROTECTED]> To: "POI Users List" <[email protected]> Sent: Monday, July 14, 2008 3:16 PM Subject: Re: Cell Formula not refreshed > 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] > >
