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]
