Excel and OOCalc calculate that formula properly, and give me the correct numeric number, which should be, for instance in this case, 220. When POI calculates, however, I get CELL_TYPE_ERROR with value -60.
On Sun, Mar 25, 2012 at 9:32 AM, Mark Beardsley <[email protected]>wrote: > 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] > > -- Rafael R Rezende
