Seems we need to update the pages. You can find a recent build at https://people.gnome.org/~mortenw/gnumeric/
Regards, Jean Le vendredi 28 mars 2014 à 06:06 +0000, Ditte Mølgård Heide-Jørgensen a écrit : > 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 _______________________________________________ gnumeric-list mailing list gnumeric-list@gnome.org https://mail.gnome.org/mailman/listinfo/gnumeric-list