Re: naming question

["Andreas J. Guelzow" <aguelzow taliesin ca>]

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)


yes, since you entered a string...


> =hbar (puts a zero in the cell)


this _should_ be the content of A1 or 0 if A1 is empty


> "hbar" (another literal string)


yes


> =power(hbar,2)   (doesn't work either)


what did you get? This should be identical to =power(A1,2)


Which version of gnumeric are you using?


Andreas


--
Prof. Dr. Andreas J. Guelzow
http://www.math.concordia.ab.ca/aguelzow