Michael C. Toren wrote:
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?
Use the version from the OpenOffice.org website. The makers of some Linux distributions chose to alter the parameters of the ADDRESS function, leading to such compatibility problems with existing documents.
Niklas --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
