Evaluating date formulas using HSSFFormulaEvaluator

[yaniv yassour <ya...@gmail.com>]

How can I evaluate date formulas using HSSFFormulaEvaluator. When I have a
date formula (such as =NOW())in my xls file and I call the evaluation API;
I’m getting back a double number. In addition the type of the cell is Number
so I don’t have a way in my java code to know that I’m dealing with a date.
In the case where the formula is =NOW() I would like to get back the current
date formatted the same way I see it in Excel. Is it doable?



Many Thanks,
Yaniv