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



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



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