Breezy Open Office ADDRESS problem

dave s kubuntu at pusspaws.net
Sun Nov 20 15:40:24 UTC 2005


Hi all,

OK I got a problem with OpenOffice 2, Breezy Badger

If you open up a brand new sheet, pick a cell on Sheet1 and enter
=ADDRESS(1; 1; 2; "Sheet2")

It should return something like ... Sheet2.A$1

I get Err:502

This is causing me major problems on a works spreadsheet that used to work AOK 
on OpenOffice 1.1. I have contacted the OpenOffice mailing list and they 
confirm that all is well with their OpenOffice2.0, the ADDRESS function works 
as expected.

I am stuck. Can anyone confirm that the above works or does not work in 
Breezy ? 

Cheers
Dave

PS the above example is text book from the OpenOffice help pages for ADDRESS






More information about the kubuntu-users mailing list