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: [email protected]
For additional commands, e-mail: [email protected]
