Re: text labels on x-y scatterplots
- From: Jean Bréfort <jean brefort normalesup org>
- To: Christian Ritter <christian ritter ridaco be>
- Cc: gnumeric-list gnome org
- Subject: Re: text labels on x-y scatterplots
- Date: Thu, 10 Apr 2008 13:08:26 +0200
Le mercredi 09 avril 2008 à 11:02 +0200, Christian Ritter a écrit :
I've been watching gnumeric grow and every once in a while I try it to
see if I can already use it for my work. Congratulations, it's getting
closer, but there remain some show stoppers.
I'm working under Windows (Vista) and occasionally under Debian Linux.
The latest version I tried is 1.9.0 under Windows Vista. Here are some
of the things which (still) keep me from abandoning Excel for some of my
1) I cannot label points on x-y graphs nor identify individual points in
an easy way. This is something that Excel is not very good at, but at
least one can do it. Ideally, it should be possible to create an x-y
graph with a label, a color, and a symbol vector alongside, such that I
can modify displayed text, color, and symbol via auxiliary columns in
the data frame. This is something Excel can't do either, but one can
force it (using the XYChartLabeler add-in). If gnumeric could do this,
it would be a step ahead in another critical area (besides mathematical
and statistical functions).
labels clearly need to be implemented, and are just waiting for a
volunteer. Changing the style from the contents of cells seems a bit
tricky to implement with the current framework. Note that we already
have scatter plots with the color of the markers calculated from data
(we just need a user interface to set the colors to use to make it fully
functional, imho). We might also change the size of the marker (negative
or nul values would probably be ignored).
2) I cannot link gnumeric to the R language. Some years ago, Duncan
Temple Lang wrote Rgnumeric, an experimental version to combine gnumeric
and R in a linux environment. Yet, this package was not developed
further (maybe gnumeric was too immature at that point in time) and has
fallen into disrepair. On windows it does not work at all. This would
also be a way out of graphics limitation: If I can have worksheet
functions in gnumeric which invoke R graphics working on ranges in
gnumerics then all the graphics power in R becomes available in
gnumeric. For those who are interested on what this could look like, try
RExcel (E Neuwirth and T Baier). There should be an R-package on cran
which installs what is needed under windows within the next days.
There are plans to have more statistics related plots in
goffice/gnumeric very soon. I don't see how we might use sheet functions
to get R graphs in, may be commands in the Tools menu would be more
appropriate, if somebody volunteers.
3) Pivot tables are in the announced list but haven't come in yet ...
again this could be circumvented via R using the reshape package.
This also needs volunteers, essentially to devise a good user interface.
Using R will not help as long as we have not the interface.
4) I cannot access databases (ODBC, JDBC, or DBI) using an import
mechanism from gnumeric. (Here is another thing one could do with
gnumeric which Excel can't do: save a range as a table in a relational
data base. Obviously, this only works if the range satisfies a few rules
... but this can be done. Again, RExcel shows a way on how to
automatically convert a range to an R dataframe. And from there it's
only one call to a database... and maybe one doesn't have to go through
R at all).
I don't know the current status of the gda and gnome-db packages.
Apparently libgda has some support for ODBC, see
Any comments? Anyone to second my wishes? I'll be at the useR conference
at Dortmund in summer and I'll try to find some souls interested in
revisiting the Rgnumeric project ... I'm not much of a programmer myself
... but I can help with ideas.
Ritter and Danielson Consulting
gnumeric-list mailing list
gnumeric-list gnome org
] [Thread Prev