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