Re: gnumeric-list Digest, Vol 165, Issue 7 (SOLVED)
- From: barewillysprl <barewillysprl scarlet be>
- To: <gnumeric-list gnome org>
- Subject: Re: gnumeric-list Digest, Vol 165, Issue 7 (SOLVED)
- Date: Tue, 13 Mar 2018 20:04:47 +0100
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, gnumeric-list-request gnome org
wrote:
Send gnumeric-list mailing list submissions to
gnumeric-list gnome org
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
gnumeric-list-request gnome org
You can reach the person managing the list at
gnumeric-list-owner gnome org
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 <beeyawned gmail com>
To: gnumeric-list gnome org
Subject: Re: how to fill a range of cells by a date-type serie?
Message-ID: <20180312170502 0eb894307af65eb9be7719fa gmail com>
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 <ppujal airtel net>
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 <jean brefort normalesup org>
To: Dean McCarron <dm-gnome mercuryresearch com>,
gnumeric-list gnome org
Subject: Re: Problem with Font height/Row Height
Message-ID: <1520921128 1996 2 camel normalesup org>
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
> 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
------------------------------
Message: 3
Date: Tue, 13 Mar 2018 09:09:40 +0100
From: Fr?d?ric Parrenin <frederic parrenin univ-grenoble-alpes fr>
To: Jean Br?fort <jean brefort normalesup org>
Cc: Dean McCarron <dm-gnome mercuryresearch com>,
gnumeric-list gnome org
Subject: Re: Problem with Font height/Row Height
Message-ID:
<45a497d6-fa98-f13b-82df-de6720216a2a univ-grenoble-alpes fr>
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
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
_______________________________________________
gnumeric-list mailing list
gnumeric-list gnome org
https://mail.gnome.org/mailman/listinfo/gnumeric-list
------------------------------
Message: 4
Date: Tue, 13 Mar 2018 09:20:46 +0100
From: barewillysprl <barewillysprl scarlet be>
To: aguelzow <aguelzow pyrshep ca>
Cc: <gnumeric-list gnome org>
Subject: Re: how to fill a range of cells by a date-type serie?
Message-ID: <5905298e77fd6ac39e78ce19ad24d920 scarlet be>
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: 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
------------------------------
Subject: Digest Footer
_______________________________________________
gnumeric-list mailing list
gnumeric-list gnome org
https://mail.gnome.org/mailman/listinfo/gnumeric-list
------------------------------
End of gnumeric-list Digest, Vol 165, Issue 7
*********************************************
[
Date Prev][
Date Next] [
Thread Prev][
Thread Next]
[
Thread Index]
[
Date Index]
[
Author Index]
