poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Nick Burch <apa...@gagravarr.org>
Subject Re: Advice on tracking down an error thrown by evaluateAllFormulaCells()
Date Tue, 24 Nov 2015 12:01:48 GMT
On Tue, 24 Nov 2015, Tom Chiverton wrote:
> I am trying to evaluate all the formula's in an Excel file. There are about
> a dozen sheets, with several tens of formula on each, all driven by a few
> input fields on the first sheet.
> This all works fine in Excel 365 itself.
>
> However, when I try and run it via the latest POI,
> evaluateAllFormulaCells() is throwing "Unexpected ptg class
> (org.apache.poi.ss.formula.ptg.ArrayPtg)".
>
> What's the best way to track this down ?

Do the same logic as that method does - loop over the sheets, then the 
rows, then the cells, and evaluate each cell one at a time. Use that to 
identify which cell, and hence which formula is the problem

Nick

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


Mime
View raw message