You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@poi.apache.org by bu...@apache.org on 2007/05/17 22:20:07 UTC
DO NOT REPLY [Bug 42448] New: - Can't parse SUMPRODUCT(A!C7:A!C67, B8:B68) / B69
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: bob.wilber@cfx.com
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: poi-dev-unsubscribe@jakarta.apache.org
Mailing List: http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta POI Project: http://jakarta.apache.org/poi/