poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Umaa Rebbapragada <Umaa.Rebbaprag...@cnet.com>
Subject parse exception in formula
Date Fri, 18 Jul 2003 14:24:09 GMT
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)

Mime
View raw message