poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Avik Sengupta" <avik.sengu...@itellix.com>
Subject Re: parse exception in formula
Date Fri, 18 Jul 2003 23:20:19 GMT
seems like you have unmatched quotes somewhere..



   -------Original Message-------
   > From: Umaa Rebbapragada <Umaa.Rebbapragada@cnet.com>
   > Subject: parse exception in formula
   > Sent: 18 Jul 2003 19:24:09
   >
   >  cell_out.setCellFormula("HYPERLINK("http://home.cnet.com", "foo")");  // throws
an exception
   >  cell_out.setCellFormula("HYPERLINK("bar", "foo")");   // AOK
   >  
   >  Here's stack trace:
   >  
   >  Error: " Expected
   >  Exception in thread "main" java.lang.RuntimeException: Cannot Parse, sorry : " Expected
   >          at org.apache.poi.hssf.model.FormulaParser.Abort(FormulaParser.java:143)
   >          at org.apache.poi.hssf.model.FormulaParser.Expected(FormulaParser.java:150)
   >          at org.apache.poi.hssf.model.FormulaParser.Match(FormulaParser.java:202)
   >          at org.apache.poi.hssf.model.FormulaParser.StringLiteral(FormulaParser.java:371)
   >          at org.apache.poi.hssf.model.FormulaParser.Factor(FormulaParser.java:353)
   >          at org.apache.poi.hssf.model.FormulaParser.Term(FormulaParser.java:395)
   >          at org.apache.poi.hssf.model.FormulaParser.Expression(FormulaParser.java:446)
   >          at org.apache.poi.hssf.model.FormulaParser.Arguments(FormulaParser.java:327)
   >          at org.apache.poi.hssf.model.FormulaParser.function(FormulaParser.java:302)
   >          at org.apache.poi.hssf.model.FormulaParser.Ident(FormulaParser.java:267)
   >          at org.apache.poi.hssf.model.FormulaParser.Factor(FormulaParser.java:351)
   >          at org.apache.poi.hssf.model.FormulaParser.Term(FormulaParser.java:395)
   >          at org.apache.poi.hssf.model.FormulaParser.Expression(FormulaParser.java:446)
   >          at org.apache.poi.hssf.model.FormulaParser.parse(FormulaParser.java:484)
   >          at org.apache.poi.hssf.usermodel.HSSFCell.setCellFormula(HSSFCell.java:714)
   >  
   >  
   >  I'm using this release: jakarta-poi-1.10.0-dev-20030222.jar and developing a Java
application on Solaris.      
   >  
   >  Known bug? Am I doing something wrong?  Perhaps it's cleared up in a later version
?
   >  
   >  Any help is appreciated. Thanks.
   >  
   >  Umaa @ x3254 (Cambridge)
   >  
   >  ---------------------------------------------------------------------
   >  To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
   >  For additional commands, e-mail: poi-user-help@jakarta.apache.org
   -------Original Message-------


Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message