FWIW, address function works fine for me. 1.9.84 Try dropping the sheet argument for the moment. See what happens...
Dave On 12/3/05, Michael C. Toren <[EMAIL PROTECTED]> wrote: > > Hi, > > I have a number of OO Calc formulas which make use of the =ADDRESS > function, however this function in OO 2.0 appears to be broken, or > behaving differently than it did in OO 1.1. For example: > > =ADDRESS(1;1;1; "sheet1") > > In OO Calc 1.1.5, this would correctly return "sheet1.$A$1". However > after upgrading to OO Calc 1.9.129 (which is included in OO "2.0"), the > same formula now returns "Err:502", and in the lower right hand corner of > the window, the detailed error message is "Error: Invalid argument". As > far as I can tell from the documentation, the =ADDRESS function has not > changed. > > Is anyone else experiencing this problem, and is there a known workaround? > > Thanks, > -mct > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > -- My OpenOffice Calc Website http://www.openofficetips.com
