Gnumeric 1.5.1 Released

Free, Fast, Accurate -- Pick Any Three!

We are pleased to announce Gnumeric 1.5.1, the first development release after the GOffice reverse merger. Highlights of fixes:

• A long-standing hang problem when exiting the Gnome session with an iconized Gnumeric was fixed.
• A new plugin with statistical functions using the same calling conventions as The R Project was created. (The actual code is not a 100% match, though.)
• Lots of Win32 improvements.
• Clipboard support for images.
• Accuracy improvements for extreme-value cases of statistical functions.

You will need the newest versions of Libgsf and GOffice (released concurrently) for this version of Gnumeric.

Recently, an article compared OO-calc, Gnumeric, and KSpread. The stated aim was to compare the programs for the tasks that the majority of office users would encounter, but it would appear that the author is not a spreadsheet user at all; I cannot think of any other reason for leaving out, for example, Excel compatibility from the test. Further comments here.

Lots and lots of things have changed:

• Andreas
  • Make ROUNDDOWN and ROUNDUP MSExcel compatible including the strange handling for negative numbers. [Bug 162682]
    This breaks backwards compatibility to earlier Gnumeric versions for these functions.
  • Fix text colour in selected item in sheet manage dialog. [Bug 170462].
  • Fix NORMDIST description. [Bug 167467].
• David J Craigon
  • Allow ssimport to specify importer. [Bug 160069].
• Ivan Wong
  • Fix image filtering for Win32. [Bug 164589].
  • Implement the Win32 registry connection.
• Jody
  • Major re-org for goffice split.
  • Fix xls import for fit to page.
  • Fix OFFSET for asymmetric ranges [Bug 166764].
  • Fix SUMIF for asymmetric ranges [Bug 166769].
  • Import sheet visibility from ms excel.
  • Split function docs into a distinct catalog.
  • Decrease memory usage in clipboard.
  • Simplify tiling when pasting a copy. [Bug 87477].
  • Be more flexible pasting full cols/rows in single cells. [Bug 87528].
  • Add vertical alignment DISTRIBUTED.
  • Fix xls in/out of rotation.
• Jon Kaare
  • Don't crash on csv file with invalid unicode [Bug 167190].
  • Import html hyperlinks as hyperlinks.
  • Fix session management bug when gnumeric is minimized. [Bug 166769].
  • Paste images from clipboard.
  • Copy images and graphs to clipboard.
  • Receive and send images by drag and drop.
  • Don't clear clipboard when losing primary selection. [Bug 300468].
• Kasal
  • Modified the way generated files are handled by Automake.
  • Some configure hacks to support po-functions.
• Morten
  • Work around Pango bug causing XL save crash. [Bug 166532].
  • Fix Save-As GUI problem causing CRITICALs.
  • Fix typos that managed to get their own bugzilla entries. [Bug 167495] [Bug 302306].
  • Improve auto-detection of separators for text files. [Bug 167449].
  • Fix some #decimals problems with print page setup.
  • Fix saving.
  • Fix crash when using --quit. Fix leak too.
  • Fix rare crash on exit.
  • Use unicode minus (U2212) for numbers. [Bug 168467].
  • Improve format selection dialog for text import.
  • Constification.
  • Use FooCanvas for rotation part of cell format dialog.
  • Get rid of the last direct GnomeCanvas use.
  • Clean up long double configuration.
  • Fix save-as for non-local files. [Bug 170308].
  • Drop gtk+-bug workaround. [Bug 162952].
  • Make sheets even more object-like.
  • Fix parsing problem with names that start out with something that can be parsed as a cell, e.g., "K3P". [Bug 170465].
  • Improve auto-fixup of 1.0.x era non-ASCII Gnumeric files.
  • Fix minor GUI problem with the format page of text import.
  • Create new plugin with R.[DPQ]dist functions using the R Project's naming and calling conventions. Note: this is deliberately not yet in po-whatever. There are tons of autogenerated strings and things need to settle down a bit first.
  • Fix modality issue causing crashes. [Bug 170958].
  • Use a better format for auto expressions.
  • Improve undo description for rich text style changes. [Bug 171637].
  • Don't destroy target file when loading a saver plugin fails. [Bug 168581].
  • Make sure we update our window menu when we create a new view.
  • When we reopen insert->image, start in the directory we were last time. [Bug 143188].
  • Fix conversion problems with stf export. [Bug 126513].
  • Improve text import for strange encodings. [Bug 167191].
  • Rework stf export code and fix crash-on-exit-causing leaks.
  • Do something sensible when exporting dates and times as text. [Bug 128936].
  • Fix uncompressed saving of .xml and .gnumeric (when requested). [Bug 173030].
  • Improve extreme-case evaluation of quantile functions that are computed by root searching, such as =BETAINV(0.52,1e-3,1e6).
  • Improve accuracy of R.QF (and thus FINV).
  • Fix TRIMMEAN.
  • Fix MODE.
  • Allocate some clipboard data in pools.
  • Fix potential save-as crash.
  • Fix spurious criticals. [Bug 301581].
  • Change various sheet things to use an object properties.
  • Plug leaks with moving sheets.
  • Use object properties for much of the {sheet,workbook}-control-gui to sheet linkage.
  • Fix multihead problems with popups.
  • Fix crash for sheet-remove on sheets with local dynamic dependencies.
  • Implement CELL("sheetname", ...).
  • Fix CELL with explicit sheet in the reference.
  • Fix sheet reordering by dragging.
  • Fix various theme related bugs. [Bug 302902] [Bug 302880] [Bug 302882].
  • Fix undo crash in connection with cloning sheets.