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 <barewillys...@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
_______________________________________________ gnumeric-list mailing list gnumeric-list@gnome.org https://mail.gnome.org/mailman/listinfo/gnumeric-list
