On Mon, 12 Oct 2009, nikhilgonsalves wrote:
For example, there are two ranges - previous (which is a vertical range -- A:A) and test ( which is a horizontal range -- A1:C1). These two intersect at cell A1. The formula is cell C1 is "=A2*previous test". This works fine in Excel but when the same file is read and evaluated in POI, the error we get is below:java.lang.RuntimeException: Unexpected operation ptg class (org.apache.poi.hssf.record.formula.IntersectionPtg) at org.apache.poi.ss.formula.OperationEvaluatorFactory.create(OperationEvaluatorFactory.java:170)
Are you running 3.5 final, or a 3.5 beta? If you're on 3.5 final, can you upload the problem file to a new bug on bugzilla, so we can all take a look and see what's up with it?
Nick --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
