poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Rafael Ribeiro Rezende <rafaelrez...@gmail.com>
Subject Re: Error -60 when evaluating match of columns with SUMPRODUCT function.
Date Sun, 25 Mar 2012 15:45:09 GMT
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 <markbrdsly@tiscali.co.uk>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: user-unsubscribe@poi.apache.org
> For additional commands, e-mail: user-help@poi.apache.org
>
>


-- 
Rafael R Rezende

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message