You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@poi.apache.org by mouss4rs <ou...@gmail.com> on 2012/03/22 12:29:44 UTC

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: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org

RE: Error with setCellFormula( )

Posted by mouss4rs <ou...@gmail.com>.
In my office, it is too much warm here in Paris.

I remove it.
Yes, thanks.


--
View this message in context: http://apache-poi.1045710.n5.nabble.com/Error-with-setCellFormula-tp5585565p5589108.html
Sent from the POI - User mailing list archive at Nabble.com.

---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org

RE: Error with setCellFormula( )

Posted by "Rousset, Nicolas (External)" <Ni...@cassidian.com>.
I think it speaks for itself!
The first open parentheses is nether closed...

HTH,

- Nicolas

-----Message d'origine-----
De : mouss4rs [mailto:oukna.mustapha@gmail.com] 
Envoyé : jeudi 22 mars 2012 12:30
À : user@poi.apache.org
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: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org