GNOME.org
 

RE: Reverse legend in stacked column chart

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-bounces gnome org] on behalf of gnumeric-list-request gnome org 
[gnumeric-list-request 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-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. 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" <rex levee wustl edu>
To: gnumeric-list gnome org
Subject: Imported text is converted to date
Message-ID: <1395936535 26841 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 <mwelinder gmail com>
To: Rex Couture <rex levee wustl edu>
Cc: Gnumeric Mailing List <gnumeric-list gnome org>
Subject: Re: Imported text is converted to date
Message-ID:
        <CANv4PNnLprRExPLqeK=okU7NVOtKTQ1movE-dhqaNLUC5Mf9-g 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 <rex 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 <bob statland org>
To: rex levee wustl edu (Rex Couture)
Cc: gnumeric-list gnome org
Subject: Re: Imported text is converted to date
Message-ID: <20140327172319 4FF74E190649 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 <dihj 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 ?
dihj math ku dk<mailto:dihj 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 brefort 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 ?

dihj 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 brefort 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 ?

dihj 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 <mwelinder gmail com>
To: Rex Couture <rex 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_AMw 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 <rex 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
*********************************************
[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]