[upstream] Open Office Calc 3.0.1 =ADDRESS() function does not return worksheet name

[Lorenco Trichardt]

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.

[Chris Cheney (ccheney)]

Which version of OpenOffice.org are you using? Ubuntu does not have a version 3.1 of OpenOffice.org.

[Lorenco Trichardt (trichalo)]

I missed a zero :)

3.0.1
OOO300M14(Build 9376)

[Chris Cheney (ccheney)]

Can you please attach an example document exhibiting this problem?

[GercoKees (gercokees)]

an attachment with some buggy results using the function: "ADDRESS"
according to the helpfiles this should work

[Lorenco Trichardt (trichalo)]

Here is my original problem (With complex formula and workaround) on the first tab....

[Chris Cheney (ccheney)]

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")

[Chris Cheney (ccheney)]

GercoKees,

Thanks for getting the bug linked upstream! :-)

Chris

[JFields (jeafields)]

Given the documentation is wrong, what is the purpose of argument 4?

Argument 1 is the row
Argument 2 is the column
Argument 3 is the reference type
Argument 4 is unknown to me atm
Argument 5 is the sheet name

The documentation leaves out Argument 4 and as Argument 5 as Argument 4 with only 4 arguments in the function.

Documentation really needs to be updated in OOC3.0.1 given people like me that is a very advanced computer user to the point of writing my own set of codes within VBA (Excel) and BASIC (OOC) using good programming practices rely on these documentations.

[Björn Michaelsen (bjoern-michaelsen)]

[This is an automated message.]
There are no new official OpenOffice.org releases in Ubuntu packaging anymore => Won't Fix

If the problem persists, please mark this bug as "also affects project Libreoffice" or "also affects distribution Libreoffice (Ubuntu)" if that has not happened already.

Please leave references to upstream OpenOffice.org bugs in place to allow cross pollination.