Hi all,
A few months ago I wrote a spreadsheet, worked great on an older version of
OpenOffice using indirect operators. Now I have upgraded to 2.0 and my
spreadsheet has broke.
BL8 contains ...
Sheet1_2
So I had tons of equations like the following ...
=INDIRECT(ADDRESS(118;1;1;INDIRECT("BL8")))
Used to returned the call value of 118,1 on Sheet1_2
Now I get #VALUE! everywhere
=ADDRESS(118;1;1;INDIRECT("BL8"))
& I get #VALUE!
=ADDRESS(118;1;1;'Sheet1_2')
& I get R118C1
Where as I would expect something like
=Sheet1_2.A118
which, by the way, returns the correct value
Any ideas anyone, I have spent some hours on this and am stumped :(
Cheers
Dave
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
