Project Release Information
Calculates residuals when using the regression tool.
Permits data entry by-passing autocorrection. Works around OpenOffice date formatting bugs. ODF import and export fixes. Adds EEK support to EURO and EUROCONVERT. Fixes locale-specific sorting, advanced filter, documentation of ATAN2, arrows and line object position when zoomed, series lines color export to .xls, sheet objects position on zoomed sheets, an array intersection problem with IF, a number-match issue regarding fraction, and problems with pivot reading from XLS. Allows version-agnostic template files.
Significantly improved chart export and import to/from ODF. Improved handling of corrupted ODF files. Fixes: percentage style import from ODF, INTERPOLATION documentation, button sensitivity in the sort dialog,
some interpolation and periodogram issues, graph scalar data editor behavior, some confusion of char vs. xmlChar, elapsed-time entry, problems with limits for date axes, and errors in function docs. An improved warnings dialog in ODF import. Importer leaks plugged: sylk, XML, and ODF. This release extends the domain of IMPOWER. It allows the use of glib's memory profiler, and improves the function docs self-test.
Function improvements: ACCRINT, SERIESSUM, LINEST, LOGEST, LOGREG, GEOMDIST, SFTEST, RANDLEVY. FORECAST, GROWTH, and BINOM.DIST.RANGE. STEYX. The addition of Wilcoxon Signed Rank Test tools for one and two populations. A redesigned define-named-expressions dialog. A paste-names dialog. A search tool for paste- and define-names dialogs. Fixes for tests for homogeneity and independence for non-square tables.
Checks with the user before hiding all rows or columns or before pasting too many copies. Fixes for multi-line item edit selection. An evaluation leak has been plugged. Memory handling issue for dependents have been fixed.
The Wilcoxon-Mann-Whitney test tool was added. An stf crash was fixed. The solver model type now persists. A non-linear solver was added. The code was changed according to GTK+ deprecation changes. A Win32/paradox problem was fixed. The page setup dialog was improved.
Fixes and improvements were made to the CHITEST, ACCRINT, WEEKNUM, and IMPOWER functions. Advanced Filter fixes and improvements were made. A problem loading cells with empty strings was fixed. xls-save problems with custom autofilters were fixed. Hidden-sheet, auto-expr, auto-filter, parsing complex numbers, sheet duplicate bugs, and an old graph problem were fixed. Graph only sheets were implemented. Date and time are imported from and exported to ODF. Keyboard navigation was improved. Error handling for complex functions was improved. Chart title import was fixed when Excel automagically uses the unique series label. Multiple and block selection are allowed for graph vector data.
Gnumeric is a powerful and easy to use spreadsheet using GNOME. Its goal is to provide a full featured spreadsheet and a smooth migration path for people and organizations currently using proprietary applications. It provides more sheet functions and greatly improved accuracy when compared to Microsoft's Excel. A plugin system lets you extend Gnumeric, adding functions, I/O formats, and real time data capabilities. The existing Python, Guile, and Perl plugins let you define complex functions. Gnumeric is capable of reading and writing MS Excel (XLS and Office Open XML), and reading Lotus, Applix, Quattro Pro, OpenCalc (ODF), XBase, DIF, SYLK, HTML, Psion, MPS, oleo, sc, misc. text formats, and its native XML. It can also generate Latex, HTML, and others.