Folks on the List:
OOo version: 2.1.0-6
OS & version: Linux, 2.6.19-1.2288.2.1_1.fc5
Platform: Intel
I have a Calc spreadsheet with the below as a formula in cell A1
=cell("filename"; A2)
The value returned is (this is the actual path, filename, and sheet name as I
have save it):
'file:///home/vsp/pradeep_srinivas/Work/TRC/Initial.ods'#$Ratios
Here, the "Ratios" refers to the sheet name. If I rename the sheet
(from "Ratios" to, say, "pradeep"), the formula should reflect the changed
sheet name. It does not, and I am not able to get the changes reflected
UNLESS I close and re-open the spreadsheet.
I have tried F9 (recalculate) to force the calculation, but it does not seem
to do anything in **this** specific instance.
Am I missing something (either in the formula, or in the configurations)? Any
help is appreciated !
--
Pradeep Srinivas
Bangalore, India
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
