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

Groups > linux.debian.user > #190754 > unrolled thread

Problem formatting a column to justify (i.e. line wrap)

Back to article view | Back to linux.debian.user

Contents

  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

#190754 — Problem formatting a column to justify (i.e. line wrap)

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 have 2 columns with potentially long lines.
I had no problem selecting a preferred font size.
I created a spreadsheet allowing cells with with long lines to truncate 
when displayed.

I then chose to justify. An inappropriate column with had been set 
initially resulting in row height of 3 lines of text. I manually dragged 
the column separator to an appropriate width resulting in a desired 
height of 2 lines of text.

That row is stuck at a height of 3 lines of text.

How can I force each row height to be *NO* taller than necessary to for 
the currently longest line?

TIA

[toc] | [next] | [standalone]

#190759

On Sun 07 Jan 2018 at 11:34:43 (-0600), 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 have 2 columns with potentially long lines.
> I had no problem selecting a preferred font size.
> I created a spreadsheet allowing cells with with long lines to
> truncate when displayed.
> 
> I then chose to justify. An inappropriate column with had been set
> initially resulting in row height of 3 lines of text. I manually
> dragged the column separator to an appropriate width resulting in a
> desired height of 2 lines of text.
> 
> That row is stuck at a height of 3 lines of text.
> 
> How can I force each row height to be *NO* taller than necessary to
> for the currently longest line?

To correct one row, double-click on the line underneath the row number
in the left hand margin.

To correct all the rows, click on the area just above the row number
for the first row (selects the entire sheet) and then double-click on
any of the lines like the one I described in the previous paragraph.

Cheers,
David.

[toc] | [prev] | [next] | [standalone]

#190763

On 01/07/2018 12:48 PM, David Wright wrote:
> On Sun 07 Jan 2018 at 11:34:43 (-0600), 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 have 2 columns with potentially long lines.
>> I had no problem selecting a preferred font size.
>> I created a spreadsheet allowing cells with with long lines to
>> truncate when displayed.
>>
>> I then chose to justify. An inappropriate column with had been set
>> initially resulting in row height of 3 lines of text. I manually
>> dragged the column separator to an appropriate width resulting in a
>> desired height of 2 lines of text.
>>
>> That row is stuck at a height of 3 lines of text.
>>
>> How can I force each row height to be *NO* taller than necessary to
>> for the currently longest line?
>
> To correct one row, double-click on the line underneath the row number
> in the left hand margin.
>
> To correct all the rows, click on the area just above the row number
> for the first row (selects the entire sheet) and then double-click on
> any of the lines like the one I described in the previous paragraph.
>
> Cheers,
> David.


Thank you.

[toc] | [prev] | [next] | [standalone]

#190806 — Finding material with F1 or in "The Gnumeric Manual"

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.

TIA

[toc] | [prev] | [next] | [standalone]

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

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.

[toc] | [prev] | [next] | [standalone]

#190837 — 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 
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?

[toc] | [prev] | [standalone]

Back to top | Article view | linux.debian.user

csiph-web