[upstream] Open Office Calc 3.0.1 =ADDRESS() function does not return worksheet name
Bug #321857 reported by
Lorenco Trichardt
This bug affects 1 person
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
OpenOffice |
Confirmed
|
Unknown
|
|||
openoffice.org (Ubuntu) |
Won't Fix
|
Low
|
Unassigned |
Bug Description
Binary package hint: openoffice.org
=ADDRESS(
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.
Changed in openoffice.org: | |
status: | Incomplete → New |
Changed in openoffice: | |
importance: | Undecided → Unknown |
status: | New → Unknown |
Changed in openoffice: | |
status: | Unknown → Confirmed |
Changed in openoffice.org (Ubuntu): | |
status: | Triaged → Won't Fix |
To post a comment you must log in.
Which version of OpenOffice.org are you using? Ubuntu does not have a version 3.1 of OpenOffice.org.