Weekly Edition
Return to the Development pageRecent Features
| |||||||||||||||||||
Gnumeric 1.10 is out
Free, Fast, Accurate -- Pick Any Three!
The Gnumeric Team is proud to announce the new stable
1.10.x series. This is the product of almost two years of
development.
What's New?
* Adjustable sheet size: sheets are no longer restricted to 256
columns of 65536 rows.
* Graphs have been improved. For example:
o New plot types for surfaces and probability plots.
o When an axis is a date or time axis, reasonable places for
tick marks will be picked.
o Cubic splines interpolation.
o Error bars in polar and radar plots.
* ODF support has been improved. Note, that until and unless the
syntax and semantics of ODF files are defined, interoperability
between any two implementations will be limited. Five years with no
action on that front suggests that it will not happen in the near
term. My five years old assessment still applies.
* Compatibility: we have improved function compatibility with
Excel, mostly in border cases. Gnumeric also now supports almost all
functions in the OpenFormula large function group. We have different
names for a few of them, but remap on load and save from ODF files.
* New functions are ACOT, ACOTH, ADTEST, ARABIC,
ASCENSIONTHURSDAY, ASHWEDNESDAY, AVERAGEIF, BINOM.DIST.RANGE,
CHOLESKY, COMBINA, COT, COTH, CSC, CSCH, CVMTEST, DAYS, EASTERSUNDAY,
EIGEN, FINDB, FOURIER, GAMMA, GD, GET.LINK, GOODFRIDAY, HDATE,
HDATE_DAY, HDATE_HEB, HDATE_JULIAN, HDATE_MONTH, HDATE_YEAR, IFNA,
ISFORMULA, JIS, LEFTB, LKSTEST, MIDB, MUNIT, NUMBERVALUE,
PENTECOSTSUNDAY, PERMUTATIONA, R.DSNORM, R.DST, R.PSNORM, RANDSNORM,
RANDSTDIST, RANK.AVG, REPLACEB, RIGHTB, RRI, SEARCHB, SEC, SFTEST,
SHEET, and SHEETS.
* Faster evaluation: some fairly common sheets with large numbers
of calls to the HLOOKUP or similar functions, over the same database
have been improved from "rather slow" to "instant". Similar
improvements have been implemented for farms of RANK or PERCENTILE
calls.
* Memory usage for large sheets is significantly down.
* The statistical analysis tools have been improved and there are
quite a few new ones, for example:
o Kaplan-Meier Estimates.
o Principal Component Analysis.
o Normality Tests.
o Sign Tests.
o Trend and/or Season Corrected Exponential Smoothing.
* Support for sheet objects (lines, arrows, widgets, ...) has been improved.
* New utility: ssgrep allows searching collections of spreadsheet
files in a manner similar to how grep searches text files.
Requirements
Gnumeric 1.10.x requires the new Goffice 0.8.x library series, a
fairly recent libgsf, and a GTK+ stack. See here for details.
Availability
http://ftp.gnome.org/pub/GNOME/sources/gnumeric/1.10/
http://ftp.gnome.org/pub/GNOME/sources/goffice/0.8/
Morten Welinder
On behalf of the Gnumeric team
_______________________________________________
gnome-announce-list mailing list
gnome-announce-list@gnome.org
http://mail.gnome.org/mailman/listinfo/gnome-announce-list
(Log in to post comments)
Gnumeric 1.10 is out Posted Feb 16, 2010 16:04 UTC (Tue) by jwb (guest, #15467) [Link]
I would just like to say thanks for Gnumeric. It is hugely superior to OO.o
Calc. I use Gnumeric every day.
Gnumeric 1.10 is out Posted Feb 16, 2010 16:43 UTC (Tue) by drag (subscriber, #31333) [Link]
I would not put OO.org out too much. The new 3.2 release is pretty nice. :)
but ya.. they don't hold nothing over Gnumeric in terms of speed. It's a very nice program to use.
Gnumeric 1.10 is out Posted Feb 16, 2010 19:29 UTC (Tue) by andrel (subscriber, #5166) [Link]
How do you find Gnumeric superior to OO.O?
Gnumeric 1.10 is out Posted Feb 16, 2010 19:42 UTC (Tue) by jwb (guest, #15467) [Link]
For one thing Gnumeric starts instantly whereas OOo Calc starts quite
laboriously. For another Gnumeric's GTK UI fits perfectly into my desktop while OOo is faking it, and it shows. Lastly I frequently export my charts from Gnumeric in SVG format, a capability which I believe OOo still lacks.
In fact I just checked OOo 3.1.1 which seems to still be completely unable to
Charts Posted Feb 16, 2010 19:53 UTC (Tue) by corbet (editor, #1) [Link] The chart export issue is a big one; I can't imagine why OOo hasn't figured that out yet. If you want an image file from an OOo chart, you have to export the whole document as PDF, bring it up in your favorite PDF viewer, take a screen shot, then whittle it down to the chart. Gnumeric, instead, has a straightforward "save as image" option. As a result, a chart-heavy article due to appear this week was done with Gnumeric rather than OOo.
Charts Posted Feb 16, 2010 19:59 UTC (Tue) by chaneau (subscriber, #6674) [Link] I think the easiest way is to export in html, you will get your chart as a jpeg image
intuitivity Posted Feb 18, 2010 3:09 UTC (Thu) by coriordan (guest, #7544) [Link]
Great. And when they add SVG export, I guess they'll add a button "export to zip file", which'll give a zipped SVG :-)
intuitivity Posted Feb 18, 2010 7:00 UTC (Thu) by chaneau (subscriber, #6674) [Link]
:-)
Well I don't claim the situation is ideal far from it, but this is a common
This is one the problem I face everyday, for example I use BoUML for all my
As you probably know LaTeX does not deal very well with png unless your
The question is, how difficult would it be to include a pdf exporter to
Frankly this does not bother me much (if at all) as inkscape can be quite
intuitivity Posted Feb 18, 2010 21:26 UTC (Thu) by amd (guest, #37690) [Link]
Well, although it is quite unintuitive, you can use imagemagick's convert utility to convert png-
>pdf.
Or anything else that can do it..
intuitivity Posted Feb 22, 2010 1:01 UTC (Mon) by anselm (subscriber, #2796) [Link] As you probably know LaTeX does not deal very well with png As a matter of fact LaTeX handles PNG fine. PdfLaTeX, that is -- but if you're converting PNG to PDF then you're likely to be using that already.
intuitivity Posted Feb 22, 2010 15:05 UTC (Mon) by chaneau (subscriber, #6674) [Link] As a matter of fact LaTeX handles PNG fineWell, yes and no, I'm afraid I was not able to convey the point I was trying to make. I produce a lot of material with LaTeX, in fact apart from some test I do with Office suite, I always work with LaTeX, some of these are for formations and I like to incorporate graphics in my texts, so I have two options, I can insert either a high resolution bitmap, or a vector graphic (typically a svg), the difference lies only in the ability to zoom the document without losing too much quality Anyway, LaTeX can't import svg files, so I have to convert them to pdf, which I do with inkscape And so here is my first point, I would like to be able to export my graphics in pdf, but the developer has no time to do it and me neither, but I have nevertheless all the tools to do the job, so the point is moot My second point was that OpenOffice.org is not able to export a chart, although if you save your spreadsheet as html, you get your chart as a jpeg file, so I think everything is there, all you have to do is add a menu option labelled "export your chart..." but apparently nobody is interested in actually doing it and here I see a hiatus, but maybe it's just me ;-)
Charts Posted Feb 16, 2010 20:54 UTC (Tue) by Trelane (subscriber, #56877) [Link]
Inkscape can edit (a page at a time) PDFs in vector format.
Gnumeric 1.10 is out Posted Feb 17, 2010 8:21 UTC (Wed) by rsidd (subscriber, #2582) [Link]
Let me add another: I frequently open text-format files (csv, tsv) in gnumeric with a simple command-line "gnumeric filename.csv". When I tried that in openoffice, it opened in OpenOffice Writer -- even though I wrote "oocalc" on the commandline. (Hm, I just tried it again and they seem to have fixed it: but I still need to uncheck "space" and "semicolon" as separators, and check "comma", even though it's a CSV file!)
I rarely use spreadsheets, and when I do, I much more commonly write python programs to analyse the CSV file directly, than import into a spreadsheet program. When I do the latter, it is just to take a quick visual look. And Gnumeric is much, much quicker for that purpose.
Gnumeric 1.10 is out Posted Feb 16, 2010 20:58 UTC (Tue) by Trelane (subscriber, #56877) [Link]
The source code is much more sane. :)
Gnumeric 1.10 is out Posted Feb 17, 2010 15:20 UTC (Wed) by tialaramex (subscriber, #21167) [Link]
It's a LOT more Excel compatible. With the exception of features that are completely missing (which is unfortunate, but at least obvious) the Excel compatibility in Gnumeric has been very good, and they've taken a few patches from me to improve it. For people who actually need to work with Excel sheets, and particularly for people who need confidence in the numbers they get from such sheets, this is vital.
In practice OO.org can't be expected to deliver even close to 100% compatibility, because the software it derives from historically deliberately isn't compatible with Excel in certain ways, and Excel is riddled with implied-type problems (e.g. date handling, and formulae which convert things into strings, mangle them, and then convert back again) so trying to add more Excel compatibility would mean having a big switch ("Do you want Excel compatibility or OO.org compatibility?") and lots of conditionals scattered through their codebase.
|
|||||||||||||||||||