[Bug 321857] Re: Open Office Calc 3.0.1 =ADDRESS() function does not return worksheet name
Ah, I see the issue, the documentation is incorrect. There are five fields, not just four, which is the problem you are seeing. It should be something like =ADDRESS(1,1,1,1,Sheet2) ** Changed in: openoffice.org (Ubuntu) Importance: Undecided = Low Status: New = Triaged ** Also affects: openoffice Importance: Undecided Status: New ** Summary changed: - Open Office Calc 3.0.1 =ADDRESS() function does not return worksheet name + [upstream] Open Office Calc 3.0.1 =ADDRESS() function does not return worksheet name -- [upstream] Open Office Calc 3.0.1 =ADDRESS() function does 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 ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 321857] Re: Open Office Calc 3.0.1 =ADDRESS() function does not return worksheet name
** Changed in: openoffice.org (Ubuntu) Status: Incomplete = New -- Open Office Calc 3.0.1 =ADDRESS() function does 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 ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 321857] Re: Open Office Calc 3.0.1 =ADDRESS() function does not return worksheet name
an attachment with some buggy results using the function: ADDRESS according to the helpfiles this should work ** Attachment added: lp321857.ods http://launchpadlibrarian.net/22802820/lp321857.ods -- Open Office Calc 3.0.1 =ADDRESS() function does 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 ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 321857] Re: Open Office Calc 3.0.1 =ADDRESS() function does not return worksheet name
Here is my original problem (With complex formula and workaround) on the first tab ** Attachment added: AddressProblemBugSample.ods http://launchpadlibrarian.net/22808122/AddressProblemBugSample.ods -- Open Office Calc 3.0.1 =ADDRESS() function does 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 ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 321857] Re: Open Office Calc 3.0.1 =ADDRESS() function does not return worksheet name
Can you please attach an example document exhibiting this problem? -- Open Office Calc 3.0.1 =ADDRESS() function does 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 ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
