The formula result value is an Excel error code (like #DIV/0! or #VALUE!). Use getErrorCellValue() here instead.
For the most part, POI does not do implicit type conversions when reading cell values. This means that you need to determine the cell's value type before calling the appropriate getXxxxCellValue() method. In this case if you inspect the return value of "evalA.evaluateFormulaCell(cell)" you should find that it is Cell.CELL_TYPE_ERROR, which directs you to call getErrorCellValue() to get the evaluation result. In spite of some poor grammar, the error message is attempting to communicate that the formula cell has evaluated to an error value, and cannot be treated as a numeric quantity. The word "error" in the message refers to the data type of the formula result, not your error of calling the wrong getXxxxCellValue() method. --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
