Re: naming question

[Jody Goldberg <jody gnome org>]

On Sun, Apr 14, 2002 at 11:02:28AM -0700, Peter Jay Salzman wrote:
> hola,
>
> i'd like to be able to name cells to make formulas easier to read.
>
> suppose cell A1 contains 1.0 and i'd like name this cell "hbar" in
> equations.
>
> 1. click on insert | name | define
> 2. in "name" place "hbar"
> 3. click on "expression" box, then click on cell A1.  this will place
>    Sheet1!A1 in the expression box
>
> how exactly do i use this name now?   i've tried:
>
> hbar (gnumeric interprets this as a literal string)
> =hbar (puts a zero in the cell)
> "hbar" (another literal string)
> =power(hbar,2)   (doesn't work either)
>
> how do i make reference to the cell whose name is "hbar"?

The trick is that A1 is a relative reference.
Use $A$1.  This was both a requested feature, and an Excel
compatibility issue.

You can also quickly define a name by using the naming region in the
top left of the sheet.  Just select the region you want to name, and
enter the name there.