At 10:23 11/03/2007 +0530, Pradeep Srinivas wrote:
I have a Calc spreadsheet with the below as a formula in cell A1
=cell("filename"; A2)
If I rename the sheet [...], the formula should reflect the changed
sheet name. It does not, ...
I have tried F9 (recalculate) to force the calculation, but it does
not seem to do anything in **this** specific instance.
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.
Brian Barker
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
