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. But if I save-as the files with the .xlsx the process works fine. Is there a different function in the FormulaEvaluator class that should be used for .xls files?
-- View this message in context: http://apache-poi.1045710.n5.nabble.com/getCachedFormulaResultType-Fails-if-cell-is-using-EOMONTH-tp5716313.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]
