Gnumeric 1.5.2 Released

Free, Fast, Accurate -- Pick Any Three!

We are pleased to announce Gnumeric 1.5.2, a development version of the Gnumeric spreadsheet. Highlights:

• Win32 improvements.
• Excel import improvements.
• Linear regression lines in scatter plots.
• Loads of little fixes.

You will need the concurrently released GOffice 0.0.2 and libgsf 1.12.1 in order to compile and run Gnumeric 1.5.2. All dependencies are linked from our download page.

Changes in Gnumeric 1.5.2:

• Andreas
  • permit formula guru to add array functions.
• Ivan
  • (Win32) Fix opening files with non-ascii names when users "open" them in explorer. [Bug 304874].
  • Enable libspeadsheet build.
  • (Win32) Fix the bug that d&d from explorer doesn't work in gnumeric. [Bug 304074].
• Jody
  • Tweak the errors from LOGNORMDIST, CONFIDENCE, STANDARDIZE, and NORMDIST to match MS Excel.
  • After a command refocus controls for the current view. [Bug 165700].
  • Fix 'Begins with' vs 'Ends With' for autofilters.
  • Autofilter string equality is stronger than containment [Bug 172355].
  • Buttons in sheet manager dialog should not strech vertically.
  • Stub for MS Excel's ASC function, which is unncessary in gnumeric.
  • Make range clipping more efficient. [Bug 164950].
  • Fix advanced filter for inputs that do not start at col A. [Bug 165734].
  • Fix xls import of names calling fwd declared names. [Bug 166611].
  • Fix string generation for arrays.
  • Don't hide columns < 4pts wide on import. [Bug 304558].
  • Rich content from MS Excel clipboard [Bug 305405].
  • Fix warning while importing pre XL-95.
  • Fix adjustment object handling [Bug 167584].
  • Be more careful what we assume is a header [Bug 165061].
  • Use sheet specific print settings when printing a workbook. [Bug 163589].
  • Fix small positioning glitch when creating widgets. [Bug 304559].
  • re-enable experimental sax importer after goffice split.
  • Improve handling of some odd XL operators.
  • Remove warning when nudging during object creation. [Bug 164779].
  • Delete while editing should not clear the cell. [Bug 165172].
  • R1C1 support.
• Jon Kaare
  • Don't output the xml declaration for xhtml. [Bug 303827].
• Michal Kaukic
  • Fix solver for affine objective functions. [Bug 171025].
• Morten
  • Fix SUMIF even more. [Debian Bug 308346].
  • Fix horizonal alignment of rotated numbers broken by fix to Bug 303292.
  • Fix CRITICAL when undoing borders.
  • Improve multiline rotated text. [Bug 167544].
  • Fix Excel load crash. [Bug 303923].
  • Speed up exit on large sheets with lots of names, such as the one from Bug 303923.
  • Clean up dependencies somewhat.
  • Simplify expressions used for defined names for single cells.
  • Fix redo crash. [Bug 305007].
  • Fix auto-complete deactivation issues. [Bug 305011].
  • Fix recognition of accounting formats. [Bug 305314].
  • Fix unintentional format currency change. [Bug 305313].
  • Plug leaks.
  • Work hard at not leaving passwords in memory, just in case.
  • Add tooltips for ok_button, cancel_button, and func_button. [Bug 160344].
  • Fix paste problem. [Bug 305404].
  • Fix brown bag text import problem. [Later reported as Bug 305624].
  • Improve R.QPOIS accuracy, efficiency, and termination.
  • Improve R.QNORM's accuracy in the long double case.
  • Improve R.QCAUCHY's accuracy.
  • Add new R.QHYPER function.
  • Fix xml SAX import issue for array formulae.
  • Fix xml export of shared array formulae.
  • Fix number matching problem. [Bug 306254].
  • Fix R.PBETA screwup for log case.
  • Fix problem with hiding sheets.
  • Fix sheet removal undo to also undo changes to names and cells in other sheets.
  • Save and load visibility sheet attribute.
  • Fix 3D deps crash.
  • Fix 3D dependencies spanning more than one sheet. (I.e., all.).
  • Fix dynamic dependency crash on exit.
  • Plug leaks of sheet views.
  • Fix CRITICAL in the "manage sheets" dialog.

Changes in GOffice 0.0.2:

• Emmanuel Pacaud
  • Make compass position and alignment of graph object persistent and add a GUI for these properties [Bug 124322].
  • Fix some libglade warnings [Bug 305010].
  • Fix contour plots axes.
• Ivan, Y.C. Wong
  • Fix encoding bug when open file with non-ascii name in shell.
  • Fix Mime Type detection on Win32 [Bug 304074].
• Jean Brefort
  • Add linear regressions in scatter plots.
  • Fix shotcut in format selector [Bug 305635].
  • Add MinMax and DropBar plots.
  • Fixed various concerns in contour plots.
• J.H.M. Dassen (Ray)
  • Ensure at link time that the shared objects, both the library and the plugins, contain complete dependency information for all symbols they use from elsewhere.
• Jody
  • Fix foocanvas's show/hide item for widgets.
  • Fix the format selector preview.
  • Improve selection of a default plot style.
• Morten
  • Fix theme bug. [Bug 303707].
  • Fix insert-image criticals. [Bug 305009].

Fixes in libgsf 1.12.1:

• Dom
  • Better handling of error conditions when creating a zip.
• Jody
  • Patch a leak in vector properties from OLE2.
  • Be more delicate handling truncated gzip files.
  • Improve utility macros for dynamic type creation (incompatible).
  • Make constructors for output_stdio outfile_stdio more flexible.
• Morten
  • Fix gsf_xml_out_add_float to always use "." as separator.
  • Fix problem with creating new files in g+s directories.

--Morten