On Sunday 11 Mar 2007, TerryJ wrote (regarding Re: [users] Calc::Updating
Calculated (text) cell values):
> Pradeep Srinivas wrote:
<<SNIPPED: OP's mail, Brian's response, OP's response>>
> > Now, if someone can tell me how to get Calc to do the recalculation
> > automatically......
> 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.
Terry,
Thanks for the explanation, and yes, it looks logical. I agree that a formula
like NOW() may not, after having been entered into a cell, change values
dynamically (could be potentially disastrous).
On the other hand, let me see if I can apply this logic to my problem, and see
if I get this right :
When I have a cell with "=cell("filename";B1) in cell A1, it returns the
**current** name of the sheet to me. Perfect, logical.
I change the name of the sheet, and **then** enter, into cell A2 (not A1), the
same formula. I expect to get the **current** name of the sheet, right ?
Well, I do not. This is my, ah, grouse (no offense meant).
I certainly agree that there could be issues to dynamically change the value
returned by the function call made at an earlier point in time. What then,
prevents the later invocation of the same function, at a *different*
location, to return the **current** value ?
By the way, and not trying to nit-pick (or split hairs) I wanted to see what
happens with the "NOW" function.
In A1, entered =NOW(). Got a date/time combination.
In A2, after around a minute, entered =NOW(). Got the current date/time,
which is around a minute more than the previous invocation. However a
surprise - the value in A1 *also changed*, to reflect current date time.
Probably an aberration ?
With due apologies for any inaccuracies in the description of the problem, or
in my response to you.
--
Pradeep Srinivas
Bangalore, India
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
