Re: Finding material with F1 or in "The Gnumeric Manual"
- Date: Tue, 9 Jan 2018 04:50:48 -0600
- From: Richard Owlett <rowlett@xxxxxxxxxxx>
- Subject: Re: Finding material with F1 or in "The Gnumeric Manual"
On 01/08/2018 01:21 PM, David Wright wrote:
On Mon 08 Jan 2018 at 10:58:35 (-0600), Richard Owlett wrote:
On 01/07/2018 11:34 AM, Richard Owlett wrote:
I'm new to gnumeric and have not used any spreadsheet since mid 70's.
I'm running Debian 9.1 with MATE desktop and gnumeric 1.12.32 .
I'm having a different problem now. But I see an common element -
not efficiently using available documentation.
I have a large rectangular region. I wish, on a per column basis, to
calculate the average of the values in that column. I found how to
get the average of a range in a particular column. But I don't see
how to simply do the same for a region.
Copy (^C) the cell with the average in it.
Paste (^V) it into the cells alongside this cell,
ie the ones where you want said averages to appear.
I eventually got there by using the R1C1 notation.
That is copying AVERAGE(R1C:R23C) was more intuitively more proper than
As this is about the second thing you learn about spreadsheet
behaviour (after summing and averaging, a column), it sounds
as if you need to find a simple guide to spreadsheet operations.
That may be the solution. From 40 years ago I remember *WHAT*
spreadsheets can do rather than *HOW* to do it.
P.S. any way to force default notation to be R1C1?