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, [email protected] 
wrote:
> Send gnumeric-list mailing list submissions to
> 	[email protected]
>
> 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
> 	[email protected]
>
> You can reach the person managing the list at
> 	[email protected]
>
> 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 <[email protected]>
> To: [email protected]
> Subject: Re: how to fill a range of cells by a date-type serie?
> Message-ID: <[email protected]>
> 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 <[email protected]>
>>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 <[email protected]>
> To: Dean McCarron <[email protected]>,
> 	[email protected]
> Subject: Re: Problem with Font height/Row Height
> Message-ID: <[email protected]>
> 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
>> > [email protected]
>> > https://mail.gnome.org/mailman/listinfo/gnumeric-list
>>
>> _______________________________________________
>> gnumeric-list mailing list
>> [email protected]
>> https://mail.gnome.org/mailman/listinfo/gnumeric-list
>
>
> ------------------------------
>
> Message: 3
> Date: Tue, 13 Mar 2018 09:09:40 +0100
> From: Fr?d?ric Parrenin 	<[email protected]>
> To: Jean Br?fort <[email protected]>
> Cc: Dean McCarron <[email protected]>,
> 	[email protected]
> Subject: Re: Problem with Font height/Row Height
> Message-ID:
> 	<[email protected]>
> 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
>>>> [email protected]
>>>> https://mail.gnome.org/mailman/listinfo/gnumeric-list
>>> _______________________________________________
>>> gnumeric-list mailing list
>>> [email protected]
>>> https://mail.gnome.org/mailman/listinfo/gnumeric-list
>> _______________________________________________
>> gnumeric-list mailing list
>> [email protected]
>> https://mail.gnome.org/mailman/listinfo/gnumeric-list
>
>
>
> ------------------------------
>
> Message: 4
> Date: Tue, 13 Mar 2018 09:20:46 +0100
> From: barewillysprl <[email protected]>
> To: aguelzow <[email protected]>
> Cc: <[email protected]>
> Subject: Re: how to fill a range of cells by a date-type  serie?
> Message-ID: <[email protected]>
> 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: [email protected]
>> 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
>> [email protected]
>> https://mail.gnome.org/mailman/listinfo/gnumeric-list
>
>
>
> ------------------------------
>
> Subject: Digest Footer
>
> _______________________________________________
> gnumeric-list mailing list
> [email protected]
> https://mail.gnome.org/mailman/listinfo/gnumeric-list
>
>
> ------------------------------
>
> End of gnumeric-list Digest, Vol 165, Issue 7
> *********************************************