Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > linux.debian.user > #190837

Re: Finding material with F1 or in "The Gnumeric Manual"

Show all headers | View raw

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 
copying  AVERAGE(A1:A23).

>
> 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.

Thank you.

P.S. any way to force default notation to be R1C1?

Back to linux.debian.user | Previous | Next — Previous in thread | Find similar | Unroll thread

Thread

Problem formatting a column to justify (i.e. line wrap) Richard Owlett <rowlett@cloud85.net> - 2018-01-07 18:40 +0100
  Re: Problem formatting a column to justify (i.e. line wrap) David Wright <deblis@lionunicorn.co.uk> - 2018-01-07 19:50 +0100
    Re: Problem formatting a column to justify (i.e. line wrap) Richard Owlett <rowlett@cloud85.net> - 2018-01-07 21:20 +0100
  Finding material with F1 or in "The Gnumeric Manual" Richard Owlett <rowlett@cloud85.net> - 2018-01-08 18:00 +0100
    Re: Finding material with F1 or in "The Gnumeric Manual" David Wright <deblis@lionunicorn.co.uk> - 2018-01-08 20:30 +0100
      Re: Finding material with F1 or in "The Gnumeric Manual" Richard Owlett <rowlett@cloud85.net> - 2018-01-09 12:00 +0100

csiph-web