poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Mark Beardsley <markbrd...@tiscali.co.uk>
Subject Re: Error -60 when evaluating match of columns with SUMPRODUCT function.
Date Sun, 25 Mar 2012 07:32:18 GMT
Well, POI may be correct. When you call the evaluateFormulaCell() method the
cell type returned will be the type of the result of calculating the
formula. So, if the formula produces a numeric result, it will return
Cell.CELL_TYPE_NUMERIC or 0. POI is here saying that evaluating this formula
produces an error, have you opened the file with Excel to double check if
this is correct?

View this message in context: http://apache-poi.1045710.n5.nabble.com/Error-60-when-evaluating-match-of-columns-with-SUMPRODUCT-function-tp5592758p5592901.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

View raw message