Re: How to insert names (NEW USER) ++ and USE them!

[Jean Brefort <jean brefort normalesup org>]

Le lundi 26 décembre 2011 à 19:02 -0800, bob_hayden a écrit :
> I don't quite folow that but then I am in Gnumeric 1.8 (because that is what
> is in my distro's repository).  I have been able to assign a name to a range
> but I cannot figure out how to USE the name.  For example, in an application
> I piloted in Excel 2000, I needed to work with a block of 30,000 cells.  It
> gets tiresome highlighting that with a mouse, so in Excel I named if "Fred"
> and can select the whole block by pulling down the Name window and selecting
> Fred.  But in Gnumeric that window just shows single cell addresses.

Type Fred in the selection entry at left of the formula entry.

>   I can
> also do this in Calc where I can, for example, enter a formula like
> "=sum(Fred)" and get something reasonable while Gnumeric just returns 0 no
> matter what is in Fred (and after I press F9).  Are the various things other
> spreadsheets DO with named ranges not implemented in Gnumeric or am I just
> looking in the wrong place?

"=sum(Fred)" works for me. Can you send me a sample file were it does
not work? I didn't test with 1.8 though, much too old here.

Regards,
Jean