Issue 111319 - pasting cell name reference produces #name error
Summary: pasting cell name reference produces #name error
Alias: None
Product: Calc
Classification: Application
Component: programming (show other issues)
Version: OOo 3.2
Hardware: PC Linux, all
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Keywords: oooqa
Depends on:
Reported: 2010-05-02 12:52 UTC by gorgonz
Modified: 2013-06-13 16:26 UTC (History)
3 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: 4.0.0
Developer Difficulty: ---


Note You need to log in before you can comment on or make changes to this issue.
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

- 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.