Gnumeric

Gnumeric 1.9.4 aka "Greased Weasel" is now available.

The Gnumeric Team is pleased to announce the availability of Gnumeric version 1.9.4.

This release is a development release with lots and lots of bug fixes. Also, this version is considerably faster than previous versions in three ways: (1) when dealing with spreadsheets containing large farms of VLOOKUP, HLOOKUP, or MATCH calls over the same database, we now pre-process the database range once and the actual lookups are very fast; (2) we now only calculate the relevant branch of IF calls, unless implicit iteration is in effect; (3) large spreadsheets containing many similar ranges like, for example, A$10:A10, A$10:A11, ..., A$10:A9999 used to hit a degenerate case in our dependency tracking.

This release requires the concurrently released goffice 0.7.3. We also recommend the new libgsf 1.4.11.

Attention packagers: goffice no longer depends on libgnome, libgnomeui, and gnome-vfs. (To get the full benefit of this, make sure libgsf is not compiled to require gnome-vfs and bonobo.)

Attention packagers: please do not ship goffice with equation enabled.

• Andreas
  • Change sheet manage dialog into an instant-apply dialog.
  • Implemented sheet duplication in manage sheets dialog. [Bug 128160].
  • Allow for undos in the manage sheet dialog.
  • Permit lexicographic sorting by sheet names in the manage sheets dialog. [Bug 527076].
  • Add functional seealso links in the function browser.
  • Allow ranges of censor marks in Kaplan-Meier tool and multiple groups. Output median survival times. [Bug 558582].
  • Add Log-Rank Test to Kaplan-Meier tool. [Bug 558582].
  • Add the name of the response variable to the regression tool output. [Bug 400019].
  • Fix critical when printing. [Bug 568991].
  • Update ucs usage when exporting to LaTeX. [Bug 569476].
• Henry Law
  • Fix dependency problem with constructed ranges. [Bug 562363].
• Hib Eris
  • Fix problems with toolbars when no handle bar present. [Bug 559249].
  • Fix problems with formats. [Bug 559291].
• Jean
  • Fix crash when exporting an empty contour plot to .xls. [Bug 557027].
  • Add widgets in the graph guru first page to allow finer selection of data.
  • Fix labels length for charts generated by the histogram tool. [Bug 552721].
  • Fix loss od new graphs when clicking on an existing sheet object. [Bug 151789].
  • Do not export invalid AXESUSED data to .xls. [Bug 567783].
  • Fix export of simple data to xls graphs. [Bug 567930].
• Jody
  • Display top-left when selecting a rel ref to a merged region.
  • Win32 fixed.
• Jon Kåre
  • Work around vulnerability in Python. [Bug 569648].
  • Improve encoding detection on html paste. [Part of Bug 564166].
• Lutz Mueller
  • Enable drag of whole sheets to other applications. [Bug 523033].
• Morten
  • Fix XLS import crash. [Bug 557077].
  • Fix problem with auto filter after column insert. [Bug 557237].
  • Fix undo problem with auto filters. [Bug 557591].
  • Remove the effect on an auto filter when its column is removed.
  • Plug leaks.
  • Remove the effect on an auto filter column when removed.
  • Fix RANDDISCRETE crash. [Bug 557682].
  • Fix SUMIF issues. [Bug 557782].
  • Fix LOOKUP critical. [Bug 559005].
  • Fix GROWTH/TREND crash. [Bug 559363].
  • Make non-gnome the default. [Bug 558840].
  • Disallow deleting last visible sheet. [Bug 557153].
  • Merge the sheet tabs into the status bar. [Bug 561733].
  • Fix crash in multi-view mode. [Bug 562053].
  • Introduce explicit () on parsing -2^2. [Bug 115941].
  • Fix inter-process paste crash. [Bug 556561].
  • Plug leak in TRIMMEAN.
  • Plug leak in RANK.
  • Plug leaks in ssindex, ssgrep, and ssconvert.
  • Fix export of Gnumeric-specific patterns to xls. [Bug 564078].
  • Improve guess of csv parsing parameters. [Bug 498912].
  • Fix problem with saving huge values. [Bug 552464].
  • Dump information about number system into xml.
  • Improve sc import. Not sure why. [Bug 564495].
  • Fix date overflow problem. [Bug 564502].
  • Fix XLS import critical. [Bug 564499].
  • Sanitize error cases for DAY, MONTH, YEAR.
  • Fix column-split problem with fixed-width stf import.
  • Fix problem with deprecated gtk+ stuff in glade files.
  • Fix xls export problem generating extra ()s. [Bug 567380].
  • Constify usage of GOFormats.
  • Fix inconsistentcy in searching with respect to formats.
  • Fix issue with BASE. [Bug 567252].
  • Fix XLS import criticals. [Bug 567823].
  • Don't evaluate both branches of IF. [Bug 326595].
  • Fix undo crash for inter-workbook operations. [Bug 568634].
  • Fix crash and criticals in dbf import. [Bug 568454].
  • Fix colour problem in LaTeX export. [Bug 568860].
  • Fix loop while loading lotus file. [Bug 568917].
  • Fix performance problem in dependency tracking given large number of large ranges. [Bug 567389].
  • Fix VLOOKUP and HLOOKUP for bools.
  • Fix problem reading slightly-corrupted dbf file. [Bug 568454].
  • If we overflow the sheet tab area, put list in context menu.
  • Fix ods load crash. [Bug 568994].
  • Use caches for bisection cases of VLOOKUP/HLOOKUP/LOOKUP/MATCH too. Fix issues with bools versus floats.
  • Fix parsing problem for constructed ranges. [Bug 569730].
  • Fix plugin menu merging. [Bug 569724].
  • Improve handling of 3D ranges. [Bug 569372].
  • For VLOOKUP and friends, do not turn empties into zeroes. [Bug 567389].
  • Implement MATCH for wildcards. [Bug 570139].
  • Fix problem with functions docs in locales without encoding information.
  • Work around a ODF spec. problem in OOo import. [Bug 570890].
  • Advertise fewer aliases for text/csv. [Bug 571073].
  • Fix Windows extra-Gnumeric paste problem. [Bug 564166].
  • Fix csv import problem with "-OINK". [Bug 571129].
  • Make sure ()s do not take up stack space during eval.
  • Make dependency debug output a little easier to read.
  • Warn when we drop csv rows. [Bug 571603].
  • Fix SERIESSUM.
  • Fix xls export of SERIESSUM. [Bug 572127].
  • Disable non-functional corba plugin. [Bug 572356].
  • Handle GTK+ deprecation issues. [Bug 572240].
  • When ssconvert-ing a single-sheet workbook, don't complain the exporter can handle only a single sheet. [Bug 572448].
  • Fix xls crash for bogus file. [Bug 572515].
  • Fix OO import issue. [Bug 568010].

Goffice 0.7.3 aka "TBD" is now available.

• Emmanuel
  • Experimental support for equation using gmathml. Disabled by default, as no release of gmathml exists yet. Source code of gmathml can be retrieved using the following command: git clone http://people.freedesktop.org/~emmanuel/gmathml.git
• Halton Huo
  • Add --without-long-double option. [Bug 557045].
• Jean
  • Fixed various regressions in contour plots.
  • Add XYZ series based contour plots.
  • Drop the libgome dependency. [Bug 558709].
  • Made spline interpolation really use Bezier cubic splines.
  • Add closed Bezier and cubic spline interpolation.
  • Make drop lines go to the axis instead of chart bottom (or left).
  • Make possible to add an application specific custom widget to the graph editor.
  • Fixed critical in graph_typeselect_minor. [Bug 567931].
  • Fixed crash when adding series to bar chart. [Bug 572354].
• Morten
  • Plug leaks.
  • Fix memory corruption issue. [Bug 561708].
  • Fix problem with formats like "0.0E-00". [Bug 563601].
  • Put the old 29-Feb-1900 problem to rest.
  • Fix fd://<n> uris after lobognomification.
  • Fix doc build with respect to the mathml stuff. [Bug 572483].
• Pedro Fragoso
  • Clean up glib includes. [Bug 564021].

Availability

http://ftp.gnome.org/pub/GNOME/sources/gnumeric/1.9/ http://ftp.gnome.org/pub/GNOME/sources/goffice/0.7/