Nick, Thank you for your reply. We are using beta 3.5. Should we upgrade to final and then try?
Regards, Nikhil Gonsalves Nick Burch wrote: > > 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] > > > -- View this message in context: http://www.nabble.com/Interesting-Error---%22Unexpected-operation-ptg-class-%28org.apache.poi.hssf.record.formula.IntersectionPtg%29%22-tp25858056p25858346.html Sent from the POI - User mailing list archive at Nabble.com. --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
