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