Maybe it's just my limited experience with POI, or maybe I'm just confused, though it appears that HSSFCell already knows the result of its formula upon construction, its already been evaluated.
The formula is stored in excel as: * array of ptgs that make up the formaula contents (note - the text of the formula is not stored, only the parsed form) * if the formula result is a number, the last evaluated answer for it is stored on the FormulaRecord * if the formula result is a string, the last evaluated answer for it is stored in a following StringRecord
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
Nick --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
