Oh, I see. There are some wrong in help and wiki. Argument A1 has chaos. =ADDRESS(1;1;2; ;"Sheet1") will return Sheet1.A$1
2010/8/12 Eckl Chen <[email protected]> > =ADDRESS(1;1;2) return A$1 > > =ADDRESS(1;1;2;"Sheet1") will return Sheet1.A$1, but display #VALUE! > > Both Ubuntu 10.04 + OOo 3.2 and Windows 7 + OOo 3.2.1 have this. > > > Yookee >
