poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Andrew C. Oliver" <acoli...@apache.org>
Subject Re: parse exception in formula
Date Fri, 18 Jul 2003 15:15:05 GMT
Its not a bug, we donĀ¹t support hyperlinks yet.  Its a contribution
opportunity.

-andy


On 7/18/03 10:24 AM, "Umaa Rebbapragada" <Umaa.Rebbapragada@cnet.com> wrote:

> 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
> 

-- 
Andrew C. Oliver
http://www.superlinksoftware.com/poi.jsp
Custom enhancements and Commercial Implementation for Jakarta POI

http://jakarta.apache.org/poi
For Java and Excel, Got POI?


Mime
View raw message