Re: gnumeric-list Digest, Vol 165, Issue 7 (SOLVED)



Hi Bill,
the method you gave works for me !
Tons of thanks as I have tried to get it several times since ....years...! each time spending some hours browsing the web and trying several settings combinations. Just ask the mailing list ...and there you are !
So these issue might be considered as SOLVED at least for me.

Hi Pere,
Also many thanks for your reply !
The method you gave, also repeated by Bill, and very clearly explained (thanks therefore), does not work for me. It works for numbers. But for months, the selected cells are just copied/repeated. Even if the column is formated to date (also format/custom/mmmm for exaple).


Best regards

Charlie

copy of the method
---------------------------------------------------------
TO FILL A COLUMN WITH ONLY THE MONTH NAMES...

Remember this will fill the column with TEXT not date information!

The method described by Pere works if you type the month name as a proper abbreviation or a full month name with the first letter capitalized in your locale such as:

[Jan]
[Feb]
--or--
[January]
[February]

Then drag the corner as described.

TO FILL A COLUMN WITH THE MONTHS...

This will fill the column with DATE information. (more useful)

Select the first cell to use then:

Menu: Data > Fill > Series...

Series panel
Series in: Column
Type: Date
Start value: 1/1/2016 (note date)
Step value:
Stop value: 1/1/2018 (note date)

Options panel
Date unit: Month

Output panel
no change

Then OK. The column will be filled with 'General' formatted numbers.

Select the column header
Menu: Format > Cells > Format...
Custom: mmmm (for January)

Bill
--------------------------------------------------------------------


On Tue, 13 Mar 2018 12:00:13 +0000, gnumeric-list-request gnome org wrote:
Send gnumeric-list mailing list submissions to
        gnumeric-list gnome org

To subscribe or unsubscribe via the World Wide Web, visit
        https://mail.gnome.org/mailman/listinfo/gnumeric-list
or, via email, send a message with subject or body 'help' to
        gnumeric-list-request gnome org

You can reach the person managing the list at
        gnumeric-list-owner gnome org

When replying, please edit your Subject line so it is more specific
than "Re: Contents of gnumeric-list digest..."


Today's Topics:

   1. Re: how to fill a range of cells by a date-type serie? (Bee)
   2. Re: Problem with Font height/Row Height (Jean Br?fort)
   3. Re: Problem with Font height/Row Height (Fr?d?ric Parrenin)
   4. Re: how to fill a range of cells by a date-type  serie?
      (barewillysprl)



----------------------------------------------------------------------

Message: 1
Date: Mon, 12 Mar 2018 17:05:02 -0700
From: Bee <beeyawned gmail com>
To: gnumeric-list gnome org
Subject: Re: how to fill a range of cells by a date-type serie?
Message-ID: <20180312170502 0eb894307af65eb9be7719fa gmail com>
Content-Type: text/plain; charset=US-ASCII

TO FILL A COLUMN WITH ONLY THE MONTH NAMES...

Remember this will fill the column with TEXT not date information!

The method described by Pere works if you type the month name as a
proper abbreviation or a full month name with the first letter
capitalized in your locale such as:

[Jan]
[Feb]
--or--
[January]
[February]

Then drag the corner as described.

TO FILL A COLUMN WITH THE MONTHS...

This will fill the column with DATE information. (more useful)

Select the first cell to use then:

Menu: Data > Fill > Series...

Series panel
Series in: Column
Type: Date
Start value: 1/1/2016 (note date)
Step value:
Stop value: 1/1/2018 (note date)

Options panel
Date unit: Month

Output panel
no change

Then OK. The column will be filled with 'General' formatted numbers.

Select the column header
Menu: Format > Cells > Format...
Custom: mmmm (for January)

Bill

From: Pere Pujal i Carabantes <ppujal airtel net>
Subject: Re: how to fill a range of cells by a date-type serie?
Hi, in 1.12.32, catalan locale:

I type gener enter febrer enter
Results in two cells with the two first names of months, select the
two cells. Now put the pointer in the bottom right corner of the
selection, a thin cross should appear, click and drag down and you are
done, the names of the 12 moths will appear in series, works too with
abreviations. No need for control nor alt keys.

I've noticed that this is locale dependent, say when I run gnumeric in
catalan locale it doesn't work if I write the month names in English
and try the autofill. Also, you must type and select at least the
first two cells, otherwise gnumeric will just copy the entered text
around.

HTH
Pere


------------------------------

Message: 2
Date: Tue, 13 Mar 2018 07:05:28 +0100
From: Jean Br?fort <jean brefort normalesup org>
To: Dean McCarron <dm-gnome mercuryresearch com>,
        gnumeric-list gnome org
Subject: Re: Problem with Font height/Row Height
Message-ID: <1520921128 1996 2 camel normalesup org>
Content-Type: text/plain; charset="UTF-8"

You can also change the monitor resolution used by gnumeric using the
Preferences dialog (Windows/Screen path). If this does not work, please
file a bug report.

Hope this helps
Jean

Le lundi 12 mars 2018 ? 15:04 -0700, Dean McCarron a ?crit :
I ran into an identical problem when I migrated to a system using a
high
DPI monitor. If I set the system DPI to the standard 96 everything
was
fine (though oversized on the high DPI screen.)

If this is your issue, it's because gnumeric sets row heights in
pixels
that are not scaled with DPI, and the font engine is correctly
scaling
for high DPI, so you end up with more pixels than the row is high. I
couldn't find any settings to fix this (if there are, please,
someone
tell me.)

It's an ugly workaround, but if you want to leave your DPI settings
alone, you can scale the GDK DPI down to compensate using this on
the
command line. You may need to adjust the scale factor (96/monitor's
DPI):

GDK_DPI_SCALE=0.69 gnumeric [filename]

This will result in everything being scaled down to match the
unadjusted
row pixel spacing. You can then zoom to bring everything back to
normal
size, but all the UI elements will remain scaled down.


On 03/12/2018 01:25 PM, John R. Sowden wrote:
> I am in the process of switching from LO to Gnumeric because of
> the
> very slow operation of LO. The problem I am finding is when I open
> an
> .ODS file created with LO, the row height is not automatically
> adjusted to match the font height.?  There is an "autoformat"
> option,
> but it does not seem to reference row height.?  The lower half of
> the
> text is cut off.
>
> Is there a SS wide option to make the row height work with the
> fond
> used??  I do not use the MS TT fonts, nor do I use MS Excell.
>
>
> Thanks,
>
> John
>
>
> _______________________________________________
> gnumeric-list mailing list
> gnumeric-list gnome org
> https://mail.gnome.org/mailman/listinfo/gnumeric-list

_______________________________________________
gnumeric-list mailing list
gnumeric-list gnome org
https://mail.gnome.org/mailman/listinfo/gnumeric-list


------------------------------

Message: 3
Date: Tue, 13 Mar 2018 09:09:40 +0100
From: Fr?d?ric Parrenin         <frederic parrenin univ-grenoble-alpes fr>
To: Jean Br?fort <jean brefort normalesup org>
Cc: Dean McCarron <dm-gnome mercuryresearch com>,
        gnumeric-list gnome org
Subject: Re: Problem with Font height/Row Height
Message-ID:
        <45a497d6-fa98-f13b-82df-de6720216a2a univ-grenoble-alpes fr>
Content-Type: text/plain; charset=UTF-8; format=flowed

I have a related question.
In gnumeric settings, you can set the default zoom level and the dpi.
What is the difference between those two settings?

All the best,

Fr?d?ric

Le 13/03/2018 ? 07:05, Jean Br?fort a ?crit?:
You can also change the monitor resolution used by gnumeric using the Preferences dialog (Windows/Screen path). If this does not work, please
file a bug report.

Hope this helps
Jean

Le lundi 12 mars 2018 ? 15:04 -0700, Dean McCarron a ?crit :
I ran into an identical problem when I migrated to a system using a
high
DPI monitor. If I set the system DPI to the standard 96 everything
was
fine (though oversized on the high DPI screen.)

If this is your issue, it's because gnumeric sets row heights in
pixels
that are not scaled with DPI, and the font engine is correctly
scaling
for high DPI, so you end up with more pixels than the row is high. I
couldn't find any settings to fix this (if there are, please,
someone
tell me.)

It's an ugly workaround, but if you want to leave your DPI settings
alone, you can scale the GDK DPI down to compensate using this on
the
command line. You may need to adjust the scale factor (96/monitor's
DPI):

GDK_DPI_SCALE=0.69 gnumeric [filename]

This will result in everything being scaled down to match the
unadjusted
row pixel spacing. You can then zoom to bring everything back to
normal
size, but all the UI elements will remain scaled down.


On 03/12/2018 01:25 PM, John R. Sowden wrote:
I am in the process of switching from LO to Gnumeric because of
the
very slow operation of LO. The problem I am finding is when I open
an
.ODS file created with LO, the row height is not automatically
adjusted to match the font height.?  There is an "autoformat"
option,
but it does not seem to reference row height.?  The lower half of
the
text is cut off.

Is there a SS wide option to make the row height work with the
fond
used??  I do not use the MS TT fonts, nor do I use MS Excell.


Thanks,

John


_______________________________________________
gnumeric-list mailing list
gnumeric-list gnome org
https://mail.gnome.org/mailman/listinfo/gnumeric-list
_______________________________________________
gnumeric-list mailing list
gnumeric-list gnome org
https://mail.gnome.org/mailman/listinfo/gnumeric-list
_______________________________________________
gnumeric-list mailing list
gnumeric-list gnome org
https://mail.gnome.org/mailman/listinfo/gnumeric-list



------------------------------

Message: 4
Date: Tue, 13 Mar 2018 09:20:46 +0100
From: barewillysprl <barewillysprl scarlet be>
To: aguelzow <aguelzow pyrshep ca>
Cc: <gnumeric-list gnome org>
Subject: Re: how to fill a range of cells by a date-type  serie?
Message-ID: <5905298e77fd6ac39e78ce19ad24d920 scarlet be>
Content-Type: text/plain; charset=UTF-8; format=flowed

Hi Andreas,
thanks for your quick reply :)  !

I got a try entering 01/03/2018 in a first cell A1; and aftwds defining
a range A1:A12;
then Menu/Data/Fill/Series

Thumbnail Series
Series in: Row
Type: date
Start value: 01/03/2018
Step value: her have tried values as 30, 31
Stop Value: 31/12/2018


Thumbnail Options
Date Unith: Month

Thumbnail Output
Output range: Sheet1!A1:A12

In that dialog box, as the ?OK? key is displayed as active, it lets let
suppose values in the fields are recognized as valid.
This did not work though.

I have found a tutorial along the following link:

http://www.madonnadeipoveri.org/opt/gnome/share/gnome/help/gnumeric/C/autofill.html

but could not reproduce the steps according to figures 1-18 to 1-20 in
the paragraph ?Filling with Dates?

Thanks for any further advice
Best regards


Charlie


On Mon, 12 Mar 2018 13:35:36 -0600, aguelzow wrote:
Hi,
Jan and Dec are not dates. Enter complete dates. If you want you can
format them in a way that shows only the month.

The step value is the number of days.

Note that since months have various numbers of days, you may not be
happy with your series in the long run.

Andreas

Sent from my Samsung Galaxy smartphone.

-------- Original message --------
From: barewillysprl
Date: 2018-03-12 12:39 (GMT-07:00)
To: gnumeric-list gnome org
Subject: how to fill a range of cells by a date-type serie?

how to fill a range of cells by a date-type serie?

Hi,
Here on gnumeric-1.10.17

The gnumeric manual tells to define date serie the same way as
number.

I tried reproduce that process using the Ctrl key on a range of cells
whose first cell has been filled with Jan; but nope :(

I also tried using the Menu/Data/Fill/Series and there checking the
boxes
Thumbnail Series
Series in: Row (or Column)
Type: date
Start value: Jan
Step value: her have tried various values as 1, m, mm, etc but did
not

succeed ! :(
Stop value:Dec

Thumbnail Options
Date Unith: Month

Thumbnail Output
Output range: Sheet1!A1:A12

Many thanks for any solution especially for filling the ?Step
value:?

Best regards

Charlie
_______________________________________________
gnumeric-list mailing list
gnumeric-list gnome org
https://mail.gnome.org/mailman/listinfo/gnumeric-list



------------------------------

Subject: Digest Footer

_______________________________________________
gnumeric-list mailing list
gnumeric-list gnome org
https://mail.gnome.org/mailman/listinfo/gnumeric-list


------------------------------

End of gnumeric-list Digest, Vol 165, Issue 7
*********************************************



[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]