Re: naming question
- From: Jody Goldberg <jody gnome org>
- To: Peter Jay Salzman <p dirac org>
- Cc: Gnumeric mailing list <gnumeric-list gnome org>
- Subject: Re: naming question
- Date: Sun, 14 Apr 2002 14:59:33 -0400
On Sun, Apr 14, 2002 at 11:02:28AM -0700, Peter Jay Salzman wrote:
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
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
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.
] [Thread Prev