DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG 
RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT
<http://issues.apache.org/bugzilla/show_bug.cgi?id=27511>.
ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND 
INSERTED IN THE BUG DATABASE.

http://issues.apache.org/bugzilla/show_bug.cgi?id=27511

[PATCH] New Enhancements and some buggs fixed





------- Additional Comments From [EMAIL PROTECTED]  2004-06-24 02:56 -------
bug in changes to org.apache.poi.hssf.model.FormulaParser.Ident()
line 299-303
causes FormulaParser Exception if function param list contains a trailing ";" 
ie cell.setCellFormula("HYPERLINK(\"http://google.com\",\"Google\";;)");
throws
java.lang.RuntimeException: Cannot Parse, sorry : Integer Expected
        at org.apache.poi.hssf.model.FormulaParser.Abort(FormulaParser.java:118)
        at org.apache.poi.hssf.model.FormulaParser.Expected
(FormulaParser.java:125)
        at org.apache.poi.hssf.model.FormulaParser.GetNum
(FormulaParser.java:240)
        at org.apache.poi.hssf.model.FormulaParser.Factor
(FormulaParser.java:489)
        at org.apache.poi.hssf.model.FormulaParser.Term(FormulaParser.java:558)
        at org.apache.poi.hssf.model.FormulaParser.Expression
(FormulaParser.java:606)
        at org.apache.poi.hssf.model.FormulaParser.Arguments
(FormulaParser.java:463)
        at org.apache.poi.hssf.model.FormulaParser.function
(FormulaParser.java:325)
        at org.apache.poi.hssf.model.FormulaParser.Ident(FormulaParser.java:266)
        at org.apache.poi.hssf.model.FormulaParser.Factor
(FormulaParser.java:484)
        at org.apache.poi.hssf.model.FormulaParser.Term(FormulaParser.java:558)
        at org.apache.poi.hssf.model.FormulaParser.Expression
(FormulaParser.java:606)
        at org.apache.poi.hssf.model.FormulaParser.parse(FormulaParser.java:710)
        at org.apache.poi.hssf.usermodel.HSSFCell.setCellFormula
(HSSFCell.java:678)
        at nos.common.batch.RiemnsReport.getRiemnsXLS(RiemnsReport.java:335)
        at nos.common.batch.RiemnsReport.getReportZip(RiemnsReport.java:445)
        at nos.common.batch.RiemnsReport.main(RiemnsReport.java:494)

this works fine
cell.setCellFormula("HYPERLINK(\"http://google.com\",\"Google\";)");

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to