On Tue, 12 Aug 2014, pielmw wrote:
I am having a issue when reading .xls user files that have a cell that is using the Excel function EOMONTH(). when I try to getCachedFormulaResultType() on the cell it Cell.CELL_TYPE_ERROR.
getCachedFormulaResultType() returns whatever Excel last decided to store in the File. Nothing we can do if Excel decided to write something unhelpful in there, sorry. (Try Microsoft, assuming you have a suitable support contract...)
Is there a different function in the FormulaEvaluator class that should be used for .xls files?
If you evaluate the cell with FormulaEvaluator, then after that getCachedFormulaResultType() should return the right type. Until then, it'll only give you what Excel last decided to write
Nick --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
