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

[aguelzow <aguelzow pyrshep ca>]

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 <barewillysprl scarlet be>

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