El dt 13 de 03 de 2018 a les 20:27 +0100, en/na barewillysprl va escriure: > Hi again, > Re: how to fill a range of cells by a date-type serie? > > Here running gnumeric-1.10.17 on Puppy Linux Stretch (Debian 9 distro > based - was also the case on earlier distros as Debian 7 based) > > Autofill is locales dependent for dates, at least for the method > described by Pere and Bill («...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...»). > It works for en_US, catalan locale; but not for fr_BE nor fr_FR. > > My locale is fr_BE. > Pere's method did not work for fr-BE locale; nor after switching to > fr_FR locale.
Works here for both fr_FR.UTF.8 and fr_BE.UTF-8 locales on a Debian Sid I see the month names being equal janvier février but the abbreviatures differs from BE vs FR jan fév vs janv. févr. I don't know if the reason it works for me is because the newer gnumeric or a newer locale or ??? Anyway glad you got it working :) Pere > > Further verifying, I then switched the locales setting to en_US. > So Pere's method works for en_US provided the months are written in > english ! > > But second method described by Bill (using the Menu/Data/Fill/Series > dialog box) works here for fr_BE. > > Thanks for any advices. > HTH > > Charlie > > > 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 > > ********************************************* > > _______________________________________________ > 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
