seems like you have unmatched quotes somewhere..
-------Original Message-------
> From: Umaa Rebbapragada <[EMAIL PROTECTED]>
> 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: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
-------Original Message-------
