Public bug reported:
Binary package hint: openoffice.org
=ADDRESS(56,3,1,"11")
Returns : "$C$56"
I do not get the ref to the sheet "11" ??
I have 12 sheets named 1 through to 12 ....
This use to work in OO 2.4 and the same spreadsheet now have this problem.
I have a workaround and manually lookup the Sheet name and ad the text with a
"." between this and the address function call.
** Affects: openoffice.org (Ubuntu)
Importance: Undecided
Status: New
--
Open Office Calc 3.1 =ADDRESS() function not return worksheet name
https://bugs.launchpad.net/bugs/321857
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
--
ubuntu-bugs mailing list
[email protected]
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
