Gnumeric 1.7.0 aka "Shaken Stick" is now available.

Note to packagers: If you store supported mimetypes anywhere other than gnumeric.desktop you will need to resync.

• Andreas
  • Fix lost minus signs in latex output. [Bug 325656].
  • Add has-header preference to the sort preferences. [Bug 327278].
  • Fix sort dialog crash. [329236].
  • Make sort dialog range entry sensitive to keyboard entry. [Bug 329250].
• Harun Vos
  • Fix Win32 crash-on-start for pre-WinXP.
• Ivan, Y.C. Wong
  • Fix Gdk-WARNING when cutting or copying cells. [Bug 314210].
  • No more debug command prompt.
  • Error/warning messages will go to an existing command prompt (if any).
• Jody
  • Handle the special case of ADDRESS (r1c1) actually relative.
  • Make sheet name quoting modular.
  • AREAS handles error conditions better.
  • Make Array formulas use less memory.
  • Fix xls import of optimized CHOOSE.
  • Dup sheet props when duping a sheet.
  • Adding an autofilter dirties the sheet.
  • Move Workbook::uri and ::dirty into GODoc.
  • Handle inconsistency with XL's model of vararg eval. [Bug 336212].
  • Export underlines to html.
  • handle ctrl/shift space during rangeselection.
  • Fix path to docs. [Bug 330339].
  • Handle canceling object drag motion. [Bug 314866].
  • Fix image drags with previously selected objects.
  • Handle oddness in xls files generated by 'miniCalc' [Bug 336858].
  • Do not make backgrounds for xl95 charts transparent.
  • Basic import and export for MS Office 12 (beta1) files.
  • xls import optimization for shared strings.
  • Install the headers for libspreadsheet. [Bug 332218].
  • Enable ODF metadata import.
  • Fix ODF import of underlines.
  • Fix ODF import of sheets with quoted names.
  • Enable ODF import of hidden rows/cols.
  • Fix ODF import of col/row cell default styles.
• Klokan Pridal
  • Implement xml saving/loading of "protected" attribute. [Bug 334257].
  • Implement xls saving/loading of "protected" attribute. [Bug 330129].
• Luciano Miguel Wolf
  • ODS import improvements.
• Morten
  • Fix COUNTBLANK.
  • Fix auto-filter formatting issue. [Bug 322392].
  • Fix ATAN2(0,0).
  • Make AND, OR, and XOR ignore strings as claimed.
  • Fix TRIM for non-ASCII case with spaces at end.
  • Fix TYPE crash. [Bug 323128].
  • Plug leak.
  • Fix sheet quoting problem. [Bug 323546].
  • Improve Excel compatibility of BIN2DEC, BIN2HEX, and BIN2OCT. [Bug 323787].
  • Fix crash on xml load. [Bug 323888].
  • Fix file corruption on saving scenarios. [Bug 323927].
  • Fix a pile of leaks in solver and scenario saving and loading.
  • Fix leaks in solver dialog.
  • Fix parser leak. [Bug 301127].
  • Fix NetBSD compilation. [Bug 324358].
  • Fix solver dialog crash. [Bug 324585].
  • Fix FMR in SUBSTITUTE.
  • Fix REPLACE and SEARCH for non-ASCII strings.
  • Fix division-by-zero problems in FIXED, ROUND, ROUNDUP, ROUNDDOWN, TRUNC.
  • Fix accuracy of ROUND, ROUNDUP, ROUNDDOWN, TRUNC.
  • Fix out-of-memory problem in REPT.
  • Fix lots of little XL compatibility problems in string functions.
  • Fix error on Search-and-replace.
  • Improve handling of boolean args for "R" functions.
  • Fix near-infinite loop in FACTDOUBLE.
  • Fix text-to-columns crash probably affecting stf import too.
  • Fix font preference crash. [Bug 326830].
  • Fix memory allocation problem for writing charts.
  • Fix loading of boolean constants from ods files.
  • Fix MID for out-of-bounds values.
  • Fix constructed-range parsing for OO.
  • Improve .desktop file. [Bug 328015].
  • Make expressions use less memory by merging ref_count and operator fields.
  • Split expression memory pool into one for large and one for small nodes.
  • Fix SECOND, MINUTE, HOUR compatibility problems.
  • Fix DATE compatibility for bizarre input.
  • Cleanup parameter handling in financial functions.
  • Fix parsing problem with underscores in sheet names. [Bug 329236].
  • Fix LCM and GCD for large arguments.
  • Switch gnumeric option handling to GOption.
  • Switch ssconvert option handling to GOption. [Bug 154395].
  • Switch ssindex option handling to GOption. [Bug 154395].
  • Fix problem with solver error message translation.
  • Expand the range of certain random number functions.
  • Fix large-argument cases for BITOR, BITAND, BITXOR, BITLSHIFT, and BITRSHIFT.
  • Redo string-to-value parsing.
  • Allow "12Dec2001" for date entry. [Bug 56168].
  • Allow "20041231:103355".
  • Fix bogus duplicate-accelerator warnings. [Bug 324692].
  • Fix criticals relating to toolbar combos for very narrow windows. [Bug 162498].
  • Allow vertical toolbars.
  • Save a bit of memory for function calls.
  • Fix type confusing in mps importer.
  • Greatly reduce the use of the type-unsafe GnmExprList.
  • Use argc/argv form for sheet function taking uneval'd args.
  • Fix expression creation and leaks in mps importer.
  • Use toolbuttons for edit-line buttons. [Bug 331916].
  • Go to end of text on F2. [Bug 319311].
  • Let GtkNotebook handle hidden sheets by using hidden tabs.
  • Fix updates of tab colours.
  • Make Workbook a little more like a proper GObject.
  • Rework "dirty" handling for sheets and workbooks.
  • Fix 64-bit problem for xls save.
  • Fix printing issue when sheet is zoomed. [Bug 332932].
  • Fix dbf import issue. [Bug 332878].
  • Fix menu feedback when replacing a pristine workbook by a file.
  • Fix stf text import speed regression. [Bug 333407].
  • Fix XIRR issues. [Bug 333620] [Bug 333631].
  • Fix autofilter for text that looks like numbers. [Bug 333809].
  • Plug leak in SEARCH.
  • Fix printing issue with wrapped, right-aligned text. [Bug 334144].
  • Introduce top-level expressions.
  • Eliminate ref-counting at the sub-expression level.
  • Plug leaks in preferences dialog.
  • Make CORREL, COVAR, RSQ, SLOPE, and INTERCEPT really ignore blanks. [Bug 334591].
  • Fix DOLLARDE and DOLLARFR.
  • Resurrect the ability to name external workbooks by filename, including relative filename. (But things still expand to URIs.).
  • Improve Excel compatibility for ROMAN and COMBIN in extreme cases.
  • Fix sheet object deletion crash. [Bug 335052].
  • Make ISPRIME and PFACTOR work for much larger numbers.
  • Fix border case for iterative evaluation.
  • Display and xml-save inter-workbook references using relative URIs. [Bug 334724].
  • Fix theming problem. [Bug 309060].
  • Fix validation problems. [Bug 114086].
  • Fix validation handling of errors/strings/booleans.
  • Implement WORKDAY.
  • Improve Excel compatibility for EDATE and EOMONTH in extreme cases.
  • Fix EVEN and ODD for very large numbers.
  • Fix sheet-manage dialog crash. [Bug 336165].
  • Reimplement autofill.
  • Fix xls export of data tables.
  • Fix xls export for intersections.
  • Fix parser crash for ={-TRUE}.
  • Get rid of integer/float split.
  • Allow ={+42}.
  • Fix copy-and-paste problem between gnumeric instances. [Bug 337215].
  • Improve handling of strings that look like numbers or expressions during search-and-replace. [Bug 167304].
  • Fix rendering problems for values with attached formats.
  • Fix button ordering on Win32. [Bug 170479].
  • Fix rendering on fractions that round to 0. [Bug 314210].
  • Add undo handling to deletion of names. Fix recalc are removing or defining names. [Bug 312610].
  • Improve editing of cells containing currency amounts, fractions, or percentages.
  • Improve 1-2-3 import for Chinese files. [Bug 337968].
  • Fix 1-2-3 format handling.
  • Fix parsing of "4/2005". [Bug 166413].
  • Fix initial sheet selection in the sheet-manage dialog. [Bug 331984].
  • Make autofill understand 3Q01, 4Q01, 1Q02, ... [Bug 61650].
  • Make autofill understand Apr, Jul, Oct, Jan, ... (and other skip-N sequences, with or without year.).
  • Make autofill fit columns.
  • Fix sorting undo problem. [Bug 161890].
  • Add locale choice on text export. [Bug 123339].
  • Remove stray "Back" button for text export's one-sheet case.
  • Fix elusive sheet tab tracking bug after we replaced the initial pristine workbook by a newly loaded one.
  • Fix GUI inconsistency for text import. [Bug 338694].
  • Fix crash on save+quit. [Bug 338847].
  • Auto-fit width when entering new values or formulas.
  • Auto-fit height when entering string constants.
  • Fix fits for wrapped text. [Bug 67351].
  • Fix minor undo problem for applying a height-changing format.
  • When undoing or redoing, move to where things happen. [Bug 114077, Bug 154705].
  • Add tooltips to a few combos. [Bug 339122].
  • Improve stf import format guessing. [Bug 332997].
  • Improve stf import for sloppy clumps of whitespace. [Bug 339297].
  • Improve stf import's keyboard navigation.
  • Fix applix import issue. [Bug 339190].
  • Fix critical. [Bug 339793].
  • Make "General" format pixel-perfect.
  • Fix zoomed rendering issue. [Bug 310492].
  • Warn for confusing text-formatted-non-string situation. [Bug 339834].
  • Fix filling of text formatted as non-general.
  • Fix printing problem for cells that haven't been displayed.
  • Fix critical on exit for --debug=1.
  • Display tooltips during autofill. [Bug 51272].
• Jon Kaare
  • Hand clipboard off to clipboard manager when exiting.
  • Handle non breaking space in html input.
  • Handle .xls containing html fragment [Bug 311879].
• Nick Lamb
  • Fix CONVERT crash. [Bug 323678].
• Philo Vivero
  • New loan template. [Bug 317201].

Goffice 0.3.0 is now available.

• Emmanuel Pacaud
  • Add initial support for moving objects by mouse.
  • Add a resolution setting in image export file chooser.
  • Add support for PDF and PS export of graphs when using cairo renderer.
  • Add gtk-doc support.
  • Improve legend layout by making swatch size proptional to font size.
  • Improve dialog for manual position of dialog.
  • Fix baseline for area plot and histogram when using a log axis.
  • Implement stretched image pattern in cairo renderer.
  • Fix axis label position.
  • Improve scientific format, add an engineering mode and a special format with markup for display of exponent as superscript (e.g. 10²) (Currently only used by graph engine when using cairo renderer).
• Ivan Wong
  • [Win32] Only export symbols which are in the public headers. [Bug 307356].
• Jean Brefort
  • Add a new components system to embed data from other applications.
  • Add Histograms.
  • Add regression curves to histograms and line plots.
  • Add power regressions.
  • Add moving average trend curves.
  • Fix use of invalid data in scatter plots. [Bug 334697].
• Jody
  • Some cleanup towards supporting --without-gtk.
• Morten
  • Fix translation problems causing crashes in the character set selector for people not using UTF-8.
  • Add and fix gog-object preconditions. [Part of Bug 321678].
  • Handle problem with fraction formats for very large values. [Debian 340463].
  • Fix problem with colons in filenames. [Bug 322799].
  • Use system libpcre when available, sufficiently recent, and properly compiled with UTF-8 support.
  • Plug leak.
  • Handle problems with formats containing "ss." but no more.
  • Fix plugin deactivation. [Bug 336742].
  • Improve fraction format handling.
  • Fix format problem for [$curr].
  • Implement tooltips for text combos. [Bug 339122].

Availability

http://ftp.gnome.org/pub/GNOME/sources/gnumeric/1.7/