Gnumeric 1.0.4
Andreas:
* Fix LaTeX and HTML exporter crashes
http://bugzilla.gnome.org/show_bug.cgi?id=69832
* crash in goalseek
Jody:
* Crash importing scrollbars from xml.
* Fix regression in 1.0.3 setting properties for checkbox.
* xml-sax support for v10 of gnumeric's format.
* Consistently list Column actions before Row actions.
* Crash importing 3d references to external workbooks.
http://bugzilla.gnome.org/show_bug.cgi?id=69400
* Slow sort dialog startup.
http://bugzilla.gnome.org/show_bug.cgi?id=69577
* number matching broken in some locales.
http://bugzilla.gnome.org/show_bug.cgi?id=69795
* Dont put non ascii characters in the translated source.
http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=131561
* Don't confuse the calling context with the view to save.
Jon Kåre:
* Improve scrolling alignment of formula guru.
--------------------------------------------------------------------------
Gnumeric 1.0.3
Andreas:
* Redo COUP_ functions one more time, ignoring XL.
* Fix expression entry widget
* Preload selections in analysis tools
Jakub Steiner:
* Update the icon.
Jody:
* Enable Add/Delete Series for Graph Guru.
* Improve usability of Graph Guru data selectors.
* More work on XL import for 3d references.
* Import checkbox links from XL.
* Add scrollbars and import them from XL.
* Update the xml schema.
* Small optimization to shrink xml in .gnumeric files.
* Polish the sheet object editing.
Morten:
* New tabulation tool.
Neil Booth:
* Document the Black-Scholes routines.
Wayne Schuller:
* Audit the dialogs for accelerators.
--------------------------------------------------------------------------
Gnumeric 1.0.2
Andreas:
* Add `autofit columns' checkbox to all analysis tools.
* Add radio buttons to rank dialog to let user choose
behaviour in case of ties.
* Enable Standard Errors Checkbox in Moving Averages Dialog.
* Implement calculated bins in Histogram Tool.
* Implement Fourier Analysis Tool.
* Updated documentation.
* Fixed COUPNCD.
* Complete implementation of COUPDAYSCD
* Implement COUPPCD.
* Implement COUPDAYBS.
* Implement COUPDAYS.
Jody:
* Generate spans after importing a lotus 123 file.
* Add Russian Ruble.
* Improve Data Validation, and add XL import.
* Add new builtin format to Applix importer.
* Fix AREA_3D expressions from Excel.
* Display and import coloured tabs from Excel XP.
* Fix displayed cursor when leaving a sheet object.
* Improve goto box to support names, and inter-sheet jumps.
* Support inter-sheet references in the goal seek.
* Handle totally hidden merges at freeze bound.
* Improve XL import for 3d references.
* Try REALLY hard to find an expression in xml not
marked as being a value.
Jon Kåre:
* Added WEEKNUM and ISOWEEKNUM
Morten:
* Make sure Linux ends up using IEEE_754 code in mathfunc.c.
* Fix search crash.
* Make functions that take numeric arguments accept also strings
that parse as numbers.
* Partly fix ADDRESS.
Neil Booth:
* Handle 1900/Feb/28 the same way MS Excel (tm) does.
--------------------------------------------------------------------------
Gnumeric 1.0.1
Andreas:
* Fix 67878 (help button ref)
* Fix a few ANOVA error messages
* Fix 67289 (PERCENTRANK)
Jody:
* Fix CRASH!! due to last minute translation fix.
* Some missing '...' in menu names
* Rename 'Summary' menu -> 'Properties'
* Support graphs with no data.
* A bit of warning suppression for s390.
* Bump the GAL requirement to 0.16
Morten:
* Added DATE2UNIX and UNIX2DATE.
* Added GETENV.
* Fix WEEKDAY.
J.H.M. Dassen (Ray):
* Lots of bit warning suppression for s390.
--------------------------------------------------------------------------
Gnumeric 1.0.0
Andreas:
* Improve file format documentation
* Fix text colour in html and latex exporters (#67550)
* Fix roff importer (#66457)
Jody:
* Double check that nearest range is not on another sheet.
* Fix undo for range fills with overlapping ranges.
* Do not register commands for pasting a cut onto itself.
* Fix cloning checkboxes.
* Make all openers available on the import menu, just in case.
* Fix sheet objects as inter-sheet dependents.
* Fix undo from keyboard for sheet object deletion.
--------------------------------------------------------------------------
Gnumeric 0.99.1
Andreas:
* Improve documentation incl. analysis tools, files & worksheet
* Implement merges and spans in html exporter
* Make output from HTML4.0 and HTML3.2 exporters validate
* Fix copy multiple cells to single merged cell (#67298)
* Fix expr entry widget: used to fet confised on mouse clicks
(#65894)
Jody:
* Add insert Graph menu item & icon
* Fix Exit icon for bonbo build.
* Delete the CAPS lock feature from autocorrect.
* Fix Chema's sneaky cursor grab.
* Applix import for v4.41, add it to the mime types.
* Inter-Gnumeric pasting support for merges, and shares.
* Fix life cycle of validation styles.
* Undo for pasting a cut was saving too much.
* Parser was not honouring requests to ensure absoluteness.
* Transparent makes no sense for lines & arrows.
* Improve help tokenizer.
* Don't prompt for sheet delete if it is pristine.
* Autofill includes autoformats for expressions.
* Edit position after undoing a merge.
* Partial fix for del col/row undo with dependent objects.
* Support some additional forms of #!REF in XL import.
* Fix importing of graphs with embedded graphs.
* Improve autofill handling of merges & arrays.
* Support pasting transposed merges.
* Ensure that cell sizes never violate absolute minima.
* Fix format leak (thanks Morten)
* Fix data validation.
* Dirty workbook when modifying summary info.
* Invalidate names refering to deleted expressions.
* Fix row height resize when undoing changes to JIT rendering.
Morten:
* Fix DATE.
* Fix a pile of leaks in financial functions.
* Fix COUPNCD, YIELD, PRICE.
* Fix overflow issues.
Wayne Schuller:
* Search and search-replace history persistence.
* Improve documentation: intro and printing
Tino Meinen:
* Make bound errors for INDEX consistent.
--------------------------------------------------------------------------
Gnumeric 0.99.0
Andreas:
* Fix problem in search & search/replace tool #64989
* Permit input from other sheets in Random Number Generator
(discrete distribution), Rank and Percentile Tools and
2-factor ANOVAs
* Check for valid input in Random Number Generator tool
* Fix parsing error in analysis tools expecting sheet references
when none is given
* Fix sheet reference in database function criteria (# 65353 (1))
* Implement -geometry cmd line option
* Fix rank calculation with respect to ties
* Set cell format for percentiles in rank and percentile tool
* Fix crash on copy between different invocations of gnumeric
* Fix search in comments (# 65159)
* Fix crash in parser (# 65896)
* Format all numbers preentered in analysis tools dialogs
according to locale (# 65404)
* In histogram tool add percentage column and format all
percentages appropriately (# 62164)
* Implement text wrap in LaTeX exporter (# 20898)
* Implement math mode in LaTeX exporter (# 63395)
* Use gnumeric column widths in LaTeX exporter
* Implement multirow merges in LaTeX exporter
* Remove default grid in LaTeX exporter
* Implement cell borders in LaTeX exporter
* Fix merged cell to merged cell copy (#65760 & #58691)
* Removed latex209 exporter
* Implement spans in LaTeX exporter
* Improved analysis tools documentation
* Fix bugs (#66433 & #66880 & #66393)
* Fix cellspan bug (#66658)
Jody:
* Tricky corner cases for style applications (Part 2).
* Rework sheetname quoting (Good idea Andreas)
* Support multiple expressions in the parser and clean up
expression lists.
* Memory error when parsing names.
* Fix xml storage of parse position for names.
* sync print code with draw code for merges.
* Fix ins/del col/row in outline mode.
* Support number buttons in outline mode.
* Implement XL export for array formulas.
* Fix handling of failue in filter dialog.
* Remove some dead code.
* Minor etable warning tweak.
* Improve cursor handling for frozen panes.
* Fix sorting with hidden cols/rows before region.
* FIXED now uses the format engine.
* Simplify cell fmt dialog's idea of merges.
* Don't compress file when suffix is .xml.
* Actually put the schema file where we say it is.
* More work on libxml2 compatibility.
* Some simple shared steps towards gnome2.
* Fix autofill crash when shrinking regions.
* Make graph vector header recognition more like XL.
* Fix missing bononbo menu icon for exit.
Morten:
* Fix EXPRESSION crash.
* Fix 65577.
* Fix 66848 (the table of function names in the formula guru
is not alphabetized).
* Sort currencies in cell format's drop-down.
Sultanov Albert:
* http://bugzilla.gnome.org/show_bug.cgi?id=55142
Do charset conversions on summary fields to/from XL.
Toralf Lund:
* http://bugzilla.gnome.org/show_bug.cgi?id=60468
More work on the oleo importer.
Greg Lebalnc:
* Modernize the doc build architecture.
--------------------------------------------------------------------------
Gnumeric 0.76
Alex Barnes:
* Autofill backwards.
Andreas:
* Fix handling of missing observations in F-test, z-test,
one-factor ANOVA, histogram, regression, and t-tests analysis
tools.
* Permit input from other sheets in F-test, z-test, one-factor
ANOVA, histogram, regression, and t-tests analysis tools.
* Fix small errors in F-test, z-test, one-factor
ANOVA, Desc. Stats. and t-tests analysis tools.
* Improve Exponential Smoothing and Moving Averages tools.
* Implement pareto and labels in histogram tool.
* Use confidence level in regression tool.
* Use format parsing in entry fields of analysis tools.
Jody:
* More work on the expr entry.
* Fix outline mode.
* Add keyboard support to sheet objects.
* Add warning when xls imports non-ole file.
* Continue audit and clean out some old code.
* Validate autoformat template before storing undo.
* Fix leaks.
* Fix centering while printing scaled regions.
* Tricky corner cases for style applications.
* Break lines at hyphens to.
* Disable col/row resize while editing.
* Make some dialogs resizable.
* Fix comment placement for merged cells.
* Initial XL import for data validation.
Jukka:
* Improved function documentation.
* Implemented Exponential Smoothing tool.
* Improved COUPDAYSNC().
Morten:
* Leak plugging.
* Fix memory overrun in function guru.
--------------------------------------------------------------------------
Gnumeric 0.75
Andreas:
* Rewrite solver dialog as guru (semi-modal using the
expr-entry widget).
* Fix FTEST docs.
Jody:
* Shink exported XL files.
* Enable per sheet style management to support
validation, conditionals, and simply XL export.
* re-enable compression for .gnumeric files.
* Make cell format dialog only pseudo-modal.
* Fix support for cancel on window manager quit.
* Fix non-bonobo View menu
* Fix sheet extent calculation new complex objects.
* Improve formula guru.
* Support scrollwheel in a larger area.
* Fix Edit -> Fill -> Autofill.
* Fix Autofill with the month of May.
* Improve dbf importer.
* Make autocorrect non-modal and cleaner.
* Make autocompletion a view attribute, with a gui.
* Improve the ExprEntry widget.
* Don't clear the clipboard when Klipper requests things.
Jukka:
* Lots of documentation added.
* Added `Help' buttons for various tools.
* Help button of autosave doesn't kill the dialog any more.
* Added `Filter' submenu into the `Data' menu.
* More work done to support financial functions.
Morten:
* Cleanup various functions' improper access to internal strings.
* Plug leaks.
--------------------------------------------------------------------------
Gnumeric 0.74
Jody:
* Fix regexp handling of escaped characters.
* Improve XL import when faced with corrupt workbooks.
Morten:
* Find and fix leaks.
* Fix an ugly dependency bug.
--------------------------------------------------------------------------
Gnumeric 0.73
Adrian Custer:
* Improve latex exporter to support multiple pages and basic support
for merges.
Almer:
* More work on validation.
* Improve View menu layout.
Andreas:
* Allow analysis tool output to be directed onto a range
on another sheet.
* Allow analysis tool output ranges to be specified using
defined names.
* Change covariance, correlation, descriptive statistics and
sampling tools to allow multiple selections (and defined
names as input.
* Change covariance and correlation tools to handle missing
observations.
* Change sampling tool to permit multiple samples from the
same or different data.
Jody:
* Fix autosizing of indented content.
* Fix jump to bound with end in hidden region.
* Hide objects in hidden regions for display and printing.
* LOG() is valid with base > 0 && base != 1
* Clean out some unused code.
* Fix redo of unmerge to handle redraw spans.
* Fix Name Support and Dialog.
* Improve data allocator for graphs.
* Begin code audit.
* Fix autofill of days with months visible.
* Fix minor leaks.
* Improve recognition of values vs expressions
* Reset grid display cursor after editing an object.
* Resize frozen panes after ins/del col/row.
* Make python version configurable.
Jukka:
* Improved MPS plugin.
* Extended the data analysis tools and function documentation.
* Improved COUPDAYS().
Morten:
* Improve goal seek.
* Fixed parsing of numbers in scientific, monetary, and number
contexts.
* Find and fix leaks.
* Fix dif plugin's use of alloca.
Wayne Schuller:
* Much improved header/footer preview canvas.
* Improve UI for customizing print header/footer.
--------------------------------------------------------------------------
Gnumeric 0.72
Adrian Custer:
* Improve latex exporter.
Almer:
* More work on validation.
* Stf multiple-separators-as-one fix.
Andreas:
* Rewrite remaining analysis tools
to use the gnumeric-expr-entry widget.
* Rewrite goal seek dialog to use the
gnumeric-expr-entry widget.
Jody:
* Offer config var to control compression level
* Fix color selectors for drawing objects.
* Re-enable support for row vectors in graphs.
* Allow string functions to accept numbers as strings.
* Font selector in cell format dialog
* Off by 1 error when undoing unhiding cols/rows
* Improve handling of Cancel during File -> Quit
* Autoscroll support during object creation
* Fix MINVERSE
* CODE assumes unsigned char
* Improve parser's handling of integers larger than int.
* Improve cursor & scroll bounds checking.
* Fix graph leaks.
* Allow xls exporter to (poorly) handle large format regions.
* Fix changing data for graphs
* Format match can match strings, don't assume only numbers.
* Improve XL chart import.
* Plug memory leaks.
John Gotts:
* Make bonobo optional in the sample rpm specfile.
Jukka:
* Improved COUPDAYS() and COUPDAYBS().
Morten:
* New Search Control Center.
* Find/Fix memory leaks.
--------------------------------------------------------------------------
Gnumeric 0.71
Almer:
* Core support for validation and conditional formats.
Andreas:
* Rewrite descriptive statistics, correlation, covariance,
and rank analysis tool dialogs to use the gnumeric-expr-entry widget.
Christopher Keith Fairbairn:
* Add a 'Fill' menu connection to autofill.
Eric Baudais:
* Improve function documentation generator.
Jody:
* Enable XL import for graphs.
* Import/Export/Edit Hidden/Locked attributes.
* Parse using the assigned fmt before checking the builtins.
* Enable basic attributes when importing shapes from XL.
* Add simple bucketing of range dependencies.
* Formating extensions and corrections.
* Some simple recalc tuning speeds things up by a factor of 2.
* Basic version of just in time rendering for another factor of 2.
* Cleanup the DOM based xml import/export utilities.
* Remove irritating frame around bonobo objects.
* Make the sheet object control points prettier.
* Off by 1 pixel/pt error when handling right/center alignment.
* Improve sheet object menus.
* Reworked the Text Combo,
* Remove the eval queue.
* Improve the Histogram tool slightly.
* Improve INDIRECT.
* Sort the function names for the index generator.
* Fix handling of mixed mode references.
* Convert lines/arrows/boxes/ovals to StyleColor.
* Correct sensitivity of menus & toolbars.
* Some initial guess work on how to import conditional XL formats.
* bump bonobo req to 1.0.8 to fix the memory problem.
* bump the gnome-print req to 0.29 in an effort to decrease
the number of problems with gnome-print installs.
Jukka:
* Fixed COUPNUM().
* MPS importer plugin implemented. Reads a linear program in MPS
format and creates a spreadsheet model of it. Currently, the
bounds and ranges are not implemented yet.
Marc Johnson:
* The POI project has contributed an xml schema for .gnumeric files.
Morten:
* Speed up font handling.
* Speed up dependency handling.
* Eliminate deep recursion during dependency dirtying.
* Fix the python and python-loader modules. (Work around mind-
boggling bug in python. Again.)
* Various code cleanup.
* Fix regression.
* Implemented querying in search-and-replace.
* Implemented Search.
Toralf Lund:
* improve the oleo importer.
Wayne Schuller:
* Support gray scale patterns when printing.
* Improve Header/Footer page for printer setup.
Yukihiro Nakai:
* Improve font handling for multi-byte environments.
Zbigniew:
* Support for translations in plugin.xml files using xml-i18n-tools
(modified xml file structure a bit).
* Sped up Gnumeric compilation by replacing #include <gnome.h> with
something smaller in almost all source files.
--------------------------------------------------------------------------
Gnumeric 0.70
Ariel:
* Make guile a proper plugin.
Jody :
* Basic support for M-Enter to add embedded newlines.
Lutz:
* Object printing work.
Morten:
* Make CEIL more as users expect (based on Jody's idea).
--------------------------------------------------------------------------
Gnumeric 0.69
Almer:
* Add extra cut/copy/paste shortcut keys.
* Improve the function selector.
* Simplify background/pattern preview in cell-format dialog.
* Make sure entered text never gets lost.
* Equalize the look of all the dialogs.
* More work on group/ungroup.
Ariel:
* Rewrite guile plugin to use guile 1.5 or later.
Andreas:
* Rewrite descriptive statistics, correlation and covariance
analysis improving error checks and labels for data sets.
* Remove duplicate calculation code in analysis tools.
* Fix sampling tool.
Jody:
* XL export for panes.
* Some autoscroll bugs with panes.
* Cursor support for panes.
* Improve INDIRECT.
* More smarts for autofill by month/year.
* Add some new icons from the Evolution team.
* Fix import of files generated by perl::writeExcel.
* Fix animated cursors and sheet objects.
* Fix XL import of print scaling.
* Locales with different LC_NUMERIC & LC_MONETARY.
* merge in several contributions to improve configure.in
* merge in updated debian control files.
* merge in contributed man page.
Morten:
* Fix MODE.
* Clean up LARGE, SMALL, QUARTILE, PERCENTILE.
* Give the range functions a home of their own.
Frodo Looijaard:
* Add import support for Psion.
Zbigniew:
* i18n fixes.
* Add precedence scheme for importers.
--------------------------------------------------------------------------
Gnumeric 0.68
Almer:
* Fix backspace key.
* Fix autosave dialog.
* Improve scrollbars.
* Fix double-click autofill.
* Shine-up string functions.
* Fix STF for CRLF terminated files.
* Fix bounds handling and leakage in STF.
* Add csv default importing + probing.
* Improve font preview in cell format dialog.
Andreas:
* Fix bugs in analysis-tools' t-test.
* Finish two-factor anova tool in analysis-tools.
* Adjust scrollbars when outputting data analysis results.
Jody:
* Even more missing files.
* Crash after exiting 1 of many shared views.
* Bug when printing wrapped text in merged cells.
* Frozen panes.
* Some span bugs.
* Usability tuning (Thanks to auspex, UnNamed, & jwz)
* Misc bugs.
Morten:
* Improve bsd support.
* Fix CONCATENATE.
* Fix MULTINOMIAL.
* Fix LCM.
* Fix dependency tracking problem.
Rodrigo:
* Update gda support.
Nakai:
* Over-the-Spot style support for XIM.
Lutz:
* Introduction of placeholders named "FileOperations" and
"PrintOperations" that help components to put their own menus into
the right place.
Zbigniew:
* Use temporary files to handle saving to BonoboStream with every
file saver.
--------------------------------------------------------------------------
Gnumeric 0.67
Jody :
* Restore missing files.
John Gotts :
* Update spec file.
Zbigniew:
* Fix libml1 bug exposed by progress monitor.
--------------------------------------------------------------------------
Gnumeric 0.66
Almer:
* Some work on the SAX importer.
* Finish Group/Ungroup.
* Clean-up the STF importer.
* Add support for multicharacter separators
and quoted cells with newlines to the STF
importer.
* Clean-up row naming.
* Fix the STF exporter (it works again).
* Add new consolidation feature.
* Keyboard Shortcuts for moving and formatting.
Elliot:
* Financial functions.
Jody:
* Fix ctrl-enter filling.
* Reorganize the recalc queue to speed things up a bit.
* Support iteration.
* Fix FV arguments.
* Support conditional number formats.
* Obscure referencing bug.
* Scaled printing.
* Some number formating bugs.
Juan Pablo Mendoza:
* Handle {caps,number,scroll}lock.
* Improve sheet name quoting.
Morten:
* Fix PV.
* Applied some much-needed TLC to fn-financial.c and fn-eng.c.
* Speed-up Gnumeric function calls.
* Killed a zillion problems pointed out by gcc 3.0 warnings.
* Improve goal seeking slightly.
* Fix RATE and IRR.
Zbigniew:
* More work on plugin system.
* Many i/o system improvements (general cleanup, reporing i/o progress,
better probing, nicer import dialog, pluggable default savers,
handling single sheet exporters in a special way)
--------------------------------------------------------------------------
Gnumeric 0.65
Almer:
* Fix a variety of bugs and other issues.
* Improve parser error messages.
* Implement undo/redo for Zoom.
* Make undo/redo descriptors more descriptive.
* Complete the CELL function.
* Drastically revise and fix-up the color combo's.
* Architectural improvements for preview-grid, menu state, etc.
Chema:
* GNUMERIC_ENABLE_XL_OVERWRITE
* Implemented clone, write and load for some sheet objects
Jody:
* Restore horizontal FILL alignment.
* Fix array intercept checking.
* Some fine tuning to improve start and exit times.
* Merge cell & hidden column interactions
* Some XL import improvement when parsing objects
* Improve XL95 export and include merged regions & outlines
* Fix some irritating mouse behaviors
* More system portability enhancements.
* Support fraction formatting (not parsing)
* Fix printing of borders.
* Improve checking for array/merged region division.
* Prep for frozen panes.
* Partial support for outline mode
* Misc bugs.
Jon Kåre:
* New architecture for selecting cell ranges into dialogs.
* Fix dialog placement.
Juan Pablo Mendoza:
* Improve col and row sizing when cloning a cell.
* Catch many bugs with merged regions.
* Bug fix for supporting maximized windows.
Morten:
* Changed a large number of dirty diapers.
* Plugged gnumeric leaks too.
* Make search-and-destroy work better on comments.
* Fixed parsing of numbers like "-4,885". (We used to get -3115
== -4 * 1000 + 885...)
* Fixed formulae with leading dash, like "-995/5".
* Fixed MID, FIND, LEFT, RIGHT, LOWER, UPPER, PROPER, CLEAN, LEN,
EXACT, REPT.
* Improve signed-vs-unsigned situation.
* Fixed sorting dialog in the by-row case.
Vlad Harchev
* Improve i18n support for XL import/export
Zbigniew:
* Added support for plugin dependencies
* Made Excel a real plugin.
* Improved plugin system performance & scalability.
--------------------------------------------------------------------------
Gnumeric 0.64
Almer:
* Improve scrollbars.
Jody:
* Fix handling of edit pos while extending out of merged regions.
* Fix format toolbar update.
* Fix merge undo.
* Fix interactions between spans and hidden rows/cols.
* Work around xls files which specify col/row too small.
* Header redraw of shrinking selections with merged full col/row
Morten:
* Make search-and-replace dialog non-modal.
* Released version 2 -- a cute little thing of about 3k. She
leaks, though.
Vlad Harchev:
* Improved themed behaviour.
* Improved character set behaviour.
Zbigniew Chyla:
* More work on plugins.
--------------------------------------------------------------------------
Gnumeric 0.63
Almer:
* menu state improvements.
Jody:
* Fix parenthesis for XL export.
* Enable right/left indent.
* Sheet prefs IO and MVC support.
* MVC fixes.
Morten:
* Column header drawing fix.
* [Linear] Regression fix.
Jon Kåre:
* item-edit fix.
Translations:
* Updated: de (Karl), ja (Yukihiro Nakai), pl (Zbigniew), and maybe
more.
--------------------------------------------------------------------------
Gnumeric 0.62
Chema:
* Massive bug hunting spree.
Jody:
* Finish merged cells.
* Rework style engine.
* Rework borders.
* Improve range selection for expressions.
* Fix sheet objects.
* Fix stupid memory corruption problem in the applix importer.
* Some mis-translations for spanish.
* Improve pixel matching of XL import.
* Add option to manage printing ranges with only styles.
Jon Kåre:
* Improve file save dialog.
Morten:
* Make rounding functions (ROUND, TRUNC, FLOOR, CEIL, ...) behave
more like most users expect. The number 1.54999...9 will now
be rounded to 1.6, not 1.5. In other words, we are assuming that
the number is really meant to be 1.55, but has suffered
floating point effects. (If you ever truly get a number that
is within DBL_EPSILON of a rounding threshold, well, then you
lose. With a binary representation, we cannot all win.)
* Leak plugging as usual.
* Created and/or stole a number of tools to make life easier for
developers.
* Cleaned up gnumeric-bonobo's GUI.
* Search and replace.
JPablo:
* Search and replace.
Zbigniew Chyla:
* Internationalization support for autoformat.
* Rework plugin architecture.
Translations:
* Updated: ca (Pablo), de (Karl), hu (Szabolcs), it (Leandro),
ru (Valek), sk (Stanislav), sv (Christian), tr (Fatih), and
maybe more.
--------------------------------------------------------------------------
Gnumeric 0.61
Alan Cox:
* Fix formatting mistakes in documentation.
Chema:
* Some work on the name dialog.
Jody:
* Work on sheet object persistence.
* Begin honouring the current format when parsing.
* More work on merged cell support.
* Improve cursor rubber banding when selecting a range.
Morten:
* Fix scripts generating documentation.
* Fixed lotus file format loader. (Magic detection,
avoid unaligned memory accesses, leaks.)
--------------------------------------------------------------------------
Gnumeric 0.60
Jody:
* Initial work on supporting merged cells.
* Improve sheet object and cell comment infrastructure.
* More work on expression relocation.
* Bugs.
Jon Kåre:
* Improve XL export of non-builtin functions.
Morten:
* Semi-smart undo/redo list truncation.
* Fix serious crash during gnumeric-format save.
* Plug leaks.
--------------------------------------------------------------------------
Gnumeric 0.59
Almer:
* Minor improvements to the autoformat dialog.
--------------------------------------------------------------------------
Gnumeric 0.58
Ariel:
* Cleanup and general bugfixing in guile plugin.
* Support for values inside the Guile interpreter
Almer:
* Undo for autoformat.
* Beautify stf dialog.
* Stf and other bugfixes.
Chema:
* Massive bug hunting spree.
Jody:
* Massive bug fixing spree.
* Fix popup context menus.
* 'General' number formats.
* Some initial work on an MVC split for workbooks.
* More work on double click fill support.
Jon Kåre:
* When format toolbar is vertical, replace font and size
selectors with a button.
Morten:
* Fixed analysis tools for ranges not starting at A1.
* Isolated floating-point-double reading code with endian-issues
in one spot rather than in all file io plugins.
Kenneth:
* Fixed and updated the i18n subsystem, so it how should work
more smooth - I will consider this very close to finished.
--------------------------------------------------------------------------
Gnumeric 0.57
Almer:
* Fix stf importer bugs.
* Add "Autodiscovery" feature to stf fixed width importer.
* New Autoformat dialog.
Chema:
* Sheet copy routine
Hardy Falk:
* Output the cells in row/col sequence, rather than by hash.
Jody:
* Applix support mostly functional.
* Improve support for named expressions.
* Name and Graph gurus support range selection.
* Improve internation keyboard support.
* Fix XIRR and friends so that they support blanks.
* A few more bugs in printing multiline text.
* Correct handling of number formating in intl locales.
* Lots of formating bugs.
* Handle strings used as arguments to numeric operators.
* Support for non-cell dependencies.
* Improve performance and decrease memory for large row/col resizes.
* Bug fixes for ins/del row/col & cut&paste
* Locale safe formating.
John Gill:
* Double click fill support.
Jon Kåre:
* Make print work with new gnome-print
* Lots of printing/margin bugs.
JPR:
* Put more effort into reverse engineering MATCH (and friends)
than you want to know about.
* Fixed sort to ignore hidden rows/cols.
Jukka:
* Implementation of `Anova: Two-Factor With Replication'
and `Histogram' data analysis tools mostly
* Implemented COUPNUM and COUPNCD
* Implemented TRUE and FALSE logical functions
* Started the implementation of COUPDAYBS and COUPDAYS.
Kenneth:
* Created xml2pot script, and integrated it with Gnumeric
* Update update.pl script to make it more genetic, and work
with the xml2pot script. It actually now requires it.
* Updated the spec file a little.
* Made 'make update-po' and 'make dist' work with new update.pl
Matthew D. Bissiri:
* Paste special arithmetic operations, skip blanks, paste link.
Michael Levy:
* Improve the colour combo box.
Morten:
* Cleanup analysis tool code.
* Eliminate many fixed limits in the code. (Still some to go.)
* Rewrote SUMPRODUCT.
* Fixed array and range traversal order, thus fixing all strict
range functions. (SUM, MIN, ...)
* Fixed many bogusities in xbase plugin.
* Cleanup limits in numtheory. Added BITXOR.
* Fixed RATE, SLD, and SYD.
* Improved RATE's and IRR's root searching.
Pablo De Napoli:
* New NT_MU function in numtheory.
Thomas Canty:
* Updated and improved documentation.
Weston:
* Implement DateDif.
* Fix chitest.
Translations:
* Updated: da (Kenneth and Keld), de (Karl), en_GB (Robert), ko
(Sung-Hyun Nam), no (Kjartan), ru (Valek), uk (Yuri), maybe more.
* Update not new, but not mentioned the last time: pl (Zbigniew).
* Updated: nl (Almer). Not all done yet.
--------------------------------------------------------------------------
Gnumeric 0.55/0.56
Almer:
* Stf importer bug fixes and enhancements.
Jody:
* Speedup workbook exit, copy/paste.
* Improve cut/copy/paste.
* Improve col/row resize.
* Undo for copy/paste, autofill, col/row resize
* More work on formula guru.
* Extend auto-fill to support months and years.
* Some translation bugs.
Jon Kåre:
* Tooltips for combo boxes.
* Synchronize list selection with entry field in combo boxes.
* Make units in print setup dialog user selectable.
* More dialog polishing.
JPR:
* Sorting now moves styles with the elements
* Sorting now detects headers when sorting
Kenneth
* Added two perl scripts for translation help/maintainence.
Also added is a README.tools file, explaining how to use these.
Michael:
* Fix tricky Excel import problem.
* Split libole2 out into a standalone package.
Miguel:
* Added support for autocompletion.
Morten:
* Changed a bunch of internals to work with StyleFormats instead
of throwing strings around.
* Improved the optimization of styles.
* Fix ROUND.
* Make sorts stable.
* Make sorts faster.
Translations:
* Updated: da (Kenneth), de (Karl), ja (Oka/Nakai), no
(Kjartan), pt (Tiago), ru (Valek), maybe more.
* Update not new, but not mentioned the last time: it (Leandro).
--------------------------------------------------------------------------
Gnumeric 0.54
Jacob:
* Enable mini icons when available.
Jody:
* Bug fixes.
* Initial applix import.
* Improve row/col insert/del.
JonKare:
* Lots of dialog polishing.
* Autoscrolling combo boxes.
* Make tearoff combo boxes behave more like tearoff menus.
Michael:
* Get embedded gnumeric working again.
Translations:
* New: gl (Jesus).
* Updated: de (Karl), no (Kjartan), sv (Andreas), and more.
--------------------------------------------------------------------------
Gnumeric 0.53
Morten:
* Fixed QUARTILE.
* Fixed MATCH for types -1 and +1.
Jody:
* Overhaul cell structure to cleanup temp formats, improve spans.
* Improve array formula entry, editing, and xml-io.
* Share formulas persisted using xml.
* Add auto-sum
* Improve versioning.
* Decrease memory usage.
Michael:
* Accelerated intersheet dependencies
Marko:
* Number theory functions. (In new plugin.)
Almer:
* Stf-exporter
* Bug-fix stf importer.
Translations:
* Updated: da (Keld and Kenneth), de (Karl), en_GB (Robert), es
(Pablo), no (Kjartan), ru (Valek), uk (Yuri), and more.
--------------------------------------------------------------------------
Gnumeric 0.52
Jon:
* Tearoff combo boxes
Jody:
* Bugs fixes.
* Correct doc generation.
* Improve update status area (autoexpr, editor, format tools)
* Rework canvas editor to behave nicely at boundaries and
span correctly.
Morten:
* Leak fixes. Bug other people about leaks.
* IPMT, PPMT argument order corrected.
* MIRR fixed (or at least changed) to match Excel.
* RATE, IRR, XIRR use supplied guess.
* Improve precision of IRR.
* Made auto-format work for sheet-relative cellrefs, i.e.,
"=sum(a1:a10)" now takes a default format from the range.
* Made generated postscript files (print to file) contain enough
information to let ghostview go back and forth in them.
* Made landscape previews readable.
--------------------------------------------------------------------------
Gnumeric 0.49
Jukka:
* Added `>=' and `=' constraint support for the Solver tool.
* The Solver input variables can now have the negative values too.
* Added `Int' constraints support by implementing the
Branch-And-Bound algorithm.
* The Solver parameters are now saved/loaded when the workbook
is saved/loaded.
* Implemented `Answer Report' generation for Solver.
* Started implementation of `Sensitivity Report' generation for
Solver (currently, not very useful though).
* Major GUI improvementes for Solver, i.g. Solver constraints
can now be cell ranges, not just cells.
* Solver documentation added.
* Added `Advanced Filter' tool.
* Added the following distributions for the random number
generation tool:
- Poisson
- Binomial
- Negative binomial
- Exponential
* Minor improvements for the AutoSave tool.
* GUI improvements for the Data Analysis tool.
* Added RandExp(), RandPoisson(), RandBinom(), RandNegBinom(),
and RandBernoulli() functions.
Jody:
* Redraw improvements (cursor, selection, spanning, speed, underlining)
* Border improvements (combo, printing, partial double line).
* More work on undo.
* Parse interbook references.
* Mostly correct sizing of MS Excel cols/rows and objects.
* Printing improvements.
* Selecting ranges for formulas on other sheets.
Jon:
* GUI polishing.
* File history improvements.
* Python plugin enhancements.
* Error reporting improvements.
* Cursor fixes and speedups.
* CORBA bugfixes.
ERDI Gergo :
* Add a zoom element to the toolbar.
Michael:
* Style undo/redo
* Gnome Basic integration
Miguel:
* Charting work
* Wizard for charting
* Bug fixes.
* Visual cell references while editing.
* Implemented Gnumeric-side vectors for graphics support.
Dom Lachowicz :
* libgladify the plugin manager.
* Improve color combo.
* Lots of DIV0 cases in functions caught elegantly.
Mike Kestner:
* Add file menu file history.
* Style preserving column/row insertion(configurable, defaults on)
Almer :
* "Structured" Text Format Importer (STF) (Customizable CSV/Fixed Width importer)
- Merged with Gnumeric main source (no longer plug-in) and completely revised.
- Pops-up when pasting from external applications.
- Preview is drawn faster and is interactive.
- More separators to choose from when doing a CSV import.
* Copying cells between different instantances of gnumeric.
Morten:
* Fixed display of pre-1900 dates.
* Fixed display of very large numbers.
* Went on a warning-killing spree.
Ariel:
* Guile plugin can now register functions in user given categories.
JP:
* Add sorting functionality to workbook toolbar
* Sorting fixes
* Add basic attribute support for workbooks
--------------------------------------------------------------------------
Gnumeric 0.48
Miguel:
* Fix annoying flashing cursor bug.
Jody:
* Improve inter{sheet,book} references.
* Beginnings of Undo.
* Row/Col hiding.
* Keep cursor visible, Add Alt-Pg{Up,down}
* Clipboard, Selection, & border fixes.
Morten:
* Revamp the memory handling of the parser.
* Fixed goal seek's behaviour on cancel and failure.
* Bogotised PRODUCT and introduced G_PRODUCT.
* Implemented the auto-format feature.
Jon:
* Found xml io font size loading bug.
* Excel export clean.
* Python plugin update: Allow calling Gnumeric builtins from
Python.
Michael:
* Re-wrote dependency engine; lots more speed.
Ariel:
* Improvements on VALUE_BOOL management on the guile plugin.
* Bug fixes.
Jukka:
* Implemented `AutoSave' tool.
* Started `AutoCorrect' tool.
* Some minor improvements to the Solver tool.
JP:
* Sorting undo/redo
--------------------------------------------------------------------------
Gnumeric 0.47
Michael :
* Fix nasty recalc bug that would hang the app.
* Improve bounding box calculation for printing.
Miguel :
* Improve empty cell loading.
* Re-enable pasting from X.
* Adjust semantics of paste to work even when selection is not
visible.
Jody :
* Fix import plugins.
--------------------------------------------------------------------------
Gnumeric 0.46
Michael:
* Fixed problems closing workbooks
* Add pristine workbook discard
* Fixup html export.
* Fixed print header/footer setup, users should remove
~/.gnome/Gnumeric to speedup load.
Jon:
* Lots of Excel style export work:
format, font, colors, borders, alignment, wrap, rotation.
* Excel export row/col sizing.
* Excel fixed up DBCELL collating to export lots of rows correctly.
JP:
* Added sorting of infinite ranges
* Got rid of blank sheets when printing
Frank:
* Worked on Excel summary export
Jody:
* Begin exception handling for corba vs gui.
* Add some simple version protection for plugins.
* Improve error reporting for file loading.
* Explicitly disable passord protected XL spreadsheets.
* Bug fixing.
Cort:
* Expanded CORBA API.
Andrew:
* Many improvement for multi-dimensional linear regression.
Jukka:
* Implemented Simplex algorithm for Solver
* Solver can now solve some simple LP problems (more interesting
stuff is coming later).
Ariel:
* Added guile plugin documentation.
* Removed redeclaration of functions.
* Removed security hazard on the definition of scm_eval.
* Improvements on VALUE management.
* Added Fibonacci formula
* Split the guile scheme files into gnumeric_startup.scm and
functions.scm
* Bug fixing.
--------------------------------------------------------------------------
Gnumeric 0.45
JP:
* Improved sort dialog
Nat:
* Updated bonobo infastructure
Kevin:
* Plan Perfect plugin
* DIF export / import
Jody:
* Improved clipboard ops.
* import Excel auto-ranges
* better range instersection
* Guile plugin fixed
* Auto fill display fixes.
Jon:
* Style hashing
Michael:
* Misc cleans
* Fix #2110
--------------------------------------------------------------------------
Gnumeric 0.44
Jon:
* Vastly improved col / row sizing in excel import
* ditto for Excel object placement.
JP:
* Expanded sort dialog to allow sorting of rows as well as columns
* Added advanced button to sort dialog to allow sorting but case
sensitivty and text (rather value)
--------------------------------------------------------------------------
Gnumeric 0.43
* Minor build fix.
--------------------------------------------------------------------------
Gnumeric 0.42
Michael:
* Totaly re-wrote style engine.
Jukka:
* Implemented IRR and XIRR financial functions
* Fixed the handling of the database function criterias
* Fixed the non-numeric return values of DGET
* One-dimensional GROWTH and TREND should work now
* Documentation of the db functions improved
Jody:
* Complete transition of cut/paste to cell movement code.
* 1st pass at borders & patterns
* Improve edit popup.
* Rework cell format dialog.
* Some support for inter book references (no dependencies yet)
Daniel:
* Excel Name export.
Federico:
* Improved dragging and zooming behavior in the print preview.
* Added "open hand" and "closed hand" cursors for dragging the
print preview.
Robert:
* Primitive oleo import : supports numbers and text.
Frank:
* Huge chunk of summary-info re-structuring.
* Import and export lots of new summary fields.
JPR:
* Improving sort dialog
Jeff:
* Sylk import filter.
* CSV export filter.
--------------------------------------------------------------------------
Gnumeric 0.41
* More recalculation bugs & other minor issues fixed.
* Base release before Style mangling.
--------------------------------------------------------------------------
Gnumeric 0.40
Miguel:
* Important recalculation bugs fixed.
--------------------------------------------------------------------------
Gnumeric 0.39
Miguel:
* Arbitraryly shaped bonobo objects.
* Formatting engine supports h,m,s correctly and supports [h], [m], and [s]
Jukka:
* Started implementation of GROWTH function
* Optional argument fixes for TREND function
Arturo:
* Split libole2 + test program.
* Large excel file support > 8Mb.
Michael:
* Start of sheet/workbook/global name scoping.
Jody:
* Some Optimization.
* Enhance row/col insert/delete, cell shift, and cell cut/paste.
* Some eye candy.
Jon K Hellan:
* Dialog improvements.
--------------------------------------------------------------------------
Gnumeric 0.36
Jody:
* Improve selection to correctly handle overlapping ranges.
* Improve XL import of 'escher' stream for pictures and objects.
* Enabled import of XL objects by default.
* Rewrite zoom dialog.
Jukka:
* Major clean up to the documentation of functions.
* Added tons of examples to functions.
* Added ``Delete...'' entry to ``Edit'' menu.
* Implemented PERCENTILE function.
* Fixed PERCENTRANK function.
Miguel:
* New toolbar code.
* Report font type, support for reporting size
* New format apply buttons for money, percent.
* More commands to format/row/col/sheet
* Bumped row limit to 64k
Michael:
* Support IO on non-mmap-able excel files.
* Totaly re-write libole2's API - its usable now.
* Excel export 'Add-in' functions.
Frank:
* Excel summary info export.
--------------------------------------------------------------------------
Gnumeric 0.33, 0.34, 0.35
Jukka:
* Implemented ACCRINT, ACCRINTM, DISC, FVSCHEDULE, INTRATE,
ISPMT, RECEIVED, PRICEDISC, PRICEMAT, TBILLEQ, TBILLPRICE,
and TBILLYIELD functions
Michael:
* Re-implemented sheet objects,
* Implemented drop filename -> Bonobo component conversion,
* More intelligent workbook sizing.
* Fixed sheet tab focus / editing.
* Per sheet page setup / preview.
* Print setups XML I/O & Excel importing
* Functions MATCH & INDEX started.
* Array input parser.
--------------------------------------------------------------------------
Gnumeric 0.33, 0.34, 0.35
Jukka:
* Implemented ACCRINT, ACCRINTM, DISC, FVSCHEDULE, INTRATE,
ISPMT, RECEIVED, PRICEDISC, PRICEMAT, TBILLEQ, TBILLPRICE,
and TBILLYIELD functions
Miguel:
* Implemented Print Preview
Jody:
* Bug fixes.
--------------------------------------------------------------------------
Gnumeric 0.32
Jukka:
* More work done on documenting the analysis tools.
* Implemented MDETERM and MINVERSE matrix functions.
* Finished the ROMAN function completing the mathematical
functions.
* Implemented DB, DDB, FREQUENCY, QUARTILE, and XNPV functions.
* Started the implementation of LINEST and TREND functions.
* Fixed DOLLAR, DOLLARDE, DOLLARFR, and PROB functions.
Michael:
* Added GUI for Summary Info.
* Enabled function wizard.
* Initial stab at Lotus 123: 'wk1', 'wks' import.
* Added GUI for Names.
* Better Excel string importing.
* Fix for padded number insertion ( fixes CSV import )
* Implemented ISREF, INDIRECT improved CELL
* Fixed several database functions.
* Non-relative R1C1 style references.
Jody:
* Enable Array formulas.
* Add VALUE_BOOLEAN, VALUE_ERROR, and OPER_PERCENT
* Added EOMONTH, WORKDAY, NETWORKDAYS.
* Work on functions : ROW, COLUMN, ISLOGICAL, ISERR, ISBLANK,
DATEVALUE
* Support implict intersection 'feature' of XL for functions,
NOT operators.
* Support Ctrl-Arrow movement & selection. Make moving corner of
selection visible.
* Support F4 switching between absolute and relative addressing
modes
* Reworked internal handling of absolute/relative addressing.
* Fixed cut/copy/paste to relocate relative references to only
when copying not cuting.
Jay:
* Implemented BESSELI, BESSELK completing the engineering functions.
Miguel:
* Bonobo support is working again.
* Added Moniker support for the Workbooks
* Made the Workbook a GtkObject;
* Made Workbook a GnomeContainer object
* EmbeddableGrids now can be returned from get_object to provide linking support.
* Added a signal for cell_content_changed for the speech support.
* Removed function wizard.
* Fixed locale setting and switching for file IO.
* Updated the CORBA interface for setting cell attributes.
* Killed some dead code.
* All IO code now takes an existing workbook to load information into,
rather than creating a new workbook and returning it.
* Scrolling sheet tabs.
--------------------------------------------------------------------------
Gnumeric 0.31
Jukka:
* Implemented ``Anova: Single Factor'' data analysis tool
* Implemented ``Anova: Two-Factor Without Replication'' data
analysis tool
Jody:
* Added TEXT, HYPERLINK stub, fixed OFFSET, VALUE.
* Improve handling of empty cells, and null strings. Still incomplete.
* Partial fix formating/parsing.
* Bug fixes for Excel import.
Michael:
* Implemented Summary Information
--------------------------------------------------------------------------
Gnumeric 0.30
Jukka:
* Bernoulli distribution added to Random Number Generation tool
* Finished the Rank and Percentile tool
* Lots of bug fixes and documentation updates to the data
analysis tools
Jody:
* Added TRANSPOSE(), MMULT()
* Constification.
* SplitArray exception for array formulas support.
* Better Excel emulation for insert/delete row/col menus.
Miguel:
* New font selector widget for the new gnome-print information.
Rasca:
* New EPS exporter.
--------------------------------------------------------------------------
Gnumeric 0.29
Miguel:
Added EmbeddableGrid Bonobo support for embedding graphics.
Added header/footer printing code.
Extended the CORBA interface for sheets
Added Grid corba interface
Fixed Gnumeric compilation
Include all the plugins again
Rasca Gmelch:
Troff export
Improved HTML export
Improved LaTeX export
Jukka:
- Implemented Moving Average Tool
- Started implementation of Rank and Percentile Tool
- Documented Analysis tools
Jody:
Display embedded newlines in multi-line-cells
Michael
* More improved Excel writing code
--------------------------------------------------------------------------
Gnumeric 0.28
Hello guys,
I have just released version 0.28 of Gnumeric.
This version main feature is that it adds printing support.
Starting with this release you need to install the gnome-print
package.
* Availability
ftp://ftp.gnome.org/pub/GNOME/sources/gnumeric
* New Features since 0.27
* Print support (miguel)
* Improved function wizard (not yet enabled) (Michael)
*
* New Tools
* Started the implementation of Data Analysis tools (Jukka)
- Implemented Correlation and Covariance tools
- Implemented Descriptive Statistics Tool
- Implemented Sampling Tool
- Implemented t-Test Tools (paired, assuming equal variance, and
assuming unequal variance)
- Implemented z-Test Tool
- Implemented F-Test Tool
- Implemented Random Number Generation Tool with the following
distributions: Discrete, Normal, and Uniform.
* New Functions
* Added the following functions (Jukka)
- FORECAST() and INTERCEPT().
* Excel support
* Patterns now match the Excel ones (Jody)
* Improved writing code (Michael)
* Excel can load our formulas now
* Text/number work correct (Michael)
* Completed Excel color handling (Jody)
* Improved Excel format support for formulas (Jody).
* Worked on embryonic Excel chart code (Jody).
* File I/O
* Working CSV code (miguel, alan)
* Split between importers and loaders (miguel):
Importers basically lack a probing routine, so for
non-deterministic probing, we use importing instead of loading.
* HTML importer (Rasca Gmelch)
* HTML exporter (Rasca)
* Latex exporter (Rasca)
* Random improvements
* Prettified sort slightly (Michael).
* Major Bug fixes
* Pattern selector works again (miguel)
* Memory leak fixes (Morten)
* SUMIF() and N() fixed (Jukka).
* Many translations updated, thanks to our translators.
Best wishes,
Miguel.
Gnumeric 0.27
Hello guys,
New version of Gnumeric has been released. Version 0.27
The next version will most likely merge my code to do printing into
the main branch unless we decide to do a quick bug fix release. Also,
starting with this release, Gnumeric will be supported by
International GNOME Support (http://www.gnome-support.com).
Michael Meeks has redone the function definition code, it is much
better and extensible than the code we had before.
* Getting it
You can get it from:
ftp://ftp.gnome.org/pub/GNOME/sources/gnumeric
* What is new in this release:
Jukka:
* Added the following functions:
- FTEST(), TTEST(), SUMPRODUCT(), SEARCH(), ADDRESS(),
CHITEST(), BETAINV(), PERCENTRANK(), SERIESSUM(), SUMA(),
SUBTOTAL(), SLOPE(), AVERAGEA(), MAXA(), MINA(), STDEVA(),
STDEVPA(), VARA(), and VARPA().
* And fixed these functions:
- BETADIST(), NORMDIST(), RANK(), and POISSON().
* Lots of test files added
Morten:
* Reworked the insert/delete column/row again.
* Reworked the Goal Seek function to produce more accurate
results faster, and fail less often.
* Improved the recalculation engine.
* Shined up date calculations.
* Added WEEKDAY(), DAYS360(), TIMEVALUE().
* Fixed PROPER(), FLOOR(), SERIESSUM(), ROUND(), ROUNDUP(),
ROUNDDOWN(), ATAN2(), MOD(), INT(), COUNT(), COUNTA(),
AND(), OR().
* Improved precision here and there.
* Fixed font-reusage when writing in Gnumeric's default file
format.
* Fixed cell editing code.
* Fixed many internationalisation bugs. Translators, please
make sure the default floating-point format, "0.0########",
has been translated for your locale. (German translators,
please revisit "Zoom factor should be at least 50%" also, :-)
Miguel
* Paste-Special/Transpose.
* Bug fixing.
Sean
* Implemented 'X-base' importing support (DBase, FoxPro etc.1)
Michael
* Re-wrote the OLE block layer again...
* Re-wrote all the function code for more uniformity, lucidity
and expandibility.
* Re-wrote the function documentation.
* Tentative alpha Excel sheet writing
- StarOffice is only tested importer
- Only Excel 95 likely to 'work'
- only basic numbers and text are stored.
* Fix writing code to preserve sheet order.
Nick Lamb
* Added excel function mappings.
* Fixed absolute shared formulae cell references.
* Supplied a spreadsheet to check date functions.
Jody Goldberg
* Supplied many new error and error checking functions.
* Vastly improved Excel color loading.
* Completed Excel funtion mappings, as far as possible.
Several translations updated: thanks to our translators
And lots of bugs fixed.
Thanks to all
Miguel.
Gnumeric 0.25
Hello guys,
Gnumeric 0.25 has been released. Lots of new things are happening
in this new version, here is a list:
* User visible
* New functions: BETADIST(), FDIST(), TDIST(), CHIDIST(),
CHIINV(), GAMMAINV(), GAMMADIST() from Jukka-Pekka.
* New functions: SUMSQ(), MULTINOMIAL(), PRODUCT(), SQRTPI().
I believe these are from Jukka Pekka, but I do not see a
ChangeLog entry.
* Enhanced Excel importing code even more (Michael Meeks).
* Goal seek dialog box from Jukka-Pekka works.
* Round up bug fixed by Morten Welinder.
* Recomputation bugs for cell ranges fixed (some taxpayers
noticed that their loaded sheets were not recalculating at
startup, thanks for their input).
* User visible, not ready
* More Bonobo work. Start of graphics wizard for use with
Guppi, the GNOME plotting engine.
* Foundation work
* Integration of libglade into Gnumeric. Now we can design
our dialog boxes with Glade and use libglade to load the
GUIs. Thanks to Damon Chaplin for Glade and James
Henstridge for libglade and his support with libglade.
* Made the code use 'const' a lot more (Morten Welinder), this
helps making the code more robust.
* Not very visible
* Assorted batch of bug fixes.
* A number of memory leaks have been fixed (Morten Welinder).
* Excel loader can even restore your selection :-) (Michael
Meeks).
* A number of sanity checks from Morten Welinder.
Miguel.
Gnumeric 0.23
Hello guys!
A new version of Gnumeric has been released, version 0.23. Trained
eyes will notice that I have skipped version 0.22. Well, I did not.
I just did not announce it because I had promised not to make a new
release (which I ended up doing) because it included a pile of cool
features.
So, here is the new stuff since 0.21, major features:
* Michael Meeks added multiple-clause sort to the sort dialog.
* GNUMERIC_NORMDIST() function now uses a more efficient
method of computation (Morten Wellinder).
* Should load properly workbooks with references to other
sheets.
* Starts up with a bigger size (Michael).
* Michael has begun a function wizard, it is disabled in this
version by default.
* RAND() function.
* Fixes for some cases of circular references (the other cases
were fine), by Morten.
* IF() now can take variable arguments (Michael).
* Updated documentation
* Many small fixes.
Getting Gnumeric 0.23:
ftp://ftp.gnome.org/pub/GNOME/sources/gnumeric
Miguel.
Gnumeric 0.21
Hello guys,
I know, I know. Too many releases for a day.
But many good things have been done, and we want all of these
features to be available ASAP to all of you :-).
1. Morten Welinder implemented a more accurrate algorithm for
the variance functions.
2. Michael Meeks send me lots of updates and changes to Gnumeric:
a. Column Sorting.
b. Better dragging of text areas.
c. Updated documentation on writing functions.
d. Uses floats on number-entry if the number is
too large (instead of overflowing like it was doing).
e. Updated function documentation to mention optional parameters.
I promise I will be quiet now for a few days. I really do.
* Availability:
ftp://ftp.gnome.org/pub/GNOME/sources/gnumeric
Miguel.
Gnumeric 0.19
Hey Dudes!
New version of Gnumeric has been released.
* New in this version:
* New infrastructure to simplify writing functions
with variable arguments (Michael Meeks).
New token for ranges.
* Many new functions:
* Jukka-Pekka Iivonen contributed many finantial functions:
DOLLARDE(), DOLLARFR(), NOMINAL(), NPV(), PV(), FV(), PMT(),
IPMT(), PPMT(), NPER() and DURATION().
* Michael Meeks wrote the spreadsheet lookup functions: COLUMN(),
COLUMNS(), HLOOKUP(), ROW(), ROWS(), VLOOKLUP()
* Sean Atkinson improved SUBSTITUTE() and he implemented CONCATENATE(), REPT(), FIND(),
FIXED(), PROPER(), REPLACE(), T(), VALUE(), SUBSTITUTE(), DOLLAR()
* Jukka-Pekka wrote CEILING() and COMBIN().
* Jukka-Pekka wrote the statistical functions:
BINOMDIST(), HARMEAN (), HYPEGEOMDIST(), AVEDEV(), CONFIDENCE(), CRITBINOM(),
DEVSQ(), FISHER(), KURT(), NORMDIST(), PERMUT(), SKEW(), STANDARIZE(), WEIBULL(),
FISHERINV(), NORMSDIST() and LOGNORMDIST(), CORREL(),
COVAR(), MODE(), NEGBINOMDIST(), RANK(), TRIMMEAN().
* Michael Meekrs wrote POISSON(), DELTA(), GESTEP().
* Many bug fixes
* Daniel Veillard fixed the bug with saving cells that had the "&" inside.
* Cleanups from Michael to use the new variable arguments code.
* Various typo fixes.
* Availability:
ftp://ftp.gnome.org/pub/GNOME/sources/gnumeric/gnumeric-0.19.tar.gz
Miguel.
Gnumeric 0.18
Hello guys,
New gnumeric is out.
This is mainly a bug fix release
* Features:
- More functions from Michael Meeks
- Bug fix: Applying a cell number format should work again inmediately
(it was not queuing the re-rendering operation).
- Bug fix: Precedence fixes: when decoding the tree to render a text
representation, I was not properly considering the case for
same-priority but different meaning operations.
Should work now. (ie, it will correctly decode 1/(c4*d4)
again.
- New code: integer overflow/underflow detection code. Now
addition and substraction will be promoted to floating point
values if there is a overflow in the computation.
* Availability:
ftp://ftp.gnome.org/pub/GNOME/sources/gnumeric/gnumeric-0.18.tar.gz
Gnumeric 0.17
Hello guys,
New version of Gnumeric is out:
* Availability:
ftp://ftp.gnome.org/pub/GNOME/sources/gnumeric
* Changes and new features:
* Financial functions (effect, sln, syd) from Vladimir Vuksan.
* Engineering functions (power, gammaln, poisson, expondist,
sign, trunc) from Michael Meeks.
* Statistical functions (stdev, stdevp, var, varp, gcd,
geomean,) from Michael Meeks.
* Fixes to the clipboard code (should paste formulas to other
applications correctly and fix the inter-worbook pastes).
* External function loading works for Excel files.
* Cleaned up the Excel code (Michael)
* Should compile in AIX again.
* Documentation
* As usual, all of the Gnumeric functions are documented.
Gnumeric 0.16
Hello guys,
New version of Gnumeric is out:
* Availability:
ftp://ftp.gnome.org/pub/GNOME/sources/gnumeric
* Changes and new features:
* Cell ranges will work properly if they are not in their
natural order (fixes the bug reported about SUM (C1:A1) not
working and a whole range of similar problems).
* CLEAN() function fixed.
* New text exporting plugin from Takashi Matsuda.
* We use gdk_fontset_load now to load fonts instead of
gdk_font_load, this should make the code work for various
international users (Takashi).
* Entering data with XIM on the sheet should work now as well
(Takashi).
* Paste-by-value has been fixed by Takashi as well.
* cell_set_format_from_style has been speeded up by Michael
Meeks.
* Excel importer no longer has static buffers (removes various
problems reported by people) (Michael Meeks).
* Excel importing code should be significantly faster and less
verbose now (Michael Meeks).
Miguel.
Gnumeric 0.14
Hey guys!
This is the release of Gnumeric "Simplified Bonobo" 0.14.
The only difference between Gnumeric 0.13 and 0.14 is that 0.14
ships in a way that makes the install process use the documentation as
it was generated in my machine (that means, you do not need the
Docbook tools installed in your system to get the documentation).
Best wishes,
miguel.
Gnumeric 0.13
Hello guys,
I have just released Gnumeric "Superstitious Bonobo" 0.13. This
version is as usual available in:
ftp://ftp.gnome.org/pub/GNOME/sources/gnumeric
These are the new features in this version:
1. Excel loading is much faster now (Michael Meeks)
2. More excel sheets load now (Michael)
3. Various compilation fixes from Tim Mooney for some
strict C compilers (Digital C compiler in this case).
4. Now it recalcs cells when you have cleared values or
removed cells (just a missing call to workbook_recalc was missing).
5. Install/compile fixes from Raja Harinath.
6. Implemented new functions: "ISERROR" and "NOT".
7. Copy/paste fixes in the presence of errors in the spreadsheet.
8. Small display glitch fix.
9. Add type checking to functions that take a constant number of arguments.
10. Upper case format letters are now accepted.
Enjoy!
Miguel.
Gnumeric 0.12
Hello,
New Gnumeric version, this is the miguel-will-be-out-until monday
release of Gnumeric, I will be visiting Boston, so if you are in the
area we could probably meet.
New features:
- New function TRUNC
- Excel loading: Michael Meeks and Sean did lots of work again
on improving our Excel importer.
- Internal fix that the Excel code was hitting.
- Fixes the menu for the quick operations (on the workbook)
- Fix to the rename-sheet function (it was displaying garbage
sometimes)
- Brunno finished the support for coloring the background of
cells, so now we can have nicely colored sheets with nice
backgrounds :-)
- He also finished the foreground setting color code. Thanks!
- Now it warns if you drop a range of cells in a region that
already has values.
- Should include the missing files for the Perl plugin.
- CSV code disabled until it is fixed.
- Stricter control for removing active sheets in the code.
- Michael provided an icon for Excel files.
- Contributed Spanish documntation from Pablo.
You can get this at:
ftp://ftp.gnome.org/pub/GNOME/sources/gnumeric
Best wishes,
Miguel.
Gnumeric 0.11
Hello,
I have released a new version of Gnumeric, pretty much a bug fix
over the Numerically Skillfully Cow release of Gnumeric.
Thanks to all of you who send me good bug reports, here is a list
of the bugs fixed and improvements:
- Excel loading code improved again by Michael Meeks. He also
spotted a number of bugs in the code which were fixed.
- Paste was not properly recomputing formulas pasted.
- Gnumeric no longer crashes on save.
- Dependecy computation code got fixed. Horribly typo was
doing all sorts of nonsense ;-)
Fetch it from:
ftp://ftp.gnome.org/pub/GNOME/sources/gnumeric/gnumeric-0.11.tar.gz
Miguel.
Gnumeric 0.10
Hello number lovers,
I have released the Numerically Skillfully Cow release of the
Gnumeric Spreadsheet.
New in this version:
* Many updates on the Excel side, optimizaitons, bug fixes,
more features supported (Michael Meeks, Sean Atkinson).
* Support for adding/removing sheets on the notebook tabs
* A small draw fix (g's, j's and y's are no longer cropped).
* Mime types for Excel files are shipped (but no gnome icon
for XL files yet).
* Fixes to the CVS loader (Vincent Renardias).
* Perl plugin is shipped again.
You can get this from:
ftp://ftp.gnome.org/pub/GNOME/sources/gnumeric
Happy sums,
Miguel.
Gnumeric 0.8
Hello guys,
Gnumeric "International Manatee" 0.8 has been released.
This version is available in:
ftp://ftp.gnome.org/pub/GNOME/sources/gnumeric-0.8.tar.gz
The most important change in International Manatee is the fact that
the documentation that Adrian Likins wrote is now integrated into the
build system. It gets installed and we feature a reference guide for
the internal Gnumeric functions.
These are the features of International Manatee:
- Bruno enabled the coloring page for setting the foreground
color.
- The sheet label name works properly now (it no longer
"slides").
- Correct behaviour of clicking in the presence of editing the
sheet label name.
- Guile support now needs to be explicitly configure
(--with-guile).
- Fix crashing problems repoted when autofilling.
- Documentation is included in the tarball (You need DocBook
if you plan on extending the documentation or fixing my
ugly, ugly, ugly stuff :-). You can find Docbook here:
ftp://ftp.cygnus.com/pub/home/rosalia/docware.
A docbook tutorial is available in:
http://nis-www.lanl.gov/~rosalia/mydocs/docbook-intro.html
The full docbook documentation can be downloaded for free
from the Davenport site (I lost the url to this, but I am
confident all of you documentation-savvy people are good
at altavistaing things).
Enjoy,
Miguel.
Gnumeric 0.7
Hello guys,
Gnumeric "Speedy Manatee" 0.7 has been released.
This version is available in:
ftp://ftp.gnome.org/pub/GNOME/sources/gnumeric-0.7.tar.gz
The highlights of this version are:
New features dept:
- References to other sheets works, you can use this like this:
=Sheet!A1+1
='Regional sales'!C5*3
- New border code. Getting ready to print the borders on the
cells.
- Menu hints are now available for every menu entry.
- Standarized the menus (Nat Friendman).
- Use the statusbar in the code now.
- You can now rename your sheets by double clicking on the
tabs and typing the new name. How excelish!
Enhancements dept:
- Excel importing code has been enhanced by Michael Meeks and
Nick Lamb.
- When inserting/moving columns or rows, the cells moved now
do not change their formulas (to keep the sheet working).
Bug fixes dept:
- Better default decimal formats
- Page flipping works correctly if you press on the tab names.
- Child dialog boxes no longer ignore keystrokes (in
save/load).
- Fixed the memory leaks on the Excel plugin (Michael).
- Provide better error checking for dates (Havoc Pennington)
Enjoy,
Miguel.
Gnumeric 0.5
Hello guys,
I have just released a new version of Gnumeric (gnumeric-0.5), this
version is available in:
ftp://ftp.gnome.org/pub/GNOME/sources/gnumeric-0.5.tar.gz
The highlights of this version are:
- A pluggable framework for file formats. No need to hack the
code to add your file loader anymore, routines are provided
to register file loading and saving formats.
- (bug fix) Fixed the broken storage setup I introduced in the
previous version. This means that files are now correctly
loaded and that if an expression renders an error you will
still be able to access the information you stored.
Enjoy this new version,
Miguel
Gnumeric 0.4
From miguel Wed Dec 16 23:16:34 -0600 1998
From: Miguel de Icaza <miguel@nuclecu.unam.mx>
To: gnumeric-list@gnome.org
Subject: New version of Gnumeric has been released.
X-Lost: In case of doubt, make it sound convincing
Hello guys,
A new version of Gnumeric has been released as part of the GNOME
libraries code freeze.
I have not been very active the last two months in Gnumeric due to
the freezing of GNOME (I worked a lot on the file manager issues), but
I will soon be back working in the spreadsheet.
Michael Meeks and Bruno Unna did an awesome job while I was doing
this: They added Excel file importing. That is all I can say. Some
stuff is missing, yes, it will get added, yes.
During the last few weeks Morten Welinder has been reviewing the
Gnumeric code and making very good suggestions to the coding style as
well as making sure we keep Gnumeric in a nice way. I am very
thankful for his input.
Jakub Jelinek made the scrolling code be smarter than my previous
attempt at scrolling, it is now definetly usable.
Code for attaching notes to cell is completely on the code. The
only problem is that right now comment is hardcoded in the source
code. We need a nice dialog box for this.
Mark Probst added some Guile support (this as well as the other
plugins is completely optional), some neat things can be done with it,
make sure you check the distribution directory.
Exponentiation has been implemented (all the code was there, I just
had forgotten to add the line to the grammar).
Some more architectural work has been going on: named-cell range
code is there (not finished but there). Also, some code for
referencing the cells in other sheets or workbook is there.
I still need to figure out a way to encode this into the
expression. I would appreciate any input on this issue: There are
various possible solutions, one of the is creating a special OP_ that
would represent a lookup into an non-local sheet. The other is to
define this as a function and finally, it could be done as a special
cell type.
Also, I have dropped the "entered_text" information I kept on the
cell. Now the cell value is stored either as a value or as an
expression tree and decoded when the user requires it. This was
required for a number of things (one of them being a nicer way to
share cell expressions during copying, and for the excel format and
the autofill code got definetly simpler and more maintainable).
Various display and scrolling glitches were fixed as well. But in
the process, I somehow broke the object-drawing code. I have not
researched this yet.
The initial support for CORBA is in, but it does not actually do
anything, it is just the setup for launching the Gnumeric server.
Owen Taylor made Gnumeric accept dragged files, you can now drag files
from the file manager into the spreadsheet, on this topic: the date
routiens now use GLib's gdate instead of the gnome-libs libDate
routines.
You can fetch it from:
ftp://ftp.gnome.org/pub/GNOME/sources/gnumeric-0.4.tar.gz
Enjoy,
Miguel.
