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=42448>. 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=42448 Summary: Can't parse SUMPRODUCT(A!C7:A!C67, B8:B68) / B69 Product: POI Version: 2.5 Platform: PC OS/Version: Windows XP Status: NEW Severity: normal Priority: P2 Component: HSSF AssignedTo: poi-dev@jakarta.apache.org ReportedBy: [EMAIL PROTECTED] HSSFCell.setCellFormula() crashes with the following string: "SUMPRODUCT(A!C7:A!C67, B8:B68) / B69" (I had previously created a worksheet with the name "A", and was creating this formula in a different worksheet.) Excel is perfectly happy with htis formula when I type it in by hand. The relevant part of the stack dump is: at java.lang.String.charAt(String.java:687) at org.apache.poi.hssf.util.CellReference.<init>(CellReference.java:44) at org.apache.poi.hssf.util.AreaReference.<init>(AreaReference.java:33) at org.apache.poi.hssf.record.formula.Area3DPtg.setArea (Area3DPtg.java:243) at org.apache.poi.hssf.record.formula.Area3DPtg.<init> (Area3DPtg.java:58) at org.apache.poi.hssf.model.FormulaParser.Ident(FormulaParser.java:280) at org.apache.poi.hssf.model.FormulaParser.Factor (FormulaParser.java:474) at org.apache.poi.hssf.model.FormulaParser.Term(FormulaParser.java:548) at org.apache.poi.hssf.model.FormulaParser.Expression (FormulaParser.java:596) at org.apache.poi.hssf.model.FormulaParser.Arguments (FormulaParser.java:443) at org.apache.poi.hssf.model.FormulaParser.function (FormulaParser.java:315) at org.apache.poi.hssf.model.FormulaParser.Ident(FormulaParser.java:265) at org.apache.poi.hssf.model.FormulaParser.Factor (FormulaParser.java:474) at org.apache.poi.hssf.model.FormulaParser.Term(FormulaParser.java:548) at org.apache.poi.hssf.model.FormulaParser.Expression (FormulaParser.java:596) at org.apache.poi.hssf.model.FormulaParser.parse(FormulaParser.java:700) at org.apache.poi.hssf.usermodel.HSSFCell.setCellFormula (HSSFCell.java:678) -- Configure bugmail: http://issues.apache.org/bugzilla/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the assignee for the bug, or are watching the assignee. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] Mailing List: http://jakarta.apache.org/site/mail2.html#poi The Apache Jakarta POI Project: http://jakarta.apache.org/poi/
