Apache OpenOffice (AOO) Bugzilla – Issue 111319
pasting cell name reference produces #name error
Last modified: 2013-06-13 16:26:59 UTC
Correct Version is not selectable: ooo3.2.1, ooo320m21 OS: OpenSUSE 11.1 Expected behaviour: - copying a cell reference with a name should lead to reference against the name reference prior then to the "A1" - Forcing to use the cell name may not end in a #NAME? in the target cell Example: - Add in sheet1, B6: "=SUMME(B3:B5)" - Name it as "MySum" - Enter in sheet2, B7: "=" - Navigate to sheet1, B6 -> actual proposal is "sheet1.b6" -> expected proposal is "sheet1.MySum" - Nevermind, lets force the wanted entry - still in edit mode of b6 formula: delete the reference "b6" ans start to replace it with "MyS" - You get a tooltip, telling intellisense would guess "MySum". - hit enter -> the cell name is accepted and you jump back to sheet2, b7 -> you get the tag #NAME?, the content is: "=sheet2.mysum" Repeat the forcing in sheet2, b7 - edit formula to correct the capitals replacing "my" with "My" -> again the tooltip suggests "MySum" -> the content is unchanged again and produces #NAME? again
I do not think, that it is a bug. Please look at Insert > Names > Define and see what reference the name MySum contains. It is likely $Sheet1.$B$6. So an additional $Sheet1, makes no sense.
Apologies Regina but I think this is a bug. Once a cell name has been defined, it should be operable in other sheets. i.e. B7=Sheet1.MySum should work. Description confirmed in Rev. 1489073 Win 7.