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 [[email protected]] on behalf of [email protected] [[email protected]] Sent: Friday, March 28, 2014 1:26 AM To: [email protected] Subject: gnumeric-list Digest, Vol 119, Issue 9 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. 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" <[email protected]> To: [email protected] Subject: Imported text is converted to date Message-ID: <[email protected]> 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 <[email protected]> To: Rex Couture <[email protected]> Cc: Gnumeric Mailing List <[email protected]> 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 <[email protected]> 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 > [email protected] > https://mail.gnome.org/mailman/listinfo/gnumeric-list > ------------------------------ Message: 3 Date: Thu, 27 Mar 2014 13:23:19 -0400 (EDT) From: Bob <[email protected]> To: [email protected] (Rex Couture) Cc: [email protected] Subject: Re: Imported text is converted to date Message-ID: <[email protected]> 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 > [email protected] > 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 <[email protected]> To: "[email protected]" <[email protected]> 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 ? [email protected]<mailto:[email protected]> 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 <[email protected]> To: [email protected] 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 ? > > [email protected] > > www.math.ku.dk > > > _______________________________________________ > gnumeric-list mailing list > [email protected] > https://mail.gnome.org/mailman/listinfo/gnumeric-list ------------------------------ Message: 6 Date: Thu, 27 Mar 2014 22:18:04 +0100 From: Jean Br?fort <[email protected]> To: [email protected] 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 ? > > > > [email protected] > > > > www.math.ku.dk > > > > > > _______________________________________________ > > 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: 7 Date: Thu, 27 Mar 2014 20:25:39 -0400 From: Morten Welinder <[email protected]> To: Rex Couture <[email protected]> Cc: Gnumeric Mailing List <[email protected]> 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 <[email protected]> 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 [email protected] https://mail.gnome.org/mailman/listinfo/gnumeric-list ------------------------------ End of gnumeric-list Digest, Vol 119, Issue 9 ********************************************* _______________________________________________ gnumeric-list mailing list [email protected] https://mail.gnome.org/mailman/listinfo/gnumeric-list
