Hi again,
Thanks for your quick reply. I realized that I'm using 1.10.16 (from the Get
Gnumeric Now page https://projects.gnome.org/gnumeric/downloads.shtml), since
the link from the frontpage to the Win32 build of 1.12.9 does't work for me. I
didn't check the versions before I downloaded.
Can you tell me how to get the latest Win32 build?
Best,
Ditte
________________________________________
From: gnumeric-list [gnumeric-list-boun...@gnome.org] on behalf of
gnumeric-list-requ...@gnome.org [gnumeric-list-requ...@gnome.org]
Sent: Friday, March 28, 2014 1:26 AM
To: gnumeric-list@gnome.org
Subject: gnumeric-list Digest, Vol 119, Issue 9
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-requ...@gnome.org
You can reach the person managing the list at
gnumeric-list-ow...@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. Imported text is converted to date (Rex Couture)
2. Re: Imported text is converted to date (Morten Welinder)
3. Re: Imported text is converted to date (Bob)
4. Reverse legend in stacked column chart
(Ditte M?lg?rd Heide-J?rgensen)
5. Re: Reverse legend in stacked column chart (Jean Br?fort)
6. Re: Reverse legend in stacked column chart (Jean Br?fort)
7. Re: Imported text is converted to date (Morten Welinder)
----------------------------------------------------------------------
Message: 1
Date: Thu, 27 Mar 2014 11:08:55 -0500 (CDT)
From: "Rex Couture" <r...@levee.wustl.edu>
To: gnumeric-list@gnome.org
Subject: Imported text is converted to date
Message-ID: <1395936535.26...@levee.wustl.edu>
Content-Type: text/plain; charset="iso-8859-1"
I have a problem importing a text string. In the attached .csv file the string
"10.4.2" is imported incorrectly as a date, and once imported, there does not
seem to be a way to recover the correct text. (I just open the file, and it is
imported automatically.) LibreOffice and Excel for Windows import it as text,
as intended. The only workaround I have found is to prefix it with an
apostrophe ("'"), which has the disadvantage that an unwanted apostrophe
appears in those spreadsheets.
Is there another way to import this as text--preferably automatically? Is this
a bug?
The problem occurs in versions 1.10.9 for Windows and 1.10.17 for Linux. I
have not tried 1.12 yet.
-------------- next part --------------
A non-text attachment was scrubbed...
Name: test.csv
Type: text/csv
Size: 92 bytes
Desc: not available
URL:
<https://mail.gnome.org/archives/gnumeric-list/attachments/20140327/bccd263a/attachment.csv>
------------------------------
Message: 2
Date: Thu, 27 Mar 2014 12:37:52 -0400
From: Morten Welinder <mwelin...@gmail.com>
To: Rex Couture <r...@levee.wustl.edu>
Cc: Gnumeric Mailing List <gnumeric-list@gnome.org>
Subject: Re: Imported text is converted to date
Message-ID:
<CANv4PNnLprRExPLqeK=oku7nvotktq1move-dhqanluc5mf...@mail.gmail.com>
Content-Type: text/plain; charset=ISO-8859-1
It'll be the same with newer versions.
Basically, "csv" is an underspecified format. Everyone has their own
idea of what a csv is supposed to mean. Every choice we make is
"right" for some people, but "wrong" for someone else.
You can use the configurable text importer to impose your own opinion.
Select the "Text" format for the column in question.
But the best solution is to avoid csv altogether.
Morten
On Thu, Mar 27, 2014 at 12:08 PM, Rex Couture <r...@levee.wustl.edu> wrote:
> I have a problem importing a text string. In the attached .csv file the
> string "10.4.2" is imported incorrectly as a date, and once imported, there
> does not seem to be a way to recover the correct text. (I just open the
> file, and it is imported automatically.) LibreOffice and Excel for Windows
> import it as text, as intended. The only workaround I have found is to
> prefix it with an apostrophe ("'"), which has the disadvantage that an
> unwanted apostrophe appears in those spreadsheets.
>
> Is there another way to import this as text--preferably automatically? Is
> this a bug?
>
> The problem occurs in versions 1.10.9 for Windows and 1.10.17 for Linux. I
> have not tried 1.12 yet.
>
> _______________________________________________
> gnumeric-list mailing list
> gnumeric-list@gnome.org
> https://mail.gnome.org/mailman/listinfo/gnumeric-list
>
------------------------------
Message: 3
Date: Thu, 27 Mar 2014 13:23:19 -0400 (EDT)
From: Bob <b...@statland.org>
To: r...@levee.wustl.edu (Rex Couture)
Cc: gnumeric-list@gnome.org
Subject: Re: Imported text is converted to date
Message-ID: <20140327172319.4ff74e190...@lilly.csoft.net>
Content-Type: text/plain; charset=us-ascii
I tried to paste this into Gnumeric 1.10.17. That does provide some
options. I found the default text delimiter to be a double quote yet
like you the first string comes in as a date anyway. So I think there
is at least a bug of things not being correctly labelled. If the
program says stuff in double quotes comes in as text it should.
I don't think anyone would write a date that way in the USA so I
wonder if there is some locale setting somewhere that is relevant?
Outside of software version numbers and mathematics books, a string of
numerals with multiple decimal points is pretty much illegal so it's
hard to guess what would make a good default for handling it.
Is the initial single quote really a problem? My experience going
back to Lotus 1-2-3 is that a single inital quote is how you flag
something as text. Most spreadsheets just drop that character when
they do something with the cell contents. It's kind of like the
equals sign in Excel to indicate a formula.
>
> This is a multi-part message in MIME format.
>
> --bound1395936535
> Content-Type: text/plain; charset=iso-8859-1
> Content-Transfer-Encoding: 7bit
>
> I have a problem importing a text string. In the attached .csv file the
> string "10.4.2" is imported incorrectly as a date, and once imported, there
> does not seem to be a way to recover the correct text. (I just open the
> file, and it is imported automatically.) LibreOffice and Excel for Windows
> import it as text, as intended. The only workaround I have found is to
> prefix it with an apostrophe ("'"), which has the disadvantage that an
> unwanted apostrophe appears in those spreadsheets.
>
> Is there another way to import this as text--preferably automatically? Is
> this a bug?
>
> The problem occurs in versions 1.10.9 for Windows and 1.10.17 for Linux. I
> have not tried 1.12 yet.
>
> --bound1395936535
> Content-type: text/csv; name="test.csv"
> Content-Disposition: attachment; filename="test.csv"
> Content-Transfer-Encoding: base64
>
> MTAuNC4yLCAgIDEwLjIsIDEzLjQuMgoiMTAuNC4yIiwgMTAuMiwgMTMuNC4yCicxMC40LjInLCAx
> MC4yLCAxMy40LjIKJzEwLjQuMiwgIDEwLjIsIDEzLjQuMgo=
>
> --bound1395936535
> Content-Type: text/plain; charset="us-ascii"
> MIME-Version: 1.0
> Content-Transfer-Encoding: 7bit
> Content-Disposition: inline
>
> _______________________________________________
> gnumeric-list mailing list
> gnumeric-list@gnome.org
> https://mail.gnome.org/mailman/listinfo/gnumeric-list
>
> --bound1395936535--
>
>
>
-------> First-time AP Stats. teacher? Help is on the way! See
http://courses.ncssm.edu/math/Stat_Inst/Stats2007/Bob%20Hayden/Relief.html
_
| | Robert W. Hayden
| | 614 Nashua Street #119
/ | Milford, New Hampshire 03055 USA
| |
| | email: bob@ the site below
/ x | website: http://statland.org
| /
''''''
------------------------------
Message: 4
Date: Thu, 27 Mar 2014 19:52:11 +0000
From: Ditte M?lg?rd Heide-J?rgensen <d...@math.ku.dk>
To: "gnumeric-list@gnome.org" <gnumeric-list@gnome.org>
Subject: Reverse legend in stacked column chart
Message-ID:
<299369BFEB951C4F8E607A7DF0F75CEB1BACB52D@P1KITMBX07WC04.unicph.domain>
Content-Type: text/plain; charset="iso-8859-1"
Hi everyone,
I'm using stacked column charts to display some data, but the legend is in the
reverse order of the columns displayed in the chart. Is this intended and is
there a workaround? Besides trying to figure out how to change this in a
setting, I've tried to rearrange data in several ways all leading to wrong
charts (for example I reversed the order of the columns in the chart options
and got the legend right, but the data stacked upside down).
Any help is appreciated :)
Best regards,
Ditte
Ditte M?lg?rd Heide-J?rgensen
PhD student
University of Copenhagen
Department of Mathematical Sciences
Universitetsparken 5,
2100 Copenhagen ?
d...@math.ku.dk<mailto:d...@math.ku.dk>
www.math.ku.dk<http://www.math.ku.dk/>
-------------- next part --------------
An HTML attachment was scrubbed...
URL:
<https://mail.gnome.org/archives/gnumeric-list/attachments/20140327/abf2bc5d/attachment.html>
------------------------------
Message: 5
Date: Thu, 27 Mar 2014 21:21:23 +0100
From: Jean Br?fort <jean.bref...@normalesup.org>
To: gnumeric-list@gnome.org
Subject: Re: Reverse legend in stacked column chart
Message-ID: <1395951683.3764.1.camel@naoned>
Content-Type: text/plain; charset="UTF-8"
Hi,
In a stacked chart, the series are displayed from bottom to top, while
it is the reverse order in the legend. There is no way currently to
change this behavior.
Regards,
Jean
Le jeudi 27 mars 2014 ? 19:52 +0000, Ditte M?lg?rd Heide-J?rgensen a
?crit :
> Hi everyone,
>
> I'm using stacked column charts to display some data, but the legend
> is in the reverse order of the columns displayed in the chart. Is this
> intended and is there a workaround? Besides trying to figure out how
> to change this in a setting, I've tried to rearrange data in several
> ways all leading to wrong charts (for example I reversed the order of
> the columns in the chart options and got the legend right, but the
> data stacked upside down).
>
>
> Any help is appreciated :)
>
>
> Best regards,
> Ditte
>
>
>
>
>
> Ditte M?lg?rd Heide-J?rgensen
>
> PhD student
>
> University of Copenhagen
>
>
>
> Department of Mathematical Sciences
>
> Universitetsparken 5,
>
> 2100 Copenhagen ?
>
> d...@math.ku.dk
>
> www.math.ku.dk
>
>
> _______________________________________________
> gnumeric-list mailing list
> gnumeric-list@gnome.org
> https://mail.gnome.org/mailman/listinfo/gnumeric-list
------------------------------
Message: 6
Date: Thu, 27 Mar 2014 22:18:04 +0100
From: Jean Br?fort <jean.bref...@normalesup.org>
To: gnumeric-list@gnome.org
Subject: Re: Reverse legend in stacked column chart
Message-ID: <1395955084.3764.2.camel@naoned>
Content-Type: text/plain; charset="UTF-8"
Actually, it seems that this has been fixed some times ago, which
version are you using?
Best regards,
Jean
Le jeudi 27 mars 2014 ? 21:21 +0100, Jean Br?fort a ?crit :
> Hi,
>
> In a stacked chart, the series are displayed from bottom to top, while
> it is the reverse order in the legend. There is no way currently to
> change this behavior.
>
> Regards,
> Jean
>
> Le jeudi 27 mars 2014 ? 19:52 +0000, Ditte M?lg?rd Heide-J?rgensen a
> ?crit :
> > Hi everyone,
> >
> > I'm using stacked column charts to display some data, but the legend
> > is in the reverse order of the columns displayed in the chart. Is this
> > intended and is there a workaround? Besides trying to figure out how
> > to change this in a setting, I've tried to rearrange data in several
> > ways all leading to wrong charts (for example I reversed the order of
> > the columns in the chart options and got the legend right, but the
> > data stacked upside down).
> >
> >
> > Any help is appreciated :)
> >
> >
> > Best regards,
> > Ditte
> >
> >
> >
> >
> >
> > Ditte M?lg?rd Heide-J?rgensen
> >
> > PhD student
> >
> > University of Copenhagen
> >
> >
> >
> > Department of Mathematical Sciences
> >
> > Universitetsparken 5,
> >
> > 2100 Copenhagen ?
> >
> > d...@math.ku.dk
> >
> > www.math.ku.dk
> >
> >
> > _______________________________________________
> > 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: 7
Date: Thu, 27 Mar 2014 20:25:39 -0400
From: Morten Welinder <mwelin...@gmail.com>
To: Rex Couture <r...@wustl.edu>
Cc: Gnumeric Mailing List <gnumeric-list@gnome.org>
Subject: Re: Imported text is converted to date
Message-ID:
<CANv4PN=sept-s_awt-wpbynjmy+hqv1jh-5351rwijqdco_...@mail.gmail.com>
Content-Type: text/plain; charset=ISO-8859-1
>Unfortunately, I believe the configurable text importer also fails in the same
>way.
> With the attached .csv file I get identical results either by automatic
> importation
> or by using the configurable text importer (setting " as the text indicator).
The text indicator has nothing to do with this.
On the third page, select "Text" instead of "General".
Morten
On Thu, Mar 27, 2014 at 6:58 PM, Rex Couture <r...@wustl.edu> wrote:
> Thanks for your helpful comments. I've looked at the problem some more,
> and I understand it better now.
>
> Unfortunately, I believe the configurable text importer also fails in
> the same way. With the attached .csv file I get identical results either by
> automatic importation or by using the configurable text importer (setting "
> as the text indicator).
>
> I think the .csv specification is not the source of the problem, and
> neither is text importation. The problem is that Gnumeric always interprets
> a string such as 10.24.2 as a date unless it is preceded by a single quote '
> . This is true for either manual (keyboard) input or text import. If I
> enter 10.24.2 into a blank cell, Gnumeric interprets that as a date unless I
> precede it with an apostrophe. I did not find an actual specification for
> entering dates, but the Help document has many examples, and this format
> (with periods) is not one of them.
>
> For text import this behavior does not work if a delimiter is intended
> as part of the string. For example, in the attached .csv file, importing
> the first and second lines fails if commas are intended as part of the
> string. In the third and fourth lines of the attachment, Gnumeric
> recognizes "10.24.2, 3.7" as a string, but again it interprets "10.24.2" as
> a date (use " as the text indicator). For my own application I can work
> around it easily, but I didn't find a general workaround. To import strings
> like that I suppose one could use tab-delimited files, but the undesirable
> effect is that the file import method must depend on the strings.
------------------------------
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 119, Issue 9
*********************************************
_______________________________________________
gnumeric-list mailing list
gnumeric-list@gnome.org
https://mail.gnome.org/mailman/listinfo/gnumeric-list
