On Wed, 15 Oct 2008, Nick Burch wrote:
I think what you want is already available. If you know a cell is a formula
with a numeric response, just call getCellNumericValue() and you'll get back
the last (excel) evaluated value for it
Hi Nick,
Thanks for the info. Yes the cell's value is available via
fe.evaluate(cell).getCellType(), but this, IMHO, as I said earlier, is
ugly, the cell already knows the formula's state (cached state at least),
so why does another class and another type have to be used?
The cell's type must then be rechecked on this different
class against the same set of conditions that have just been applied the
cell.
To me, it's just a hack to get around the problems/exceptions/bugs/whatever
with HSSFCell.getCachedResultType() and HSSFFormulaEvaluator.evaluateInCell().
I'm repeating my self but my point was that using the formula evaluator
to determine the cells type -as read from the spreadsheet,
should be unnecessary. getCachedFormulaResultType() should suffice.
Thanks,
Skye
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
