Re: Interesting Error - "Unexpected operation ptg class (org.apache.poi.hssf.record.formula.IntersectionPtg)"

[nikhilgonsalves <ni...@gmail.com>]

Thank you Josh and Nick for your inputs.

The Excel sheet that I am using is strewn with the intersection operator.
And this sheet is given to us by the client so cannot expect them to change
the excel file.

The unfortunate part is that I've just started using POI may be about a
month back and getting familiar to it so writing my own operator class may
be a little out of reach immediately. So i will look out for your
annoucement that the intersectionptg is implemented.

thanks so much!

nikhil





Josh Micich wrote:
> 
> IntersectionPtg has not been implemented yet (so the version won't
> make a difference either).
> 
> The solution will involve making a class 'IntersectionEval' (similar
> to RangeEval) and registering it inside OperationEvaluatorFactory.  I
> might be able to get this done by the end of the week, so feel free to
> attempt a patch yourself, if you need a faster turn-around.
> 
> BTW - the evaluation of UnionPtg (UnionEval) is also currently
> unimplemented.  Both these operators are also currently unsupported by
> the formula parser - so creation of new formulas involving these
> operators doesn't work yet either.  There hasn't been a lot of demand
> for these operators.
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
> For additional commands, e-mail: user-help@poi.apache.org
> 
> 
> 

-- 
View this message in context: http://www.nabble.com/Interesting-Error---%22Unexpected-operation-ptg-class-%28org.apache.poi.hssf.record.formula.IntersectionPtg%29%22-tp25858056p25878449.html
Sent from the POI - User mailing list archive at Nabble.com.


---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org