On Wed, 26 Mar 2008, Mahesh Ganapathy wrote:
However, excel ought to save the last value for a formula along with it.
So, if all you want is that most recent value, and don't care about
re-calculating it again, just grab that.
Where is this stored? How do I "grab" that ? I really don't need to
recalculate the value.
FormulaRecord.getValue() will give it to you if it's a number / date.
If it's a string, then there will be a second record to go along with the
formula, holding your string. Take a look at the code relating to
FormulaRecordAggregate to see how the usermodel handles this
Nick
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
