Pradeep Srinivas wrote:
>
> On Sunday 11 Mar 2007, Brian Barker wrote (regarding Re: [users]
> Calc::Updating Calculated (text) cell values):
>> At 10:23 11/03/2007 +0530, Pradeep Srinivas wrote:
> <<OP's original mail SNIPPED by the OP>>
>>
>> I see the same behaviour.
>>
>> One workaround is to use Ctrl+Shift+F9 instead, which recalculates
>> *all* cells, not just the current sheet. This appears to work as you'd
>> expect.
>>
> <<SNIPPED>>
> Hooray!!!! It works!!! It has got me out of a sticky situation. Thanks
> Brian,
> appreciate your response a great deal!!!
>
> Now, if someone can tell me how to get Calc to do the recalculation
> automatically......
>
> --
> Pradeep Srinivas
> Bangalore, India
>
>
I believe that would be a first. It is not like changing the contents of a
cell referenced in a formula. It is similar to a formula like =NOW(). The
value displayed in the cell will not change just because your computer clock
ticks over. =TODAY() will not change at the stroke of midnight.
I don't know the technical reason why the display does not change but I
believe you will have to force recalculation each time you change the name
of a sheet.
--
View this message in context:
http://www.nabble.com/Calc%3A%3AUpdating-Calculated-%28text%29-cell-values-tf3383493.html#a9419825
Sent from the openoffice - users mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
