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

Groups > linux.debian.user > #190819

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

Show all headers | View raw

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.

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.

Cheers,
David.

Back to linux.debian.user | Previous | Next — Previous in thread | Next 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