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

2018-03-12 Thread barewillysprl
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 usi

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

2018-03-12 Thread aguelzow
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

Problem with Font height/Row Height

2018-03-12 Thread John R. Sowden
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 r

Re: Problem with Font height/Row Height

2018-03-12 Thread Jean Bréfort
Just made a test and theline heights are correct for me when loaded in gnumeric. Which version are you using? Jean Le lundi 12 mars 2018 à 13:25 -0700, John R. Sowden a écrit : > I am in the process of switching from LO to Gnumeric because of the > very > slow operation of LO. The problem I am f

Re: Problem with Font height/Row Height

2018-03-12 Thread Andreas J Guelzow
Hi, while Gnumeric should load the correct row heights you can fix it after the fact by selecting the whole sheet and then choose format->rows->AutoFitHeight. Andreas On 18-03-12 02:25 PM, John R. Sowden wrote: I am in the process of switching from LO to Gnumeric because of the very slow o

Re: Problem with Font height/Row Height

2018-03-12 Thread Dean McCarron
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,

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

2018-03-12 Thread Pere Pujal i Carabantes
El dl 12 de 03 de 2018 a les 19:39 +0100, en/na barewillysprl va escriure: > 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

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

2018-03-12 Thread Bee
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] --o

Re: Problem with Font height/Row Height

2018-03-12 Thread Jean Bréfort
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