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

[barewillysprl <barewillysprl scarlet be>]

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