Gnumeric 1.11.3 - Changelog

What's new in Gnumeric 1.10.17:

August 1st, 2011

Andreas:
· Fix some style import from ODF. [#652492]
· Import/Export print formatting from/to ODF. [#653186]
· Write and read some document properties to and from XLSX.
· Fix xlsx schema violations.
· Fix keyword handling in properties dialog. [#653378]
· Allow document properties to be edited and added.
· Add an interface for conditional styles.
· Fix ODF import of styles with inherited conditional styles. [#654214]
· Provide undo for cut between 2 gnumeric processes. [#640922]
· Fix bar and column chart import/export to ODF.
· Speed up frequent calls to INTERPOLATION with the same
· abscissae/ordinates. [#654538]Export defined names to xlsx. [#655010]
· Implement printing of errors as blanks, dashes or NAs.
· Fix printing of column headers and borders when formulae are shown. [#655389]
· Fix import of Excel 2003 xml files in non-C locale. [#655554]

Jean:
· Fix selection background. [#648676]

Morten:
· Fix --with-gnome compilation: [#652802]
· Fix parsing crash. [Redhat #726860]

What's new in Gnumeric 1.10.13:

February 3rd, 2011

· Andreas
· Calculate residuals when using the regression tool. [Bug 635064].
· Permit data entry by-passing autocorrection.
· Work around OpenOffice date formatting bugs. [Bug 636131].
· Export text formats to and import from ODF. [Bug 636158].
· Fix ODF import of sheets with far forward references. [Bug 636968].
· Add EEK support to EURO and EUROCONVERT.
· Fix leaks in potentially failing analysis tools.
· Make the row and column headers and selection match the theme better. [Bug 639019].
· Fix locale specific sorting. [Bug 638874].
· Ensure we have sub- and superscript icons. [Bug 639086].
· Fix advanced filter. [Bug 639444].
· Suppress function tooltips on text-formatted cells. [Bug 638832].
· Fix documentation of ATAN2. [Bug 640344].

· # Jean
· Only disable the formula bar when a chart sheet is selected. [Bug 636031].
· Make sheet objects invisible outline from .xls files persistent. [Bug 637393].
· Fixed arrows and line object position when zoomed. [Bug 637453].
· Fixed series lines color export to .xls. [Bug 637658].
· Fixed sheet objects position on zoomed sheets. [Bug 637739].
· Override edition-canceled property for GnmExprEntry. [Bug 639287].

· # Morten
· Fix array intersection problem with IF. [Bug 633433].
· Make sure columns are wide enough for dates in csv import.
· Plug a few leaks.
· Fix number-match issue regarding fraction.
· Fix problems with pivot reading from xls. [Bug 638776].
· Allow version-agnostic template files. [Bug 630247].

What's new in Gnumeric 1.10.12:

November 26th, 2010

Andreas:
· Add argument to FOURIER to separate parts.
· Extend TREND function to handle multiple regression. [#630085]
· Fix selection for sheet object lists and combos. [#631322]
· Preserve selection for sheet object lists when we change content. [#631327]
· Add option to sheet object lists and combos to enter values rather than index. [#629333]
· Fix manual pagebreak handling when printing. [#631570]
· Add menu items to remove and add manual page breaks.
· Improve the sc import.
· Fix button sensitivity in sort dialog. [#632999]
· Fix ODF export of files with large formatted sheets. [#634135]
· Fix extensions of supported ODF files. [#635111]

Hans de Goede:
· Fix import of dib format images in XLS. [#553098]

Jean:
· Fixed maximum for col/row number in sheet resize dialog. [#631702]
· Eliminate glade usage. [#631717]
· Fixed crash in print setup. [#634149]
· Fixed image bounds in zoomed sheets.

Morten:
· Fix crash related to broken xls. [#632050]
· Fix print area problem from broken xls.
· Fix printing crash. [#632439]
· Partially fix problem with undefined names. [#633140]
· Fix analysis tools problems when "as values" is chosen.
· Fix gtk+/X crash with large tooltips.
· Take care of dead kittens.
· Fix text object clipping issue. [#634597]
· Fix problem with disappearing window for empty file. [#634792]
· Fix ranges-in-expression criticals.

Sameer Morar:
· Add key combinations to move sheets. [#634139]
· Modify quit dialog to be able to discard multiple files without saving. [#527133]

What's new in Gnumeric 1.10.10:

September 6th, 2010

Andreas:
· Significantly improve chart export and import to/from ODF.
· Improve handling of corrupted ODF files.
· Fix percentage style import from ODF. [#627517]
· Fix INTERPOLATION documentation. [#627461]
· Provide progress info in ODF export.
· Improve warnings dialog in ODF import.
· Fix button sensitivity in sort dialog.

Jean:
· Fix some interpolation and periodogram issues.
· Fixed graph scalar data editor behavior. [#628721]

Morten:
· Plug sylk importer leak.
· Plug xml importer leak.
· Plug odf importer leak. [#627759]
· Extend domain of IMPOWER. [#627775]
· Allow use of glib's memory profiler.
· Fix some confusion of char vs. xmlChar.
· Fix elapsed-time entry. [#628082]
· Fix problems with limits for date axes.
· Improve function docs self test.
· Fix errors in function docs.

What's new in Gnumeric 1.10.8:

July 31st, 2010

Andreas:
· Add new Excel and Openformula units ("pica" and "picapt") to CONVERT.
· Save default search settings. [#105615][#625185]
· Improve configurable text export of numbers. [#126444]
· Improve horizontal fill. [#594193]
· Improve function syntax tooltips. [#623317]
· Add weekend specifier to WORKDAY and NETWORKDAYS. [#172458]
· Fix ngettext usage.
· Fix undo text for sheet object duplication. [#623557]
· Fix additional undo entry for sheet object duplication. [#623559]
· Fix undo of object creation followed by duplication. [#623566]
· Avoid creating interacting auto filters. [#607086]
· Improve items of the cell context menu. [#74359]
· Fix various function docs issues. [#623669][#624559][#625102]
· Improve the presentation of the examples in the function documentation. [#623455]
· Fix HDATE and friends. [#623764][#625177]
· New functions DATE2HDATE, DATE2HDATE_HEB and DATE2JULIAN.
· Add hyperlink and comment removal menu items.
· Add merge and unmerge menu items.
· Add menu item to autofit column width or row height based on the selection only. [#125595]
· Add autofit actions to cell context menu.
· Add new function ARRAY. [#570689]
· Add new function SORT. [#59144]
· Add menu item to wrap SORT around an existing range.
· Show the number of rows filtered by the auto filter. [#346002]
· Improve function tooltips. [#623322]
· Improve expression entry range selection. [#80725][#624288][#624289][#624581]
· Add preference setting to disable the extension check for the configurable text exporter. [#594151]
· Add optional marker to indicate that a cell contains an expression. [#55124]
· Add merge and unmerge items to the cell context menu.
· Permit double-clicking of functions in the function selector.
· Allow single merge to single merge copying. [#87296]
· Make the font style buttons override the character attributes. [#163410]
· Provide name completion (F4) when entering functions. [#587084]
· Implement access to the function selector to paste function names while editing cells (Shift-F4).
· Add preference settings whether to show function name and/or argument tooltips.
· Fix undo of Clear->All and Clear->Comments. [#625151][#623803]
· Add menu items to allow clearing of filtered rows only.
· Fix editing of hyperlinks.
· Work around OOo's failure to correctly define its named ranges. [#625332]
· Remove range hightlighting while not editing expressions. [#625361]
· Reduce the size of the text import dialog. [#625281]
· Fix import of underlined/double underlined comments from xls. Part of [#405951]
· Improve xl import of underlines.
· Correctly size the autoexpressions. [#625521]
· Fix row height dialog. [#625543]
· Add menu to specify whether to enter as array, into multiple cells, etc. Part of [#53733]
· Make autofilter condition changes undoable. [#625143]

Jean:
· Fix strong/weak cursor display. [#623241]
· Fix regression in ms_excel_chart_read. [#623960]
· Fix a regression in chart series evaluation. [#624263]
· Fix crash in cell_calc_span. [#624274]
· Install a self-consistent headers list.
· Fixed borders display in cell format dialog.

Morten:
· Ask user to locate solver binaries when plain search fails. [#619519]
· Fix problem with solver target cell entry.
· Fix date function docs issues. [#623669]
· Fix gtk_show_uri problem affecting win32. [#623605]
· Fix mistakes pointed out by sparse.
· Fix win32 versioning problem. [#624171]
· Improve function doc checks.
· Eliminate almost all remnaining GdkGC usage.

What's new in Gnumeric 1.10.5:

May 31st, 2010

Andreas:
· Add Wilcoxon-Mann-Whitney test tool.

Morten:
· Fix stf crash. [#619283]
· Persist solver model type.
· Add non-linear solver. [#614865]
· Feed the gtk+ deprecation monster. [#572240]
· Fix win32/paradox problem. [#619942]

Sameer Morar:
· Improve page setup dialog. [#619421]

What's new in Gnumeric 1.10.2:

April 17th, 2010

· Some documentation updates
· Fix build with --disable-solver. [#612820]
· Fix column and row header display under Quartz. [#600085]
· Fix preferences in gconf-less situations. [#613523]
· Implement first letter capitalization. [#613768]
· Extend regression tool to perform multiple simple regressions. [#614031]
· Fix ZTEST description. [#614746]
· Don't write unnecessary manifest entries in ODF export.
· Various ODF export fixes.
· Adjust regression tool to reflect the changes to TDIST.
· Basic import and export of text boxes from ODF files.
· Watch for the null date in OOXML import. [#615777]
· Write the null date in OOXML export.
· Print pattern backgrounds. [#615365]
· Improve object sizing tooltip positioning a bit.
· Fix filter critical. [#611073]
· Make more menu entries available when an object is selected.
· Improve partitioning of status area.
· Fix goal seek problem affecting XIRR. [#614147]
· Fix export xls of XIRR, FVSCHEDULE, and XNPV. [#614257]
· Set win32 stack size to 64M. [#571346]
· Patch gtk+ so GtkEntry widgets on win32 draw right. [#603667]
· Fix xls export of cell comments. [#615845]
· Fix error propagation problem. [#615772]
· Partially clean up INDEX implementation.
· Make regression functions return a result when goffice reports that the problem is near singular, but still good.

What's new in Gnumeric 1.10.1:

March 9th, 2010

· This is a bug-fix release.

What's new in Gnumeric 1.9.9:

September 14th, 2009

· This release fixes scrolling via mouse wheels.
· It improves ODF import and export, XLS/XLSX import, text import and export, and HTML export.
· It improves tools (2 factor ANOVA, Rank & Percentiles, and Fourier transform).
· New functions: FOURIER, COT, ACOT, GD, COTH, and ACOTH.
· It fixes the functions NPER, GCD, FIXED, and IF.
· It breaks GnmCommand out to allow commands in multiple files.
· It adds search-for-number.
· It fixes the format-as-currency action.
· It fixes increase/decrease precision for accounting formats.
· It has better handling of x^y^z.
· It implements new-from-template.
· It starts introducing external references for function documentation.
· It fixes TSA crashes.

What's new in Gnumeric 1.9.8:

September 14th, 2009

· Saves and loads text formatting of comments and sheet object labels.
· Improvements to the ODF exporter, ODF importer, and XLSX exporter.
· Closer to a turnkey Win32 build.
· fn-lookup caches are pruned in case someone is being silly.
· Respects the sheet size prefs for new blank workbooks.
· Caches large ranges, possibly sorted.
· Makes it possible to have horizontal widgets too.
· Fixes a sheet-object paste crash, a critical error in the format dialog, date conventions in graphs, and R1C1 issues.
· The GUI for date/time axes is improved.
· ssconvert has been extended to also merge multiple sheets.

What's new in Gnumeric 1.9.7:

September 14th, 2009

· An interface to format cell comments was added.
· Meta data is loaded from gnumeric files.
· rendr_value no longer crashes for NULL values.
· The use of builtin formats was enabled for XL2003-XML, and the ".sml" kludge was dropped.
· A preference entry was added to set the default value of autosave.
· Numerous load, export, and crash fixes were made.

What's new in Gnumeric 1.9.6:

September 14th, 2009

· Sheet sizes are now variable.
· Sheet sizes are shown in the manage sheet dialog.
· Metadata is written from the property dialog to the files.
· The list sheet object configuration dialog is complete.
· All sheet object configurations were made undoable.
· Text in the sheet object label is printed.
· Editing of a sheet object label was implement.
· More 2003-spreadsheetml formats are supported.
· Elapsed time formats are handled better on text export.
· XIRR was improved a bit. Applix, Lotus, XLS, and mps loading crashes were fixed.
· Sheet object, str.h usage was cleaned up.
· CSV and txt files are loaded into sheets as big as needed.
· A validation problem was fixed.
· The code was moved to libgda4.