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]
