[users] ADDRESS in Calc

[Eckl Chen]

=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