The indirect, address functions working good for me - also on 2.0 Here is my test sheet...
http://www.openofficetips.com/downloads/indirect.ods I can't see what is wrong with your attached examples - I tried to break OOo but failed. Feel free to email me your prob sheet . Dave On 11/20/05, dave s <[EMAIL PROTECTED]> wrote: > > 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] > > -- My OpenOffice Calc Website http://www.openofficetips.com
