Issue 111319

Summary:	pasting cell name reference produces #name error
Product:	Calc	Reporter:	gorgonz <gorgonz>
Component:	programming	Assignee:	AOO issues mailing list <issues>
Status:	CONFIRMED ---	QA Contact:
Severity:	Trivial
Priority:	P3	CC:	elish, issues, rb.henschel
Version:	OOo 3.2	Keywords:	oooqa
Target Milestone:	---
Hardware:	PC
OS:	Linux, all
Issue Type:	DEFECT	Latest Confirmation in:	4.0.0
Developer Difficulty:	---

Description gorgonz 2010-05-02 12:52:12 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

Comment 1 Regina Henschel 2010-06-04 14:29:05 UTC

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.

Comment 2 Edwin Sharp 2013-06-13 16:26:59 UTC

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.