I think it speaks for itself! The first open parentheses is nether closed...
HTH, - Nicolas -----Message d'origine----- De : mouss4rs [mailto:[email protected]] Envoyé : jeudi 22 mars 2012 12:30 À : [email protected] Objet : Error with setCellFormula( ) Hi, I have this error: Exception in thread "AWT-EventQueue-0" org.apache.poi.ss.formula.FormulaParseException: Parse error near char 32 in specified formula '(((SUM(I3:I20)/SUM(C3:C20))*100)'. Expected ')' I do this: String txtransfo = "(((SUM(I3:I20)/SUM(C3:C20))*100)"; cellx.setCellFormula(txtransfo); -- View this message in context: http://apache-poi.1045710.n5.nabble.com/Error-with-setCellFormula-tp5585565p5585565.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] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
