Gnumeric 1.8.2
Hans de Goede:
* Fix broken xls issues. [#505330]
Jean:
* Fix corrupted-xls-file problems. [#514513] [#515343] [#515873]
[#515876] [#518939]
Morten:
* Fix loading of solver constraints.
* Fix solver issue. [#512500]
* Fix corrupted-xls-file problems. [#512984] [#513005] [#513313]
[#513317] [#513361] [#513364] [#513551] [#513605] [#513608] [#513790]
[#513787] [#513835] [#513963] [#514229] [#514230] [#514295] [#514435]
[#514436] [#514437] [#514506] [#514510] [#514630] [#514637] [#515155]
[#515269] [#515275] [#515335] [#515336] [#515339] [#517106] [#518939]
* Fix non-ascii export problem. [#511135]
* Band-aid evaluation problem with broken xls. [#513559]
* Fix circular array formula problem.
* Work around Qt theme bug. [#512752]
* Fix paste-as-text bug. [#514438]
* Fix corrupted-mps-bug. [#517141]
* Fix corrupted-qpro-bugs. [#517144] [#517376] [#517591]
* Fix corrupted-sylk-bug.
* Make <control>KP_Subtract work as <control>minus. [#516358]
* Make <control>KP_Add work as <control>plus.
* Fix corrupted-applix-bugs. [#517778] [#520873]
* Fix sylk importer's format handling.
* Fix memory allocation failure for huge .gnumeric files. [#519319]
* Fix mstyle problem. [#519451]
* Fix auto-fill problem. [#519680]
* Fix corrupted-gnumeric-bug. [#519761]
* Fix insert-time problem.
--------------------------------------------------------------------------
Gnumeric 1.8.1
Jean:
* Fix graph paste. [#507342]
Jody:
* Fix cell comment positioning problem. [#506017]
Morten:
* Fix NPV doc problem. [#506160]
* Fix python compilation problem. [#509023] [508988]
* Fix DSUM crash. [#509427]
* Fix insert-current-date locale problem. [#508237]
* Fix xls read crash. [#505330]
* Plug csv leak.
* Fix inter-sheet cut problem. [#511706]
--------------------------------------------------------------------------
Gnumeric 1.8.0
Andreas:
* Fix print area bug [#502206]
* Fix paired t-test [#504256]
Jean:
* Fix import/export of line styles in xls files. [#502968]
Jody:
* Fix cell comments in presence on merged cells. [#503392]
* Support enter_moves_dir == NONE. [#500718]
* .gnumeric support for persisting grid colour.
* Fix clipboard for regions with merges/styles but no content. [503634]
Morten:
* Fix a handful of rich-text editing bugs. [#470089]
* Fix xls chart import problem. [#501656]
* Fix crash relocating set expressions. [#502781]
--------------------------------------------------------------------------
Gnumeric 1.7.91 (rc2)
Andreas:
* Fix formula guru. [#363871]
* Remove apparently confusing textview in the preference
dialog [#380080]
* Fix header configuration crash [#499717]
* Fix sensitivity of buttons in header/footer configuration [#499719]
* Fix sheet object printing bug [#499913]
Jean:
* Import/export radar plots axes. [#499349]
Jody:
* OFFSET use size of input range. [#497294]
* Finish .gnumeric i/o support for explicit page breaks. [#499339]
* Update the .gnumeric schema to handle modern content. [#499378]
* Make xlsx import more defensive against unsupported bits.
* Fix xlsx round trip of margins. [#499377]
Morten:
* Fix crash in dependency code for named expressions. [#498347]
* Fix yet another jumpbox problem. [#499722]
* Fix Find dialog problem with hidden sheets. [#499723]
* Fix pane-related critical. [#499905]
* Fix critical in series filling. [#499984]
* Fix critical related to shared views. [#499680]
--------------------------------------------------------------------------
Gnumeric 1.7.90 (rc1)
Andreas:
* Speed up pagination
* Account for repeating rows/cols when scaling automatically
* Load header & footer info from file
* Print headers and footers
* Reenable header/footer customization
* Add do-not-print flag to sheets. [#371754]
* Allow multi-line headers and footers
* Allow nicer entry of header/footer fields [#122175]
* Fix gtk issues triggered by sorting dialog.
* Fix printing of background of merged cells. [#497478]
* Allow inclusion of cell content in header/footer. [#162480]
* Add faster way to switch orientation. [#497438]
Jean:
* Print images.
* Fix FMR in solver dialog. [#496052]
* Fix markers shapes and objects stack order when importing
xls files. [#344950]
* Fix transparent background import from xls.
Jody:
* Fix visibility filtering for clipboard export. [#496985]
* XLS export of hyperlinks. [#81718]
Jon KÃ¥re:
* Fix clipboard export. [#496187]
Morten:
* Make pdf exporter able to print specified sheets only.
* Make it possible to set page size for ssconvert's pdf exporter.
* Fix date entry problem with yyyy-mm-dd formats. [#494387]
* Fix FMR during workbook destruction.
* Fix UMR when moving cells.
* Validate names before defining them.
* Fix gtk issues triggered by sorting dialog.
* Improve initial appearance of quit dialog.
* Plug printing dialog leak.
* Fix just-in-time evaluation problem.
* Fix minor parse problem for faulty inter-workbook references.
* Fix interaction between re-spanning and manual recalc. [#495879]
* Refuse to jump to invisible sheet. [#496304]
* Fix rtl display problem. [#496304]
* Plug leak in oleo import. [#496867]
* Fix g-critical problem with editable labels' cursors.
* Plug excel exporter leaks. [#497191]
* Make sure =<right> produces a relative address.
* Improve recent-files integration.
* Fix CHITEST crash. [#497477]
* Fix a pile of CHITEST corner cases.
* Fix a pile of FTEST corner cases.
* Improve error message for xls export with excess function arguments.
* Fix a pile of TTEST corner cases.
Oliver Burnett-Hall:
* Fix R1C1 issued with defined names. [#409997] [#494318]
--------------------------------------------------------------------------
Gnumeric 1.7.14
Andreas:
* Print repeated rows and columns.
* Fix printing crash. [#491775]
* Reimplement down then across printing
Götz Waschk:
* Fix paradox plugin compilation. [#489030]
Hib Eris:
* ssconvert export options. (Code butchered by Morten.) [#170767]
Jody:
* Improve ODF (and .sxc) import.
* Improve ODF chart data import (ick).
* Add Snap-to-grid context menu command for objects.
* Fix Data -> Table and enable the UI.
Morten:
* Improve test suite.
* Fix clipboard text-target export problem.
* Add date convention to clipboard ranges.
* Update man pages a bit.
* Fix excel dual-format write crash. [#490828]
* Fix problem loading .gnumeric files. [#490859]
* Fix print crash. [#478552]
* Fix xls FMR. [#491472]
* Fix gnumeric sax loader UMR. [#492391]
* Make text exporter remember settings between invocations.
* Make text import handle ranges of files with >64k rows. [#370273]
--------------------------------------------------------------------------
Gnumeric 1.7.13
Jean:
* Export font in charts to xls.
* Export and import chart titles to/from xls. [#301720]
Jody:
* XLSX import chart axes, singletons, some styles.
* Merge in most of the win32 cleanup.
* Fix autofilters on win32.
Jon KÃ¥re:
* Fix python crash. [#461845]
Morten:
* Fix minor date entry problem.
* Fix minor time entry problem.
* Fix page setup crash. [#476467]
* Fix scenarios. [#477410]
* Fix sheet filter crash . [#477417]
* Fix print crash. [#478475]
* Switch to new tooltip api.
--------------------------------------------------------------------------
Gnumeric 1.7.12 'Rocks for Rob, Roses for Harlan'
J.H.M. Dassen (Ray):
* Added infrastructure to render the DocBook documentation as PDF.
Jody:
* Store objects in visible order in .gnumeric files. [#438933]
* Make SMALL/LARGE support implicit intersection. [#343176]
* XLS import for Form combos/lists source ranges. [#451384]
* Remove warning when combo objects updated.
* Repeat action being activated by F4 while editing. [#461284]
* SUM(INDIRECT:INDIRECT) XL compat outside arrays. [#395926]
* Merge UI layer back into WBCGtk, no more arbitrary split.
* Use pygobject instead of pygtk
* Use utf-16 encoded cmd line args on windows. [#361321]
* Fix XLS import of workbook local hyperlinks.
* XLSX import/export of hyperlinks.
* XLSX import/export of validation and input messages.
* Basic XLSX import/export of charts.
* ROW/COLUMN return vectors not matricies. [#Harlan Grove]
Morten:
* Fix undo column/row insert/delete for arrays. [#463834]
* Fix undo column/row delete for objects.
* Fix undo of sheet objects pushed off the sheet.
* Fix auto-correct issue. [#463996]
* Fix handling of named expressions when inserting or deleting
columns or rows. [#123649]
* Validate defined names. [#346223]
* Fix 64-bit issue for non-GNOME build. [#465545]
* Allow relative formulas in name dialog.
* Make test suite a bit more robust.
* Fix date entry problem. [#472760]
--------------------------------------------------------------------------
Gnumeric 1.7.11
Andreas:
* Save and restore default paper, margins and various
other print settings
* Handle differences in page setup between sheets when
printing multiple sheets
* Fix handling of "print even if only style". [#438743]
* Implement printing of row and column headers
* Fix saving of null header/footer items [#449836]
* Fix TINV for large degree of freedom
Jean:
* Fix check for long double support in goffice.
* Import legend and axis labels fonts from excel
in charts. [#437858]
* Fix performance issues in float_range_function2 and
fn-tsa plugin.
Jody:
* Fix drawing of large cursor while sheet scrolls. [#444610]
* Fix drawing of merged cells in RTL. [#442463], [442467]
* Fix editing in RTL, and for merged cells.
* Properties to store fine tuned capabilities in protected sheets.
* Read/Write of protected sheet capabilities for XLS/XLSX.
* Move the OpenPkg support code into libgsf from our xlsx plugin.
* Fix placement of validation combo in merged cells.
* Eval validation functions as arrays.
* Make Morten's pdf exporter available from gnumeric too.
* Start to implement limits to selection in protected sheets.
* Handle array expressions in SYLK importer.
* ODF import/export for hidden and RTL sheets.
* Fix redraw of spanning cells when toggling RTL.
* Work around ODF's lack of a default col/row style.
* Fix crash in t-test. [#450676].
* Sylk import support for arrays, and encoding.
* Sylk export.
* Configurability for which direction <Enter> moves.
* Calc property import/export for xlsx.
* Update validation combo moving between identical styles. [#453525]
* Patch the problems found by coverity.
* Fix win32 docs. [#443726]
* Be more flexible about range relocation for ins/del cells. [#439347]
Morten:
* Make ssconvert able to export to pdf. [#381965]
* Fix loading of tab text colour. [#437743]
* Improve handling of foreign recently-used files. [#438918]
* Improve save-on-exit dialog.
* Fix potentially confusing save-in-wrong-format-on-exit bug.
* Tentatively fix issue with recent Pango. [#440514]
* Provide good mime type for recent documents.
* Fix localized-format problem in cell format dialog. [#442657]
* Fix R1C1 problem. [#443832]
* Fix performance problem when selecting large areas. [#445617]
* Fix loading/saving of R1C1 attribute. [#448714]
* Fix overflow problem when int!=long. [#458158]
Nils Kanning:
* Fix the inline documentation for python addins. [#412804]
--------------------------------------------------------------------------
Gnumeric 1.7.10
Andreas:
* Reimplement scaling
* Save orientation
* Show paper preview
* Show unit selector in print dialog
* Add margin adjustments
Jean:
* New Time Series Analysis plugin.
Jody:
* Fix inadvertent relocation of reference on other sheets. [#433907]
--------------------------------------------------------------------------
Gnumeric 1.7.9
Andreas:
* Switch to gtk print from gnome print
(some feature regression)
Jody:
* Import and Export for inline arrays in ODF. (now patched in OOo)
* Export cell comments to xls.
Morten:
* Require three digits after a thousands separator in order to
accept it as a number. [#415007]
* Fix autofill issue. [#414815]
* Fix criticals with frozen panes. [#308562]
* Fix rich text problem. [#417632]
* Use GtkRecentManager. Fixes #115112.
* Ignore local files that no longer exist. [#67453]
* Fix XL load crash. [#418868]
* Fix format guessed for $123,456.78 [#423603]
* Perform UTF-8 normalization during search. [#421678]
* Allow selecting a locale for sorting. [#427019]
* Make sure ssindex doesn't update the recent-files list.
* Update recent-files on load and save. [#152584]
--------------------------------------------------------------------------
Gnumeric 1.7.8
Morten:
* Fix FACT. [#410005]
* Fix gui problems after replacing pristine book. [#410365] [#410371].
* Fix R1C1 preventing the use of, e.g., COS and RADIANS. [#410609]
* Fix editing of out-of-range numbers with date format.
* Improve CopyDown and CopyRight. [#112847]
* Make file chooser show more files for load.
Oliver Burnett-Hall:
* Fix R1C1 problem in formula guru.
--------------------------------------------------------------------------
Gnumeric 1.7.7
Jody:
* Patch a leak in DataTables.
* Fix AutoFormat loading.
* Add support for the standard builtin formats in xlsx.
* Fix col/row grouping deletion. [#388505]
* Basic ODF AutoFilter partial import/export.
* Some property dialogs for combos and lists.
Morten:
* Unify layout and string value formatting.
* Make sheet duplication handle sheet-local names.
* Make sheet duplication change sheet references to point to
the new sheet. [#158825, #158691]
* Fix parsing of new workbook-level named expresions. [#306686]
* Fix xml loading of names that refer to other names.
* Fix crash from old-style file. [#392054]
* Fix cell contents reading from old v7 files. [#392054]
* Make sure we call g_thread_init early. [#392050]
* Fix CRITICALs with DOLLAR.
* Fix progress display for .gnumeric and thus splash. [#392546]
* Don't allow "1D2" [win32] or "0x1234p1" as numbers. [#393347]
* Fix redraw problem. [#393359]
* Don't complain over encoding-less documents unless there is a reason.
* Don't pull in popt. [#396329]
* Fix OO import crash. [#396200]
* Fix part of problem loading style conditions. [#397679]
* Fix generated libspreadsheet-1.7.pc [#399550]
* Fix tsv import problem. [#404264]
* Fix R1C1 crash. [#407274]
* Fix R1C1 issues. [#407247]
--------------------------------------------------------------------------
Gnumeric 1.7.6
Jody:
* Fix sax import of autofilters. [#383400]
* Fix autofilter lists with only 1 combo. [#383400]
* Implement sax import of sheet objects.
* Implement List and Combo objects.
* Avoid pixel dirt when drawing hidden cursor. [#365960]
* XLSX support for import and export of autofilters.
* Right click on combos/list always brings up popup. [#135966]
Morten:
* Fix title problem. [#382643]
* Fix sax loading of comments.
* Fix scaling and rtl orientation of comment marker. [#381700]
* Set a saver after loading with the sax loader.
* Implement undo for sheet object widgets. [#384136]
* Work around a gcc bug.
* Improve number formatting.
--------------------------------------------------------------------------
Gnumeric 1.7.5
Jon KÃ¥re:
* Fix zoom preference. [#378043]
Jody:
* Improve xls import/export of 'best fit' column widths. [#378560]
* Implement Validate from List cell combo. [#375620]
* Fix xls import of checkboxes with empty labels. [#375620]
* Put the style feedback onto an idle handle to improve cursor
responsiveness.
* Improve autofill/validation combos.
- Alt-Down opens a combo in the current cell
- Enter, Alt-Up/Down selects within an open combo
- Drag autoscroll
- set initial selection for validate from list
- Home/End jumps to top bottom.
- Fix in RTL mode.
- List items unfiltered by other active conditions. [#114307]
* Fix .gnumeric import of col/row groupings. [#380015]
* SAX import for autofilters
* Fix XSD schema
- Add autofilters
- Add inputmessages
- Add Workbook Attributes
- Make it validate
* Start simplifying the object anchor types for xlsx.
* Fix RTL text display.
* Fix a collection of dialog leaks.
Morten:
* Add automatic test framework.
* Fix sc import of functions with no args.
* Prevent ssconvert from updating the recent-files list.
* Fix goal-seek crash. [#377961]
* Minor goal-seek improvements. [#379234]
* Fix critical in name definition dialog.
* Improve precision of goal-seek.
* Fix a case where goal seek went outside the interval.
--------------------------------------------------------------------------
Gnumeric 1.7.4
Jody:
* Fix splash.
* Fix crash.
* Make auto filter combo a real widget.
Morten:
* Fix ssconvert error handling.
* Fix RATE.
--------------------------------------------------------------------------
Gnumeric 1.7.3
Eduardo Lima:
* Make printing support optional. [#331948]
Jon KÃ¥re:
* Fix another clipboard crash. [#362993]
* Fix encoding of mailtos. [#148550]
* Fix crash in sheet label context menu. [#363261]
* Fix crash when deleting same sheet from two views. [#364082]
* Fix crash reading inconsistent file. [#312010]
* Remove "deactivate all" button from plugin manager.
* Fix crash due to invalid border line type. [#364658]
* Fix crash on loading Excel file with unusual text box. [#340293]
* Fix loading Excel files with unusual cell merges. [#331190]
* Update window list when closing view. [#366335]
* Fix crash when attempting to edit locked cell. [#367870]
* Fix initial sizing bug. [#368825]
Jody:
* Rewrite expression relocation logic.
* Add accelerator (Alt-=) for auto-sum.
* Make paytype handler more flexible.
* Fix DIF import/export.
* Add accelerator for group/ungroup and inc/dec indent.
* Make clipboard faster.
* Support exporting only visible content to clipboard.
* Fix checkbox objects.
Joseph Pingenot:
* Add more conditional format types.
Morten:
* Basic life support for perl-loader. [#362911]
* Fix csv problems. [#359269]
* Fix crash deleting and adding sheets. [#363549]
* Fix jump-to-area crash. [#363977]
* Fix search crash. [#364085]
* Fix IPMT, PPMT issues.
* Start fixing issues with sheets being deleted underneath a
dialog. [#364291]
* Fix undo/redo problems in cases where all sheets might become
temporarily hidden. [#366477]
* Fix crash relating to workbook disposal. [#366570]
* Fix edit-line weirdness. [#367870]
* Cleanup g_free and g_strdup calls. [#369661]
* Fix undo for sheet object copy. [#308300]
* Fix redo for sheet object copy. [#308300]
* Add a bugzilla component for bug-buddy. [#348829]
* Make WorkbookView a more proper gobject.
* Fix autosave crash.
* Handle parsing of "2005/12" and "12/2005".
* Handle parsing of "1-10" in non-date cells. [#376090]
* Handle new documentation format in the function selector.
* Improve formula editor a bit.
* Fix sheet object selection problem. [#376866]
--------------------------------------------------------------------------
Gnumeric 1.7.2
Emmanuel :
* New look for col/row headers.
Jody :
* Fix off by one pt, printing vertical borders in RTL mode. [#317662]
* Handle the last (we hope) MS XL array iteration. [#361074]
* Fix inversion check for cell relocation. [#350222]
Jon KÃ¥re:
* Fix import of certain hyperlinks from Excel.
* Fix bug which hid file type selector when saving images.
* Fix crash when storing to clipboard manager. [#321714]
* Fix warnings when storing to clipboard manager. [#342580]
* Fix warnings when pasting objects over clipboard. [#308569]
* Fix import of images in Excel files written by PHP/Perl. [#155696]
Morten:
* Fix font preview crash.
* Fix performance problem with big paste. [#359392]
* Fix paste crash. [#360672]
* Fix transposed pasting of arrays. [#349288]
* Fix sharing problem with regular pasting of arrays.
* Fix toolbar hiding/unhiding.
* Fix inter-workbook crash. [#323811]
* Re-implement sharing of top-level expressions.
* Fix stale sheet pointer problems in clipboard. [#323762]
* Fix growing button in sheet manage dialog. [#362558]
* Expand default stack. (With JKH.) [#92131]
* Force expression sharing on load.
--------------------------------------------------------------------------
Gnumeric 1.7.1
Andreas:
* Fix ngettext calls [#345027]
* Use ngettext to support correct plurals [#123860]
* Fix zoom-dialog labels [#311206]
* Initialize locale selector in stf export.
* Added Sheet_Title predefined name [#342542]
* Improve Define Names dialog [#345896]
* Fix button sensitivity in Define Names dialog in presence
of identical workbook and sheet scope names
* Remove some warnings on AMD64 [#346045]
* Add "switch scope" button to define names dialog [#345896]
* Add "print area" to sheets [#164058]
* Fix writing of floating point preference values under
--without-gnome [#346433]
* Added menu items to set/clear/show the print area of a sheet
[#164058]
* Add a latex-exporter for an unformatted table fragments [#325980]
* Implement content export in the OpenDocument exporter.
* Fix undo text for definition/update of names [#346962]
* Fix interaction of merged cells, cell comments and undo [#347536]
* Fix undo problem for paste [#347826]
* Fix crash when jumping to Print_Area [#349686]
* Adjust width of tables in LaTeX export [#350625]
* Check for empty styles.xml and meta.xml files in OpenDocument
import [#350644] Patch by sum1_abi@yahoo.com.
Jean Brefort:
* Smoothing generated by Excel graphs supported. [#349457]
* Don't use auto_shape or auto_dash when plot has no marker/line
and series have while importing from excel. [#319727]
Jody:
* Fix ODF sheet name import ('aa''a' == aa'a).
* Don't lose the orientation of line objects when copying.
* Add context menu binding for selected objects. [#338616]
* Allow File->Save even when editing an object. [#338619]
* Only install util man pages if they are built. [#341916]
* Handle Tab/Return movement. [#88167]
* Re-enable R1C1 parsing.
* Remove GnmCell::col_info to shrink cell by a ptr
* Remove ColRowInfo::pos to shrink col/row by an int
* Update schema a bit.
* Update GLPK to version 4.9.
* Make ODF merge cell import more flexible. [#347263]
* Restore ctrl-a as alternative for select-all.
* Select All no longer moves the edit_pos.
* Extend GDA type conversions, and make compatibile with 1.9.103.
Morten:
* Moved font metrics to goffice.
* Fixed font initialization.
* Fix minor mouse cursor problem. [#341877]
* Improve handling of invalid xls files. [#341917]
* Try harder not producing CRITICALs on buggy files.
* Fixup expression sharer interfaces.
* Fix scientific-number editing problem. [#342583]
* Reduce memory consumption for dependency storage.
* Fix CRITICAL for --debug-deps on startup.
* Fix sheet duplication problem related to the solver.
* Fix stf import crash. [#345477]
* Fix problems with decreasing month autofill. [#346028]
* Fix CRITICALs for =[]. [#347916]
* Fix problems with sheet reordering. [#349255]
* Fix clipboard code's memory usage. [#348922]
* Fix ods import of time values. [#355943]
Shixin Zeng:
* Add \L{} escape to LaTeX exporter (The content of the
braces is being inserted literally into the LaTeX file.)
--------------------------------------------------------------------------
Gnumeric 1.7.0
PACKAGERS :
If you store supported mimetypes anywhere other than gnumeric.desktop you
will need to resync.
Andreas:
* Fix lost minus signs in latex output. [#325656]
* Add has-header preference to the sort preferences. [#327278]
* Fix sort dialog crash. [329236]
* Make sort dialog range entry sensitive to keyboard entry.
[#329250]
Harun Vos:
* Fix Win32 crash-on-start for pre-WinXP.
Ivan, Y.C. Wong:
* Fix Gdk-WARNING when cutting or copying cells. [#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. [#336212]
* Export underlines to html.
* handle ctrl/shift space during rangeselection.
* Fix path to docs. [#330339]
* Handle canceling object drag motion. [#314866]
* Fix image drags with previously selected objects.
* Handle oddness in xls files generated by 'miniCalc' [#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. [#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. [#334257]
* Implement xls saving/loading of "protected" attribute. [#330129]
Luciano Miguel Wolf:
* ODS import improvements.
Morten:
* Fix COUNTBLANK.
* Fix auto-filter formatting issue. [#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. [#323128]
* Plug leak.
* Fix sheet quoting problem. [#323546]
* Improve Excel compatibility of BIN2DEC, BIN2HEX, and
BIN2OCT. [#323787]
* Fix crash on xml load. [#323888]
* Fix file corruption on saving scenarios. [#323927]
* Fix a pile of leaks in solver and scenario saving and loading.
* Fix leaks in solver dialog.
* Fix parser leak. [#301127]
* Fix NetBSD compilation. [#324358]
* Fix solver dialog crash. [#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. [#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. [#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. [#329236]
* Fix LCM and GCD for large arguments.
* Switch gnumeric option handling to GOption.
* Switch ssconvert option handling to GOption. [#154395]
* Switch ssindex option handling to GOption. [#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. [#56168]
* Allow "20041231:103355".
* Fix bogus duplicate-accelerator warnings. [#324692]
* Fix criticals relating to toolbar combos for very narrow windows.
[#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. [#331916]
* Go to end of text on F2. [#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. [#332932]
* Fix dbf import issue. [#332878]
* Fix menu feedback when replacing a pristine workbook
by a file.
* Fix stf text import speed regression. [#333407]
* Fix XIRR issues. [#333620] [#333631]
* Fix autofilter for text that looks like numbers. [#333809]
* Plug leak in SEARCH.
* Fix printing issue with wrapped, right-aligned text. [#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. [#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. [#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. [#334724]
* Fix theming problem. [#309060]
* Fix validation problems. [#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. [#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. [#337215]
* Improve handling of strings that look like numbers or expressions
during search-and-replace. [#167304]
* Fix rendering problems for values with attached formats.
* Fix button ordering on Win32. [#170479]
* Fix rendering on fractions that round to 0. [#314210]
* Add undo handling to deletion of names. Fix recalc are removing
or defining names. [#312610]
* Improve editing of cells containing currency amounts, fractions,
or percentages.
* Improve 1-2-3 import for Chinese files. [#337968]
* Fix 1-2-3 format handling.
* Fix parsing of "4/2005". [#166413]
* Fix initial sheet selection in the sheet-manage dialog. [#331984]
* Make autofill understand 3Q01, 4Q01, 1Q02, ... [#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. [#161890]
* Add locale choice on text export. [#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. [#338694]
* Fix crash on save+quit. [#338847]
* Auto-fit width when entering new values or formulas.
* Auto-fit height when entering string constants.
* Fix fits for wrapped text. [#67351]
* Fix minor undo problem for applying a height-changing format.
* When undoing or redoing, move to where things happen. [#114077,
#154705]
* Add tooltips to a few combos. [#339122]
* Improve stf import format guessing. [#332997]
* Improve stf import for sloppy clumps of whitespace. [#339297]
* Improve stf import's keyboard navigation.
* Fix applix import issue. [#339190]
* Fix critical. [#339793]
* Make "General" format pixel-perfect.
* Fix zoomed rendering issue. [#310492]
* Warn for confusing text-formatted-non-string situation. [#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. [#51272]
* Fix editing of comments attached to merged regions.
Jon KÃ¥re:
* Hand clipboard off to clipboard manager when exiting.
* Handle non breaking space in html input.
* Handle .xls containing html fragment [#311879]
Nick Lamb:
* Fix CONVERT crash. [#323678]
Philo Vivero:
* New loan template. [#317201]
--------------------------------------------------------------------------
Gnumeric 1.6.1
Allin Cottrell:
* Save configuration in non-gnome case. [#310354]
Jean Brefort:
* Use localized decimal separator. [#80139]
Jody:
* Unfreeze panes if the drag handles are pulled outwards.
* Adjust ctrl-~ vs ctrl-!
* Some R1C1 fixes
* More SpreadsheetML from MS Office XP.
* Some OpenDoc import extensions.
* Minor fixes for auto-fill
* Enable a chart importer in the experimental xml sax importer.
Lukasz Stelmach:
* Fix python binding for RangeRef::end.
Eduardo Lima:
Renato Araujo:
* Maemo/Hildon port to Nokia 770
Morten:
* Fix content probing of csv and tsv files. [#318419]
* Import formats from Lotus 1-2-3 files.
* Import column widths and row heights from Lotus 1-2-3 files.
* Handle Lotus 1-2-3 functions whose names differ from the ones
we use better.
* Read basic info from wk4 files.
* Fix issues with new function docs method.
* Fix OO import crash. [#320818]
* Fix Excel save crash. [#321009]
* Plug minor leak.
Philippe Lelong:
* Fix issue with PRICE (and probably related functions).
--------------------------------------------------------------------------
Gnumeric 1.6.0
Andreas:
* Preload selection in "Define Names" dialog. [#316406]
Jean Brefort:
* Fix crash when deleting plot with dynamic deps.
* Fix localization issues. [#318042][#318043].
Jody:
* Snap objects right in RTL mode. [#316026]
* Finish Data -> Table evaluation
* Avoid entering "" for every keystroke when using gtk-2.8
* Fix xls import/export of markers for radar plots.
* Fix rotated text with pango-1.10 [#316597]
* Update auto-expr after a recalc [#314867]
* Use Emmanuel's ideas to improve the frozen pane drag handles.
* Enable super/subscripts.
* SpreadsheetML importer.
Morten:
* Fix C99ism.
* Fix rare dependency crash.
* Warn if running with buggy pango_attr_list_splice.
* Improve stf import gui for multi-byte encoded text. [#316816]
* Fix xml-io's name parsing. [#317427]
* Fix .gnumeric saving of summary items. [#318254]
* Import some style info from Lotus 1-2-3 files.
* Fix infinite loop in pdhyper.
--------------------------------------------------------------------------
Gnumeric 1.5.90
Jody:
* quotes for pure strings in expressions for xml in/out [#313460]
* Fix F4 cycling of abs/rel in mixed mode range refs
* Check all format tuples for a match [#85950]
* Escape cancels object drag. [#314866]
* F2 while editing jumps focus to entry. [#314869]
* XLS in/out for Data -> Table
* 2d Data -> Table support
Morten:
* Fix tooltip problem. [#314865]
* Throw a minimum of effort at a Lotus importer for modern
versions. [#314875]
--------------------------------------------------------------------------
Gnumeric 1.5.5
(No code changes -- translations only)
--------------------------------------------------------------------------
Gnumeric 1.5.4
Clytie Siddall:
* Audit strings. [#312746] [#312986]
Jean Brefort:
* Fix crash on close related to graph plugins. [#313463]
Jody:
* Fix lost background colours. [#314207 and others]
* Add some drag handles for graphicly creating frozen panes.
* Fix sheetview confusion. [#314208]
Morten:
* Fix harmless, but ugly, error message on xls save.
* Fix solver crash. [#314025]
* Fix solver coefficients.
* Package lp_solve into a single file and sanitize its API.
Update to lp_solve 5.5 in the process.
* Fix dependency crash. [Part of #314207]
* Fix theming bug. [#307783]
* Fix crash related to changing colours of sheet tabs.
* Fix rich text editing problem. [#314209]
* Be consistent about dialog separators. [#314306]
* Fix print problem with page numbers. [#314520]
--------------------------------------------------------------------------
Gnumeric 1.5.3
Ivan, Y.C. Wong:
* Fix recent files list on win32. [#308302]
* Fix non-latin characters rendering of fonts sans, serif and monospace
on win32. [#161027]
Jean Brefort:
* Copy charts (to abiword).
J.H.M. Dassen (Ray):
* Bumped goffice build dependency.
Jody:
* Handle ROW/COLUMN with no argument in an array.
* Fix problems with row height resizing on win32. [#163414]
* XLS, SAX, & DOM in/out for conditional Formating.
* SAX in/out for input messages.
* SAX in for hyperlinks.
* Conditional Formating for backgrounds.
* Conditional Formating for borders.
* Store the current settings before previewing. [#301494]
* Fix F4-abs/rel state rotation after R1C1 breakage.
* Fix leak in xls chart import. [#157058]
* Fix object movement and snap to grid in RTL.
* XLS import of image fills. [#127756]
* XLS import of font for chart labels.
* Don't put extra quotes around exported series names. [#152317]
* Keep images hidden until they are sized. [#308301]
* Warnings when consolidating single columns. [#308431]
* Improve sync of cell editing and editline for autocomplete. [#308303]
Jon KÃ¥re:
* Improve sc/xspread import.
* Export page orientation to Excel.
* Fix top margin/header interaction bug in page setup. [#310055]
Morten:
* Make changes to toolbar visibility permanent.
* Fix stf export quoting problem. [#308109]
* Fix stf export format problem.
* Prevent sheets from being renamed to "".
* Fix IRR. [Debian #315625]
* Eliminate old sheet reorganize support code.
* Make ssconvert able to save to stdout ("fd://1").
* Fix repeat-setting-border crash. [#310924]
* Fix typo that managed to get its own bugzilla entry. [#312823]
* Fix problem with save. [#312930]
* Improve screen-vs-print line breaking situation. [#312912]
* Fix crash changing font. [#313257]
* Fix crash on finalizing sheet with objects in it.
* Fix sheet-remove crash related to dependencies. [#312794]
--------------------------------------------------------------------------
Gnumeric 1.5.2
Andreas:
* permit formula guru to add array functions
Ivan:
* (Win32) Fix opening files with non-ascii names when users "open"
them in explorer. [#304874]
* Enable libspeadsheet build
* (Win32) Fix the bug that d&d from explorer doesn't work in
gnumeric. [#304074]
Jody:
* Tweak the errors from LOGNORMDIST, CONFIDENCE, STANDARDIZE, and
NORMDIST to match MS Excel.
* After a command refocus controls for the current view. [#165700]
* Fix 'Begins with' vs 'Ends With' for autofilters.
* Autofilter string equality is stronger than containment [#172355]
* Buttons in sheet manager dialog should not strech vertically.
* Stub for MS Excel's ASC function, which is unncessary in gnumeric.
* Make range clipping more efficient. [#164950]
* Fix advanced filter for inputs that do not start at col A. [#165734]
* Fix xls import of names calling fwd declared names. [#166611]
* Fix string generation for arrays.
* Don't hide columns < 4pts wide on import. [#304558]
* Rich content from MS Excel clipboard [#305405]
* Fix warning while importing pre XL-95.
* Fix adjustment object handling [#167584].
* Be more careful what we assume is a header [#165061].
* Use sheet specific print settings when printing a workbook. [#163589]
* Fix small positioning glitch when creating widgets. [#304559]
* re-enable experimental sax importer after goffice split.
* Improve handling of some odd XL operators.
* Remove warning when nudging during object creation. [#164779]
* Delete while editing should not clear the cell. [#165172]
* R1C1 support.
Jon KÃ¥re:
* Don't output the xml declaration for xhtml. [#303827]
Michal Kaukic:
* Fix solver for affine objective functions. [#171025]
Morten:
* Fix SUMIF even more. [Debian #308346]
* Fix horizonal alignment of rotated numbers broken by fix to
#303292.
* Fix CRITICAL when undoing borders.
* Improve multiline rotated text. [#167544]
* Fix Excel load crash. [#303923]
* Speed up exit on large sheets with lots of names, such as the
one from #303923.
* Clean up dependencies somewhat.
* Simplify expressions used for defined names for single cells.
* Fix redo crash. [#305007]
* Fix auto-complete deactivation issues. [#305011]
* Fix recognition of accounting formats. [#305314]
* Fix unintentional format currency change. [#305313]
* Plug leaks.
* Work hard at not leaving passwords in memory, just in case.
* Add tooltips for ok_button, cancel_button, and func_button.
[#160344]
* Fix paste problem. [#305404]
* Fix brown bag text import problem. [Later reported as #305624]
* Improve R.QPOIS accuracy, efficiency, and termination.
* Improve R.QNORM's accuracy in the long double case.
* Improve R.QCAUCHY's accuracy.
* Add new R.QHYPER function.
* Fix xml SAX import issue for array formulae.
* Fix xml export of shared array formulae.
* Fix number matching problem. [#306254]
* Fix R.PBETA screwup for log case.
* Fix problem with hiding sheets.
* Fix sheet removal undo to also undo changes to names and
cells in other sheets.
* Save and load visibility sheet attribute.
* Fix 3D deps crash.
* Fix 3D dependencies spanning more than one sheet. (I.e., all.)
* Fix dynamic dependency crash on exit.
* Plug leaks of sheet views.
* Fix CRITICAL in the "manage sheets" dialog.
--------------------------------------------------------------------------
Gnumeric 1.5.1
Andreas:
* Make ROUNDDOWN and ROUNDUP MSExcel compatible including the
strange handling for negative numbers. [#162682]
This breaks backwards compatibility to earlier Gnumeric versions
for these functions.
* Fix text colour in selected item in sheet manage dialog. [#170462]
* Fix NORMDIST description. [#167467]
David J Craigon:
* Allow ssconvert to specify importer. [#160069]
Ivan Wong:
* Fix image filtering for Win32. [#164589]
* Implement the Win32 registry connection.
Jody:
* Major re-org for goffice split.
* Fix xls import for fit to page.
* Fix OFFSET for asymmetric ranges [#166764]
* Fix SUMIF for asymmetric ranges [#166769]
* Import sheet visibility from ms excel
* Split function docs into a distinct catalog
* Decrease memory usage in clipboard.
* Simplify tiling when pasting a copy. [#87477]
* Be more flexible pasting full cols/rows in single cells. [#87528]
* Add vertical alignment DISTRIBUTED
* Fix xls in/out of rotation
Jon KÃ¥re:
* Don't crash on csv file with invalid unicode [#167190]
* Import html hyperlinks as hyperlinks.
* Fix session management bug when gnumeric is minimized. [#166769]
* Paste images from clipboard.
* Copy images and graphs to clipboard.
* Receive and send images by drag and drop.
* Don't clear clipboard when losing primary selection. [#300468]
Kasal:
* Modified the way generated files are handled by Automake.
* Some configure hacks to support po-functions.
Morten:
* Work around Pango bug causing XL save crash. [#166532]
* Fix Save-As GUI problem causing CRITICALs.
* Fix typos that managed to get their own bugzilla entries.
[#167495] [#302306]
* Improve auto-detection of separators for text files. [#167449]
* Fix some #decimals problems with print page setup.
* Fix saving.
* Fix crash when using --quit. Fix leak too.
* Fix rare crash on exit.
* Use unicode minus (U2212) for numbers. [#168467]
* Improve format selection dialog for text import.
* Constification.
* Use FooCanvas for rotation part of cell format dialog.
* Get rid of the last direct GnomeCanvas use.
* Clean up long double configuration.
* Fix save-as for non-local files. [#170308]
* Drop gtk+-bug workaround. [#162952]
* Make sheets even more object-like.
* Fix parsing problem with names that start out with something
that can be parsed as a cell, e.g., "K3P". [#170465]
* Improve auto-fixup of 1.0.x era non-ASCII Gnumeric files.
* Fix minor GUI problem with the format page of text import.
* Create new plugin with R.[DPQ]dist functions using the
R Project's naming and calling conventions.
Note: this is deliberately not yet in po-whatever. There are
tons of autogenerated strings and things need to settle down
a bit first.
* Fix modality issue causing crashes. [#170958]
* Use a better format for auto expressions.
* Improve undo description for rich text style changes. [#171637]
* Don't destroy target file when loading a saver plugin fails.
[#168581].
* Make sure we update our window menu when we create a new view.
* When we reopen insert->image, start in the directory we were
last time. [#143188]
* Fix conversion problems with stf export. [#126513]
* Improve text import for strange encodings. [#167191]
* Rework stf export code and fix crash-on-exit-causing leaks.
* Do something sensible when exporting dates and times as text.
[#128936]
* Fix uncompressed saving of .xml and .gnumeric (when requested).
[#173030]
* Improve extreme-case evaluation of quantile functions that are
computed by root searching, such as =BETAINV(0.52,1e-3,1e6).
* Improve accuracy of R.QF (and thus FINV).
* Fix TRIMMEAN.
* Fix MODE.
* Allocate some clipboard data in pools.
* Fix potential save-as crash.
* Fix spurious criticals. [#301581]
* Change various sheet things to use an object properties.
* Plug leaks with moving sheets.
* Use object properties for much of the {sheet,workbook}-control-gui
to sheet linkage.
* Fix multihead problems with popups.
* Fix crash for sheet-remove on sheets with local dynamic
dependencies.
* Implement CELL("sheetname", ...).
* Fix CELL with explicit sheet in the reference.
* Fix sheet reordering by dragging.
* Fix various theme related bugs. [#302902] [#302880] [#302882]
* Fix undo crash in connection with cloning sheets.
--------------------------------------------------------------------------
Gnumeric 1.5.0
Emmanuel Pacaud:
* Snap to grid mode when moving sheet objects with shift.
Jean Brefort:
* add scatter plots with spline interpolation.
* Box-plots.
* Fix crash in contour plots (#166051).
* Automatic bounds work with negative values in XY chart (#164593).
* Scrollbar and slider max values are now constant (#165173).
* Avoid recalculation of scrollbar and slider values when not
necessary (#166085).
J.H.M. Dassen (Ray):
* Generate an error when no proper UTF-8 filename is produced when
saving [Debian #291265]
Jody:
* RTL support.
* Another step towards the libgoffice split
Kasal:
* Some configure.in cleanup.
Morten:
* When using the new printing code, don't bother to generate
gnome print fonts for the old code.
* Improve search strategy for auto-completion.
* Fix crash for insert/delete column/row. [#165873]
* Fix text import crash. [#165617]
* Fix SUBSTITUTE. [#165996]
* Fix general format's use of "e".
* Plug dependency leak. [#159581]
* Fix fake rounding functions for very large numbers. [#166188]
* Eliminate old printing code.
* Clean out workarounds for old libraries.
* Avoid GnomeFont in printing.
* Fix .dbf import of floating point values. [#166311]
* Plug xls save leak. [#166561]
--------------------------------------------------------------------------
Gnumeric 1.4.2
Caolan McNamara:
* Improve python config test for ia64 [#161547]
* Handle invalid DIMENSIONS records in xls [#161534]
* Fix installation path for the docs [#161404]
Emmanuel Pacaud:
* fix legend update on pie label change.
* don't disable theming for xy plot with line or marker only.
Ivan wong:
* Fix Win32 detection of default date format. [#161793]
Jean Brefort:
* Fix crash in contour plots. [#163626]
* When saving, always ask when file exist and come back to the dialog
when user does not want to overwrite.
J.H.M. Dassen (Ray):
* XLS import for paper sizes for which gnome-print doesn't have a
name.
Jody:
* Install the man pages
* Backport some framework for RTL
* image import from xl95 [#157997]
* Double click on an object brings up prop page
* Fix warnings when selecting a widget
* Hide value for slider objects
* Don't crash when attempting to copy an un-copiable object [#162888]
* Fix crash deleting a shared view [#163452]
* Fix sax export of outlines
* Fix TYPE to allow non-scalar
* Use element 0 of an array returned in a non-scalar context [#162923]
* Fix MATCH. If type is unspecified default to 1 not 0 [#163040]
* Unnecessary row resize undoing format that did not resize [#163407]
* Remove adjustment of copied areas on ins/del col/row [#163408]
* XLS export for booleans and errors in arrays
* Make SUMPRODUCT ignore booleans and strings to match XL, and SUM
* Fix sizes of Bitstream Vera for xls export [#163406]
* Mouse events while editing with other vertical alignments [#163198]
* Fix zoom for rich text with explicit size [#163223]
* Fix race condition when creating drawing objects [#162631]
* XLS export for empty cols with non-default formats [#163409]
* Redo var width content when resizing all cols at once [debian #288157]
* Handle zero sized charts [#163939]
* Fix comment indicator position when zoomed [debian #290388]
* Some support for filled styles [#163438]
* XLS import/export for print header/footer [#155719]
* Some tuning for missing arg export to xls [#163236]
Matthias Drochner:
* Use non bash specific substitution for autformat templates [#161782]
Morten:
* Improve accuracy of pgamma and thus pchisq, ppois, qgamma,
qchisq, qpois, and more for extreme arguments.
* Make it possible to change rotation of formats.
* Draw rotated text.
* Print rotated text.
* Fix torn off undo/redo crash.
* Fix cell format dialog initialization problems.
* Doc fixes for ODD and EVEN.
* Fix rich text crash. [#161621]
* Fix inserting new characters into a rich text string.
* Fix deleting more than one character at once from a rich text
string.
* Fix rich text problem when starting from empty. [#161723].
* Vastly improve sorting speed for large ranges with formulas.
[#161909]
* Fix Help->Contents accelerator. [#162865]
* Make general format use "E", not "e", as appropriate.
* Simplify SUM. [#131588]
* Fix INT(-1) problem. [#163019]
* Fix rich text re-edit problem. [#163415].
* Fix rich-text insertion problem. [#163413].
* Fixed font/size/zoom selection problem. [#163412].
* Implement OOo's BASE and DECIMAL.
* Fix some error cases of LINEST/LOGEST not to crash.
Uwe Steinmann:
* Extend paradox importer to support additional types.
--------------------------------------------------------------------------
Gnumeric 1.4.1
Jody:
* Saved charts were 1 pixel larger than the stated size [#157732]
* Fix path to chart icons for win32 [#160046]
* Fix sax export for Validation [Debian #283999]
* Fix unintended object resize when clicking on the lower right resize
handle of existing object
* Break long words when wrapping text
Morten:
* Add bugzilla version number to desktop file. [#159371]
* Fix arrows' direction used for printing and saving. [#159922]
Spudun:
* tidy up lp_solve code to build under OS/X
--------------------------------------------------------------------------
Gnumeric 1.4.0
Andreas:
* Fix crash on empty file in lotus file probe. [#158126]
* Enable auto-correct initial caps exception list. [#158209]
* Fix removable of items from auto-correct initial caps
exception list. [#158207]
* Protect ABcD style strings from auto-correction [#124858]
* Rename graph guru's okay button [#152514]
* When undoing the deletion of sheet objects also recreate the
original ordering of objects. [#151609]
Jody:
* Pull the file open filters from the openers
* Enable ssindex
* Undo for objects deleted by pasting a cut region [#159365]
Harald Ashburner:
* Update derivatives.gnumeric
J.H.M. Dassen (Ray):
* XLS import for paper sizes known to gnome-print.
Morten:
* Fix crash with weird history items. [#157682]
* Fix print preview leak. [#158566]
* Fix stf import crash. [#159009]
--------------------------------------------------------------------------
Gnumeric 1.3.93
Andreas:
* Keep the recently used function list uptodate. [#156732]
* Fix default font selection in preference dialog. [#157238]
* Fix preference dialog window fraction selection. [#157239]
* Make various preferences setting changes apply to the current
gnumeric instance
* Add screen page to preference dialog and fine-tune its general
layout
* Replace text entry boxes in preference dialog with
checkboxes and spinbuttons.
* Ensure that the preference dialog inthe non-gnome build
looks reasonable.
Jody:
* Fix perl and python tests in configure
* Fix creation of slow sheet objects when there are frozen panes
* Fix the solver and several related reports
* Make the solver dialog's constraint page more usable
Kasal:
* More cleanup in configure
Morten:
* Fix Clear-All crash. [#157376]
Jody:
* Fix display of slow objects when there are frozen panes
--------------------------------------------------------------------------
Gnumeric 1.3.92
Andreas:
* Fix text export dialog [#155437, #154231]
* Skip sheet selection in text export if there is only one
non-empty sheet. [#156604]
* Make print dialog less modal. [#132876]
* Make non-imported columns in configurable text import more
visible [#154139]
* Suppress warnings when filling with large series. [#153527]
* Improve format page in configurable text import [#154138,
#139385]
* Improve schema description [#153631]
* Warn if csv import is dropping columns [#139385]
* Change menu text in fixed cvs import [#154137]
* Add format descriptor to column headers in text import. [#154140]
* Fix various bugs [#156531, #156710]
* Add tooltips to buttons in text export sheet selection.
* Add top and bottom buttons to text export sheet selection.
* Disable buttons in text export sheet selection when not applicable.
* Fix LaTeX export of cells spanning to the left [#157047]
Arief Mulya Utama:
* Erlang (telecommunications engineering) plugin.
Emmanuel Pacaud:
* Add dash styles to chart objects.
* Enables non integer line width for chart objects.
* Fix clipping in svg export.
* Update labels automatically [#152585].
Hal Ashburner:
* Some function documentation cleanups.
Jody:
* Enable selecting and moving multiple drawing objects
* Swap X & Y axis content when importing xls bar plots. [#154734]
* Basic handling for XL 'Forms' Objects
* Fix handling of empty arguments in nested expressions
* Delay gnome-print init to decrease startup time
* Improve OOo import for styles
* Some support for newer Lotus-123 formats
* Translate autoformat categories and descriptions
* Re-enable the ui plugin service
* Rename x-quattro-pro to match freedesktop [#152159]
* Have text in item-edit does reflect zoom
* Show the right rich text format when clicking on edit line
* Finish rich text persistence for gnumeric xml and clipboard
Morten:
* Implement Edit->Select->Input. [#154735]
* Fix sample datasource's recalc. [#154857]
* Make File->Open start in the directory where the current file
was loaded. [#143188]
* Make it possible to unhide sheets. [#154710]
* Add HYPOT function. [#148322]
* Add PFACTOR function.
* Plug leaks.
* Revive logic to add missing parenthesis in parser.
* Fix evil timing issue in about dialog. [#155268]
* Fix window menu in case of "_" in names. [#155235]
* Add support for setting text and markup in buttons.
* Fix XL save crash. [#155371]
* Limit the width of search window. [#136421]
* Protect against crash in inter-process paste.
* Make URLs work from Nautilus. [#156456]
* Fix pgamma accuracy for extreme arguments.
* Improve accuracy of a few complex number functions.
* Make sure basenames of files can be seen during splash for
multiple files.
* Fix undo column crash. [#157045]
Yukihiro Nakai:
* Improve perl plugin.
* Fix various untranslated GUI elements.
* Bullet-proof plugin loader.
--------------------------------------------------------------------------
Gnumeric 1.3.91
Adrian:
* Write the chapter "Graphics: Plots, Images, Widgets and Drawings"
* Write the chapter "Working with Files"
* Update the chapter "Elements".
Andreas:
* Improve `Z-Test for 2 Means'
* Improve `T-Test (Paired Sample)'
Emmanuel Pacaud:
* Grid lines implementation
http://bugzilla.gnome.org/show_bug.cgi?id=152615
* New set of icons for charting engine
http://bugzilla.gnome.org/show_bug.cgi?id=152499
* Fix crash when adding y-erros to an empty plot
http://bugzilla.gnome.org/show_bug.cgi?id=152201
* Fix the performance degradation with too many axis ticks
http://bugzilla.gnome.org/show_bug.cgi?id=153146
* Fix crash when adding series to a radar plot
http://bugzilla.gnome.org/show_bug.cgi?id=153401
* Fix ring plots for center radius = 0
http://bugzilla.gnome.org/show_bug.cgi?id=153402
* Remove unused radar plot editor
Jody:
* XLS import formatted single points in charts (only pie for now)
* Improve theme support for single points in charts
* ctrl-7, ctrl-9, ctrl-(, ctrl-0, ctrl-)
* Rework column size calculation on xls import/export
http://bugzilla.gnome.org/show_bug.cgi?id=152248
* font strangeness when exporting to xls
http://bugzilla.gnome.org/show_bug.cgi?id=152512
* Improve cursor for object resize
http://bugzilla.gnome.org/show_bug.cgi?id=152244
* Fix loss of precision when resizing objects
http://bugzilla.gnome.org/show_bug.cgi?id=152636
* Fix rendering problem when zoomed
* Fix object positioning when zoomed
* Make the status area shorter with GtkStatusbar and fewer frames
* XLS import for arcs, polygons
* Improve XLS object styling
* More win32 build patches
http://bugzilla.gnome.org/show_bug.cgi?id=114099
* Clipboard support for objects
* Support for symmetric object resize, and duplication via ctrl-click
* Cleanout the SheetObject menu code to restore model gui split
* Fix File -> Sendto
* Add ctrl-period == insert current date&time
http://bugzilla.gnome.org/show_bug.cgi?id=114153
* Respect 0 as no-compression for xml export
Jon KÃ¥re:
* Fix the CORBA plugin.
* Add pangoft2 dependency.
http://bugzilla.gnome.org/show_bug.cgi?id=153701
Morten:
http://bugzilla.gnome.org/show_bug.cgi?id=152511
* Fix crash when adding a xy plot over a pie plot
* Work on using pango layouts for printing.
* Fix endless recursion. [#153544.]
* Plug leaks.
* Improve save-as dialog.
* Make sure *.csv and *.tsv are listed as spreadsheets in the
open dialog. [#143135.]
Uwe Steinmann:
* Validate the field names for paradox databases
Yaacov Zamir:
* Fix header/footer printing to use pango layouts.
* Fix graph printing to use pango layouts for text.
* Fix cell printing to use pango layouts.
Yukihiro Nakai:
* Enable editing email links
--------------------------------------------------------------------------
Gnumeric 1.3.90
Andreas:
* Improve `T-Test (Unpaired; Unequal or Equal Variances)' tool
* Fix TDIST for negative x and two tails
Emmanuel Pacaud:
http://bugzilla.gnome.org/show_bug.cgi?id=151529
* Fix markers in xy and line plots.
http://bugzilla.gnome.org/show_bug.cgi?id=151530
http://bugzilla.gnome.org/show_bug.cgi?id=151527
* Fix axis size allocation
http://bugzilla.gnome.org/show_bug.cgi?id=127203
* Align axis title with plot area
Jody:
* XLS import zooming for full page charts
* XLS export for full page charts
* XLS import of autoshapes with/without outlines and fills
* Use the right default palette for XL95
http://bugzilla.gnome.org/show_bug.cgi?id=151628
* Fix resizing sample plot in graph assistant type selector
http://bugzilla.gnome.org/show_bug.cgi?id=152059
* Add full screen toggle
* Auto recognize csv files < 80 characters long
Jon KÃ¥re:
* Export text objects to Excel
Kasal:
* Some typos in various docs
* Cleanup configure.in
Morten:
* Make new windows inherit toolbar visibility from parent.
* Map [Enter] to next-match in search centre.
* Fix F4 ($-cycling) when used in bogus places.
* Improve save-as when selected from a workbook that was not
loaded. (Still, save-as isn't great.)
--------------------------------------------------------------------------
Gnumeric 1.3.2
Andreas:
* Improve `F-Test' tool
http://bugzilla.gnome.org/show_bug.cgi?id=148724
http://bugzilla.gnome.org/show_bug.cgi?id=149247
* Some minor About box changes
http://bugzilla.gnome.org/show_bug.cgi?id=149945
* Fix database functions
Emmanuel Pacaud:
* Add logarithmic mapping and invert axis support.
* Zoom support for markers and error bars.
* Move sharp libart rendering tweaks to pixbuf renderer.
* Improve chart SVG export.
http://bugzilla.gnome.org/show_bug.cgi?id=132063
* Improve chart printing.
* Fix minor tick rendering
http://bugzilla.gnome.org/show_bug.cgi?id=144123
* Add labels to radar axis
http://bugzilla.gnome.org/show_bug.cgi?id=139397
* Don't clip markers to plot area
http://bugzilla.gnome.org/show_bug.cgi?id=142255
Harald Ashburner:
* Updates for the option pricers.
* Pricers for
: American/European options to exchange one asset for another
: Options on spreads between futures
: Payouts on the most favorable state during a period
Jody:
* Use SAX exporter by default.
* Enable 'popup-menu' binding support
* Add tooltip for object resizing
* Misc ancient array formula parsing and entry problems
* Jump to lp_solve 5.0
* Jump to GLPK 4.5
* Add a View -> Windows menu
* Work on tightening up XL compat of array functions
* Improve xls export for obscure xl eval modes
* Improve XL/OO compat for RANK()
* XLS import of full page charts
http://bugzilla.gnome.org/show_bug.cgi?id=150530
* sax export of comments without authors
http://bugzilla.gnome.org/show_bug.cgi?id=150792
* fix breakage in ins/del col/row caused by dsum changes
http://bugzilla.gnome.org/show_bug.cgi?id=150578
* Update the resize handles if the current object's size changes
http://bugzilla.gnome.org/show_bug.cgi?id=151144
* XL can not handle plots with no data, filter them
http://bugzilla.gnome.org/show_bug.cgi?id=151150
* center ticks for bar/col plots too
http://bugzilla.gnome.org/show_bug.cgi?id=143724
* Clip large dbf files to compile time file limits
Jon KÃ¥re:
* Export images to Excel
* Read images from native Gnumeric format
* Read and save images we cannot render without loss to and
from Excel and native Gnumeric format
* Add 'Save As' menu entry for image objects.
* Add format chooser to 'Save As' dialog for images and graphs.
* Resurrect the Psion Sheet importer.
* Fix file drag from nautilus -> gnumeric.
* Fix "Save changes?" bug.
http://bugzilla.gnome.org/show_bug.cgi?id=151152
Morten:
* Add Ctrl-5 for strike-through.
* Add Ctrl-Shift-D for double underline.
* Fix error return for GEOMEAN and HARMEAN.
* Fix IMCONJUGATE and IMABS for reals. [#148323, backported]
* New function INVSUMINV.
* Fix crash with format toolbar in menu mode.
* Fix crash on exit. [backported]
* Fix ssconvert output.
* Fix potential lexer crash.
http://bugzilla.gnome.org/show_bug.cgi?id=150821
* Fix graph guru crash in the absense of graph plugins.
Uwe Steinmann:
* Paradox DB import.
Yukihiro Nakai:
* Export links when saving as html.
* Add actions for www and bug reporting.
http://bugzilla.gnome.org/show_bug.cgi?id=151273
* Fix perl plugin
--------------------------------------------------------------------------
Gnumeric 1.3.1
Andreas:
http://bugzilla.gnome.org/show_bug.cgi?id=142219
* Handle borders in latex export correctly
http://bugzilla.gnome.org/show_bug.cgi?id=142836
* Save current sheet as csv (rather than first sheet)
http://bugzilla.gnome.org/show_bug.cgi?id=140820
* Fix default colour handling in manage sheet dialog
* Add interface to allow the visibility of sheets to be toggled
http://bugzilla.gnome.org/show_bug.cgi?id=142700
* Make sure zoom-box shows current zoom factor
* Improve `Descriptive Statistics' tool
* Improve `One-Factor ANOVA' tool
* Improve `Correlations' tool
* Improve `Covariances' tool
* Add CLIPBOARD over PRIMARY choice to preference dialog
Christian Neumair:
* Put delete actions from edit main menu into their own submenu.
* HIGify some dialogs when it comes to spacing.
Emmanuel Pacaud:
http://bugzilla.gnome.org/show_bug.cgi?id=142212
* In a line graph, don't use '0' if Y value is missing.
* fix a double draw of chart childs.
Jean Brefort:
* Add error bars in bars, columns, lines and areas plots.
Jody:
* Edit and display rich text in cells (no persistence yet)
* Make the last dependency above gtk optional to enable a win32 build
* Major re-org of xls string import to handle rich text
* Improve xls import of old < xl95 variants
* Fix xls chart import for value dimensions
* Fix autoformat dialog
* Fix db functions
* Pango uses _byte_ offsets for attributes. Fix everything
* Fix xls import of chart background and outline
* Support richtext during autofill
* A huge performance improvement when scrolling images
http://bugzilla.gnome.org/show_bug.cgi?id=136363
* Fix font handling in chart labels and titles
http://bugzilla.gnome.org/show_bug.cgi?id=140671
* Fix crash when undoing a cut from a different workbook
* Fix MS XL crash when there are too many strings
* MS XL import for chart gradient backgrounds
* Support series without legend entries, including xls import
* Started on an OOo exporter
http://bugzilla.gnome.org/show_bug.cgi?id=103054
* Tweak XL import and export for named expressions / addins
http://bugzilla.gnome.org/show_bug.cgi?id=142474
* Use first rather than last conditional value fmt as catch-all
* Implicit iteration for operators
* Make the unary operators XL compatible
* basic xls export for charts
* start work on OOo export
* Skip ticks/labels for discrete axes
* Drag files from nautilus -> gnumeric
http://bugzilla.gnome.org/show_bug.cgi?id=143577
* fix grid printing
* fix merged cell printing and diagonal borders
* Allow themed series with gradients
* Fix application prop dialog
* Support repeat for several commands
http://bugzilla.gnome.org/show_bug.cgi?id=147756
* Ancient autofill leak on constant string fills
Morten:
* Fix crash related to database functions (#138600). [backported]
* Fix [h]:mm precision (#138182). [backported]
* Make it possible to hide toolbars.
* Make it possible to hide the statusbar.
* A few multihead fixes.
* Upgrade to R's development version.
* Add cumulative distribution to HYPGEOMDIST.
* Fix pgeom for small x. (Fixes accuracy of GEOMDIST.)
* Fix pbinom for very large n. (Fixes accuracy of BINOMDIST.)
* Replace R's pbeta function. (Fixes accuracy of BETADIST,
BETAINV, FINV.)
* Replace R's pcauchy function . (Fixes accuracy of CAUCHY.)
* Replace R's pf function. (Fixes accuracy of FDIST, FTEST, F-test
tool, regression tool, ANOVA tools..)
* Replace R's phyper function. (Fixes accuracy and evaluation speed
of HYPGEOMDIST.)
* Fix accuracy of our versions of various long-double functions
that Solaris lacks. (Fixes, for example, ERF.)
* Improve accuracy of FISHER.
* Improve accuracy of EFFECT, NOMINAL, MIRR, IRR, XNPV, NPV, PMT,
RATE, PV, FV, IPMT, PPMT for small rates.
* Fix accuracy of ZTEST.
* Improve prevision of the bessel functions.
* Fix validation crash due to excel import. [backported]
* Fix custom validation export. [backported]
* New functions EXPM1 and LN1P.
* Fix image-inside-xls problem. [backported]
* Ignore more spaces in expression entry.
* Improve error handling in xbase plugin. [backported]
* Fix a weird IF semantics where the argument count including
empties matters.
* Fix parser problem with single empty arg after expression. [backported]
* Avoid keeping passwords in memory. (Will need gtk+ fix to be really
effective.)
* Switch to keeping URIs, not filenames, inside and in history.
* Implement copy-right (Ctrl-R) and copy-down (Ctrl-D).
(For those worrying over the pile of accuracy fixes above it should
be noted that prior versions of Gnumeric were already pretty good,
certainly far better than Excel. Most of the fixes above are for
extreme-case arguments where most other software packages will give
totally incorrect answers and/or take extremely long time to
produce any answer at all. We are slowly feeding some of these
fixes back to, say, the R Project.)
--------------------------------------------------------------------------
Gnumeric 1.3.0
Andreas:
* Make new strings translatable.
* Use new widget for output page of analysis tools.
* Add display indicating why the okay button is disabled
to selected analysis tools.
http://bugzilla.gnome.org/show_bug.cgi?id=131343
* Use the paper selected in the print dialog [backported]
http://bugzilla.gnome.org/show_bug.cgi?id=132347
* Fix argument names for RATE.
* Some HIGfication in the print setup dialog
* Make sure that when printing to a file we don't accidentally
overwrite an existing one.
* Don't close the print dialog if a user wants to look at a preview.
* Remove last use of gnome-config
* Fix GtkFileChooser crash (133069)
Emmanuel Pacaud:
* Work on single point formating for charts.
http://bugzilla.gnome.org/show_bug.cgi?id=135621
* Fix rounding issue for markers in xy plots and for axis ticks.
Jean Brefort:
* Add error bars in scatter and bubble plots.
Jody:
* Drop gnome-app-helper in favour of GtkAction
http://bugzilla.gnome.org/show_bug.cgi?id=128524
* COUNTRY record position is xls version specific [backported]
* Generate an SST record even without strings to placate french version
of MS Excel [backported]
* Fix memory error introduced in 1.2.3 when saving to xls [backported]
* Move to glib/gi18n.h and delete the gnumeric specific equivalent
http://bugzilla.gnome.org/show_bug.cgi?id=130579
* We only need selection info in the primary pane
http://bugzilla.gnome.org/show_bug.cgi?id=130577
* Export multiple selections to xls for frozen panes
http://bugzilla.gnome.org/show_bug.cgi?id=130582
* Rangesel doesn't bind the panes during cursor movements either
http://bugzilla.gnome.org/show_bug.cgi?id=130424
* Recalc new expressions even when manual recalc is set
http://bugzilla.gnome.org/show_bug.cgi?id=130700
* Better compatibility with MS Excel's handling of minus sign
http://bugzilla.gnome.org/show_bug.cgi?id=130835
* ISNUMBER() should return false for blank references
http://bugzilla.gnome.org/show_bug.cgi?id=130172
* Do not convert blanks to int(0) for string args
* Allow optional args to receive empty even for booleans
* Install the executable as gnumeric-<version>
http://bugzilla.gnome.org/show_bug.cgi?id=132017
* Support double underline when importing from applix
http://bugzilla.gnome.org/show_bug.cgi?id=127138
* Handle freezing when top or left is non 0
http://bugzilla.gnome.org/show_bug.cgi?id=132448
* Silly crash fix
http://bugzilla.gnome.org/show_bug.cgi?id=131933
* Handle mismatched locales with decimal pt == thousands sep
http://bugzilla.gnome.org/show_bug.cgi?id=132060
* update axis labels when a plot changes a source
http://bugzilla.gnome.org/show_bug.cgi?id=125886
* Data points define the axis, not the number of labels
http://bugzilla.gnome.org/show_bug.cgi?id=132390
* Fix crash when updating chart style combos
http://bugzilla.gnome.org/show_bug.cgi?id=132017
* Support double underline when importing from applix
* Fix our exported xls with macros with named sheets
* Use theme colours in plot type selector
* New about box
* Reorg the text exporter
http://bugzilla.gnome.org/show_bug.cgi?id=74205
* Display the blue range designator even in other panes
http://bugzilla.gnome.org/show_bug.cgi?id=126563
* Fix col/row sizes when copying a sheet with default zoom != 1
http://bugzilla.gnome.org/show_bug.cgi?id=135946
* Add support for mmmmm formats
* persist combos and lists (to gnumeric xml)
* Fix xls import of external 3d references
http://bugzilla.gnome.org/show_bug.cgi?id=136088
* Persist vary-style-by-color for pie plots
* Do not theme colours when using image fills
* Recalc autosized row heights when a font size changes
http://bugzilla.gnome.org/show_bug.cgi?id=135977
* Fix xls import of font and font colours for XL95/XL97 text/labels
* Fix xls import of label outlines for XL95 textboxes
* Make the text probe routine a bit more relaxed
* Fix xls import of cursor position for frozen panes
* Fix xls export of h/v only frozen panes
* Fix xls 97 export of named expressions without addins
http://bugzilla.gnome.org/show_bug.cgi?id=137818
* For immediate rerender, even for simple font changes.
* Support editing rich text in cells (incomplete)
http://bugzilla.gnome.org/show_bug.cgi?id=138533
* handle insufficient data in moving average tool
J.H.M. Dassen (Ray):
http://bugzilla.gnome.org/show_bug.cgi?id=135044
* Incorrect undo label for row autosize
John Gill:
* Tool tips for the sort dialog.
Michael Devine:
* Radar plots.
Morten:
* Clean out work-arounds for old GTK+.
* Turn on multi-head support.
* Switch to file chooser.
* Eliminate use of GnomeEntry.
* Fit scale-fit problem.
* Fix FLOOR and CEILING error case.
* Fix problem with typing in the "decimals" spin button in the
cell format dialog.
http://bugzilla.gnome.org/show_bug.cgi?id=135609
* Fix pretty-print (and thus saving) problem with ranges like
$B$1:$B1.
http://bugzilla.gnome.org/show_bug.cgi?id=136639
* Work around theme engine crash. [backported]
http://bugzilla.gnome.org/show_bug.cgi?id=135000
* Set accessibility role for save-before-exit dialog.
* Improve auto-scrolling when dragging the cursor outside the
window.
* Improve pgeom (and thus GEODIST) accuracy.
* Make filename history UTF-8 safe.
--------------------------------------------------------------------------
Gnumeric 1.2.3
Adrian Bunk:
* Portability fixes.
Andreas:
* http://bugzilla.gnome.org/show_bug.cgi?id=128166
Mark workbook as dirty on sheet deletion/addition
* Bug fixes: 128915, 128611
* Minor changes to the sort dialog
* http://bugzilla.gnome.org/show_bug.cgi?id=128936
Allow text export to use the rendered strings rather than the
stored values
* http://bugzilla.gnome.org/show_bug.cgi?id=129444
Fix printing of non-word-wrapped cells with hard line breaks
* http://bugzilla.gnome.org/show_bug.cgi?id=129049
Make sure dialogs are visible on session manager communications
Jody:
http://bugzilla.gnome.org/show_bug.cgi?id=128565
* Overzealous renaming.
http://bugzilla.gnome.org/show_bug.cgi?id=128169
* Use the right font when editing.
http://bugzilla.gnome.org/show_bug.cgi?id=127625
* kludge around mystery inconsistent autfilters in xls
* Patch a leak in the pattern selector
* Fix a potential crash when changing labels on axis
http://bugzilla.gnome.org/show_bug.cgi?id=127734
* Modernize the sylk importer
http://bugzilla.gnome.org/show_bug.cgi?id=129445
* Fix xls import of plot styles that override defaults
* Fix xml import of ManualRecalc flag
http://bugzilla.gnome.org/show_bug.cgi?id=128837
* Horizontal, and Zoom scroll wheel support
* User selectable format for axis labels
* Tune 'General' format width calculation
* Improve quoting of accounting formats
* Auto format selection for axis value labels
http://bugzilla.gnome.org/show_bug.cgi?id=129833
* Tweak the mime types we claim to handle
John Gill:
* Add a field menu and keyboard shortcuts to the sort dialog
Jon KÃ¥re:
* Fix encoding of author field in summary.
http://bugzilla.gnome.org/show_bug.cgi?id=129702
Jukka:
* GLPK upgrade to version 4.2
Morten:
* Handle fractional seconds correctly for UNIX2DATE.
* Fix display of -0:30 again.
* PCRE upgrade to 4.5.
--------------------------------------------------------------------------
Gnumeric 1.2.2
Andreas:
* Updated some docs.
* Also use fallback-fonts for the page decorations when printing.
http://bugzilla.gnome.org/show_bug.cgi?id=122034
* Add default header/footer font selector to preference dialog.
http://bugzilla.gnome.org/show_bug.cgi?id=125361
* Fix printing from Page Setup dialog.
http://bugzilla.gnome.org/show_bug.cgi?id=125422
* Upon inserting of cells try to guess whether to move cells down
or to the right.
* Upon deleting of cells try to guess whether to move cells up
or to the left.
* Use the number of copies info read from an XL file
http://bugzilla.gnome.org/show_bug.cgi?id=127415
* Fix expr entry interaction with merged cells
http://bugzilla.gnome.org/show_bug.cgi?id=127932
* Fix and adjust sort dialog
Emmanuel Pacaud:
* Add clipping for plot areas.
http://bugzilla.gnome.org/show_bug.cgi?id=125419
Jean Brefort:
* Support text in SVG exporter
Jody:
* More renaming
* Don't install schemas when building an rpm
* Support non-assisted CSV export for ssconvert
* Simple optimization for 30% faster number matching
* Center line plot points on index
* Fix crash when importing truncated xls files
* Update axis labels when bac/col/line/area labels are set/cleared
* Complain loudly when people run without installing the schema
* Improve padding of chart elements
http://bugzilla.gnome.org/show_bug.cgi?id=124244
* Fix xls import of collapsed cols/rows at level 0
http://bugzilla.gnome.org/show_bug.cgi?id=123325
* Fix in 1.2.1 was spewing pointless warnings
http://bugzilla.gnome.org/show_bug.cgi?id=124975
* Handle undoing a paste from a deleted external sheet
http://bugzilla.gnome.org/show_bug.cgi?id=77303
* Don't scroll the other panes unless we absolutely have to.
http://bugzilla.gnome.org/show_bug.cgi?id=125269
* Try to save a current edit before an action
http://bugzilla.gnome.org/show_bug.cgi?id=125045
* Fix tick spacing with manual axis bounds
* Tune clipboard to avoid ultra deep recalc stacks
http://bugzilla.gnome.org/show_bug.cgi?id=125230
* Add epsilon _before_ we scale formats with elapsed hours
http://bugzilla.gnome.org/show_bug.cgi?id=125421
* Tune insert col/row above frozen panes
http://bugzilla.gnome.org/show_bug.cgi?id=124930
* Be more lenient about invalid xml, but put errors in gui
http://bugzilla.gnome.org/show_bug.cgi?id=125604
* Fix OO import in some locales.
http://bugzilla.gnome.org/show_bug.cgi?id=125611
* Fix OO import of integer attributes.
* XLS probe support for misnamed streams
http://bugzilla.gnome.org/show_bug.cgi?id=125577
* Don't forget to recalc after deleting col/row
http://bugzilla.gnome.org/show_bug.cgi?id=125619
* Init the high/low button for axis prefs
http://bugzilla.gnome.org/show_bug.cgi?id=125496
* Update all displayed auto values for axis bounds
http://bugzilla.gnome.org/show_bug.cgi?id=125886
* Have an inverse pull to 0 in case the eps pulls to far
* Actually install the man pages
http://bugzilla.gnome.org/show_bug.cgi?id=126389
* Formatting marks a sheet as dirty
* Support auto-shape/outline/fill for chart markers
* Add UI to restore auto colors for charts
* Update UI when a chart style element changes externally
* Support line plots with no markers by default
* Support xy plots with no markers, no lines, by default
http://bugzilla.gnome.org/show_bug.cgi?id=125886
* x axis label vertical alignment
http://bugzilla.gnome.org/show_bug.cgi?id=125986
* Extend 'is_auto' support.
* Fix round tripping of imported xls macros.
http://bugzilla.gnome.org/show_bug.cgi?id=125416
* Enabled the object re-ordering buttons
http://bugzilla.gnome.org/show_bug.cgi?id=126775
* Be smarter when all the values are the same
http://bugzilla.gnome.org/show_bug.cgi?id=126908
* Set label and text box outline/background to XL defaults
http://bugzilla.gnome.org/show_bug.cgi?id=68794
* default to rows when rows == cols
* Support minor ticks
* Tune chart axis ticks to avoid anti-aliasing blur
* Export 'Manual Recalc' flag to xls
http://bugzilla.gnome.org/show_bug.cgi?id=126907
* Recalc new expressions even when manually recalculating
http://bugzilla.gnome.org/show_bug.cgi?id=116090
* Support DISPLAY-less function dumping
http://bugzilla.gnome.org/show_bug.cgi?id=127095
* Problem introduced in 1.2.1 that breaks xml import in other locales
http://bugzilla.gnome.org/show_bug.cgi?id=127145
* Update status display even on delayed motion.
http://bugzilla.gnome.org/show_bug.cgi?id=127205
* Fix rangeseltion of multiple items in other locales
http://bugzilla.gnome.org/show_bug.cgi?id=127199
* Update the format status UI after a successful read
http://bugzilla.gnome.org/show_bug.cgi?id=127211
* Errors default to horzontal alignment == center
http://bugzilla.gnome.org/show_bug.cgi?id=127204
* Don't add a grid if there wasn't one in the xls
http://bugzilla.gnome.org/show_bug.cgi?id=127238
* Fix memory handling for autoformats
http://bugzilla.gnome.org/show_bug.cgi?id=127262
* Fix minor cosmetic issue with the boarder between frozen panes
http://bugzilla.gnome.org/show_bug.cgi?id=64297
* Cosmetic tweak to keep cursor visible on dark backgrounds
* Fixed xls export of col/row groups
* Support workbook local functions
* Fix xls import of unicode in expressions
* Fix gutter resize when adding groups
Morten:
* Fix crash with STF import and gazillions of columns.
* Drastically reduce memory usage during STF import with lots of
small fields.
* Speed up STF import by not creating field structures for lines
not shown in the preview anyway.
* Fix display of cumulative hours for -1h < time < 0h.
* Fix crash with loss of precision in linear regression of
dimension 2. http://bugzilla.gnome.org/show_bug.cgi?id=125436
* Fix wiiiiiiiide stf dialog with glibc and composite locales.
* Fix stf import of empty files.
http://bugzilla.gnome.org/show_bug.cgi?id=125573
* Fix column selection in stf import.
http://bugzilla.gnome.org/show_bug.cgi?id=125417
* Plug a few leaks.
* Optionally generate pseudo-random (as opposed to random) numbers.
Rodrigo:
* Bump requirement to libgda/libgnomedb 1.0.1
J.H.M. Dassen (Ray):
* Include several missing images in the documentation. (Debian #218580)
--------------------------------------------------------------------------
Gnumeric 1.2.1
Adrian Custer:
* More documentation.
J.H.M. Dassen (Ray):
* Update debian control files.
Jean Brefort:
* Gradient support for svg chart renderer.
* Marker support for svg chart renderer.
Jody:
* Fix infinite loop on empty axis under solaris.
* Fix leak loading charts.
* Don't pad zero sized children.
* Correctly show unqualified sheet local names in array exprs
* Add 'Albany' to excel plugin's font table
* Chart printing now respects scaling
* Fix crash with partial bar/col/line/area/xy series
* Patch warning when quiting with an keyed dialog
* Fix xls export of operand classes
* Minor packaging bug in corba plugin
* Accept blank lines in text to cols.
* Provide a cleaner work around for
http://bugzilla.gnome.org/show_bug.cgi?id=121543
* Re-enable the probe functions in plugins
* Big performance improvement when autosizing row heights.
* Fix recalc for ISBLANK
* Fix deleting a graph object with expr entries.
* Tweak the axis auto range selector to keep things symmetric
* Enable basic style import for chart elements
* Drop in a basic implementatin of ssconvert
* Be anal about exporting unicode chars > 0xfeff to xls
* Fix import typo that broke xls import of local hyperlinks
* Draw marker and lines for legend elements that support them
* Memory error when adding a series to a bar/col/line/area plot
* Tune Planperfect importer.
* Cleanup header inclusion to make things work even with gtk HEAD
* Have ssconvert generate export file name from exporter if needed
http://bugzilla.gnome.org/show_bug.cgi?id=123270
* update the goto box in a few more places
http://bugzilla.gnome.org/show_bug.cgi?id=122085
* Have 'MATCH/LOOKUP/HLOOKUP/VLOOKUP' handle blank criteria XLishly.
http://bugzilla.gnome.org/show_bug.cgi?id=123325 [countif]
* COUNTIF counts empties
* xls import for manual axis bounds and step
* xls import for chart and axis labels
John Gill:
* Heuristics to improve finger feel of autofilter range selection
Jukka:
* Fixed solver's model maximization button.
* Fixed crash with Cancel/OK buttons in Scenarios->View.
* Usability fix for solver's constraint change button.
* Bug fix: don't create a scenario if solver didn't find a solution.
* Layout improvements for Risk Simulation dialog.
* Layout improvements for Scenarios->View dialog.
Nick Lamb:
* Improve import of ancient xls.
Morten:
* Invalid memory read in marker combo.
* Speed up number match by caching localized TRUE and FALSE.
* Speed up number match of batches of partial dates (like "Jun-21").
* Speed up number match by speeding up regexp matching for regexps
with lots of ()s.
* Improve number rendering when showing more decimals than backed
by precision.
* Fix covariance tool.
* Plug leaks.
* Fix space trimming for stf import.
* Clean up FREQUENCY.
* Clean up DOLLAR.
* Plug html import leaks.
Thomas Miesbauer:
* Redo screenshots
--------------------------------------------------------------------------
Gnumeric 1.2.0
Andreas:
* Fix Advanced Filter dialog
* Fix Scaled Printing
* Fix `Fit to' printing
* Fix histogram dialog (122155)
* Fix header/footer dialog preview
* Make &[FILE] Excel compatible
* Add &[PATH]
* Fix &[TIME:hh:mm:ss] and &[DATE:yyyy] style subformatting
* Fix manage-sheet-dialog bug
* Add console warning message for font substitution
* Fix format chooser list (Thanks Etsushi Kato)
Christian Neumair:
* Start adding ATK relations to the dialogs.
Jody:
* Make chart axis prettier.
* Fix crash freeing undo info for a deleted sheet with comments
* Fix File -> SendTo
* Be more verbose when we can not find the default fonts
* Add a grid object for charts
* Install the plugin schema in the sample spec file
* Require libgsf-1.8.2 to fix backward compatibility with libole2 and
Gnumeric-1.0.x
* Support index/implicit axis for scatter plots
* Fix horizontal data sets
* Auto pad between chart child with compass layouts
* XLS import for axis marker/line formats, and axis ticks
* XLS import for ring plots, and fix some pie parameter scales
* XLS import legend position
* Honour and edit manual min/max values for axis
Jon KÃ¥re:
* Ensure that scrollbars always show up in font combo when
needed (http://bugzilla.gnome.org/show_bug.cgi?id=121877).
--------------------------------------------------------------------------
Gnumeric 1.1.90
Andreas:
* Make graph configuration undoable.
* Add image preview to insert image dialog.
Ben Liblit:
* Improve spec file.
Emmanuel Pacaud:
* Initial support for line markers.
* Add a combo for marker selection.
* Make colour combo less ugly for themes.
Jean Brefort:
* Basic SVG renderer for charting engine.
* Implement brightness style gradients
Jon KÃ¥re:
* Add 'Save As' entry for graph objects. Support png for now.
* Persist Styles for charting engine.
* Begin to enable support for is_auto
Jody:
* Get the lifecycle of copied GogGraphs running smoothly.
* Fix printing of graphs.
* Fix expr relocation with cross sheet references.
* Paper over the most common technique for blowing the stack.
* Disable clipboard operations during object editing.
* Enable labels in charts
* Fix Pie/Ring style editor
* Begin font support for chart attributes
* Fix gradient's in pie/ring slices
* http://bugzilla.gnome.org/show_bug.cgi?id=121045
* Adjust the semantics of empty cells passed to optional arguments
* Pretty up the legend a bit
* Be more expansive about what constitutes General.
* Tweak the paramters of what XL thinks the size of 'Courier' is.
* Add basic Scatter plot.
http://bugzilla.gnome.org/show_bug.cgi?id=121560
* Fix dynamic depend leak.
* Improve performance when deleting multiple sheets at once.
* Only export a charting style field if it is interesting.
* Hook up the Jean's SVG exporter to Jon KÃ¥re's Chart Save As
* Bound clipping for xy/bar/col/line/area
* Finish axis life cycle support
Morten:
* Support End+Home key sequence.
* Tidy up gradients for charting engine.
* Handle -hh:mm.
--------------------------------------------------------------------------
Gnumeric 1.1.20
Adrian Custer:
* Get the new documentation building.
Andreas:
* Fix analysis tools dialogs again
* Fix text export of non-ascii charaters
* Fix latex export of non-ascii charaters
* Allow latex export to use utf-8 if required
* Avoid duplicate regression tool error messages
* Added new function SSMEDIAN (social science median, or
median for grouped data)
* Added a locale selector to text import.
* Fix 115542 (cs_CZ bug), 115503 (autofill of dates)
and many others
* Fix landscape printing
* Save header/footer defaults
* Update consolidate dialog
* Permit to ignore any columns during text import
* Add column header menu to format page of text import
* Fix locale specific parsing on paste
* Add undo to inserting of sheets via the tab context menu
* Clarify insert/append sheet commands
* Change layout of preference dialog
* Make fill->series undoable, redesign its dialog
* Make Data->Text_to_Columns undoable
* Add help button to autoformat and plugin manager
* Make Tools->Solver undoable
* Make Tools->GoalSeek undoable
* Make Duplicate Sheet undoable
* Reduce the occasions when the undo chain is being flushed
* Make Edit->Sheet->Remove partly undoable
* Add standard output selector to consolidate tool
* Make Edit->Fill->Tabulate Dependency undoable
* Add simple session management
Ben Liblit:
* Another attempt at configure time path generation.
Emmanuel Pacaud:
* New format selector for stf.
* Ring plots
* Line and Area plots
Gustavo Carneiro:
* Use gnome-common detection for libtool version
Jean Brefort:
* Support image files in chart areas (background, bar/col or pie)
* Initial pass at supporting patterns in chart areas.
Jody:
* Fix the generated source files.
* Cleanout the internals of PreviewGrid.
* Cleanup AutoFormat dialog.
* Printing support for charting engine.
* Fix printing of images.
* Coup de grace to gal, importing the 75 lines of e_xml we used
* Keynav for autoformat dialog
* Fix jumping to internal links in a different sheet
* Add XML persistence for charts
* Misc Charting improvements & fixes
* Add YEARFRAC to put us at 100% coverage
* Fix some format generation bugs
* Rationalize and document the SheetObject::print interface
* Cleanup line/arrow/filled sheet object config dialogs
* An initial implementation of bonobo-less File -> Send To
* Recalc fix for functions that did not use the collect utils
* Work on Charting Engine.
* Function doc patches to go with the new doc framework.
* Function doc spelling and grammar.
* Fix glitch in xls hyperlink import.
* Undocumented flag on cell comments in xls
* Import cell comments from >= xl97 too.
* Object text labels from >= xl97.
* Fix export of strings > 8224 characters in xl97.
* Fix style export in the presence of validation and hyperlinks.
* Spinner/Scrollbar import for xl 95 & 97.
* Fix 118723
* Work on image persistence in xml
* Revamp chart styles and patterns
* Improve behavior of autofilters with ins/del col/row
* Make mmult smarter about what constitutes a 3d ref
* Improve import of gnumeric-1.0.x era graphs
* Fix crash on xls export for autfilters with no conditions.
* Some basic work on axis
John Gill:
* More XLish heuristics for autofill range selection.
* Support End keys, and XL style 'transition' keys
Jon KÃ¥re:
* Improve color combo.
* Fix keynav for various kinds of combos.
* Make splash screen display code clairvoyant.
* Import OpenOffice.org 1.1 from clipboard.
* Export XHTML to clipboard.
* Fix clipboard export of non-Latin 1 content as text.
* Fall back to string when import from clipboard as
table/spreadsheet fails.
* Import incomplete html fragments, as produced by
* e.g. Mozilla, from clipboard.
* Fix bugs in Python loader.
* Polish Python console.
* Add workbook_new() to Python bindings.
Joseph Pingenot:
* Spin buttons
* Slider objects
Morten:
* Hopefully fix NAN issues on Alphas.
* Plug autoformat leak.
* Import all gal widgets we use.
* Fix lots of UTF-8/filename problems.
* Make pixmap combos multihead safe.
* Make color combos multihead safe. Fix latent memory corruption
problem.
* Fix incorrect range highlighting in non-expressions like "10:23".
* Improve character set handling of pastes from other apps.
* Improve stf import's handing of strange line terminators.
* Fix nasty locale-changing problem (localeconv data changing
underneath us).
* Make locale handling UTF-8 safe.
* Unify our three regexp quoting functions into just one (correct)
function.
* Make pretty-printing clarify trees like "-2^2" into "(-2)^2".
* Fix cell entry display for strings with initial quote.
* Fix YIELDDISC, ODDFPRICE, ODDLPRICE, and ODDLYIELD.
* Implement ODDFYIELD.
* Reduce flicker in format selector widgets.
* Fix another O(n^2) problem in stf import.
* Fix YEARFRAC.
* Speed up loading.
* Use pool allocation for cell style tiles.
* Fix rounding and error problems with GCD and LCM.
* Make +/- buttons work for changing precision of fractional formats.
* Fix +/- buttons for cells with value formats.
* Fix +/- buttons for currency formats.
* Make the 1000-separator button do something more useful.
* Improve the support for fractional formats.
* Improve auto-format for date differences.
* Clean up style format code.
* Fix parsing of fractional constants.
* Improve progress display a bit.
* Show default image for types we don't recognize.
* Improve fixed-width stf.
* Fix reading 1.0 xml files lacking encoding.
* Handle file save errors that happen after the initial open.
* Major speed-up for certain dynamic dependencies.
--------------------------------------------------------------------------
Gnumeric 1.1.19
Auto*-wrestling only.
--------------------------------------------------------------------------
Gnumeric 1.1.18
Andreas:
* Some more UTF-8 cleaning in the stf parsers.
* Improve the encoding selector by only showing
supported encodings
* Some small improvements to the Text Import dialog
Ben Liblit:
* Move the various compile time paths into a generated header.
Emmanuel Pacaud:
* HIG compliant quit dialog.
Jean Brefort:
* Initial version of gradient editor for chart style page.
Jody:
* More work on graphs.
* Set alwaysCalc flag when xls exporting dynamic dependencies.
* Fix HIG-ification of validation page in fmt dialog
* Add some mnemonics to the new and improved file open dialog.
* Finish conversion of default font to Sans 10
* Fix http://bugs.debian.org/193276
* Fix rangesel on other sheet in with of sheet local names
* Fix recalc on undo of cut-paste of interior of range
* Sheet data -> charts begins working.
* Some minor tweaking for xls escher import to handle gradients
* Clean up edit item, and support spanning autocompletion
* Fixes for sheet object dependencies.
* Fixes for chart series generation.
* Basic Pie & Bar/Col plots.
* Initial xls import for new plots (no formatting).
* Have HTML exporters handle utf8.
* Extend layout engine in GogChart.
* Nice redraw speedup for images and charts.
* Fix undo bug for moving merged regions (yummy).
* Support Move with cells flag for sheet object.
* Text in charts.
* Fix lots of bugs in the run up to a beta.
* Fix undo of defining an existing named expression placeholder.
* Simplify the recently used file stuff in preparation for egg.
* Fix months old stupidity in my lobotomization of gconf wrapper.
* Remove deprecation from canvas items.
* Finished first pass at an xml SAX based exporter, still rough around
the edges.
Morten:
* New function COLUMNNUMBER.
* Fix ABRs in imported pcre code.
* Leak fix for gnumeric xml saving.
* Leak fix for character encoding selection.
* Fix stf import crash for empty files.
* Improve generation of binomial and negative-binomial random
numbers.
* Fix stf dialog problem with WM close.
* Make stf export quoting UTF-8 safe.
* Make stf export cell separation UTF-8 safe.
* Improve generation of NaN, -Inf, and +Inf.
* Fix 112330.
* Handle character set aliases, more or less.
* Improve remote-DISPLAY start-up time by getting rid of calls to
deprecated gtk_style_get_font function.
* Start getting rid of use of deprecated features.
* Multihead support.
* Fix crash for analysis tools on initial failure.
* Speed up stf import.
* Rewrote stf importer to be GtkTreeView/GPtrArray based instead
of GnomeCanvas/GList.
* Fix a ton of stf bugs.
--------------------------------------------------------------------------
Gnumeric 1.1.17
Andreas:
* Add character encoding menus to the file selector
* Handle specified encoding for csv/tsv files
* Handle specified encoding for configurable text import
* Fix csv parsing (#80806), finally
* Fix #100529, #78355, #99649
Ben Liblit:
* Support for automake 1.6.x
* Modernize the rpm .spec file
Emmanuel Pacaud:
* Add encoding selector to stf export
Jody:
* Improve handling of files with content type != extension
* A few small bugs in XL97 export.
* Simplify defining new services
* Work on graphs
* Fix xbase importer
* Add motion compression for high speed scrolling
* Fix elapsed hour format
* Make the edit item smarter at the right edge
* Handle saving too many merged cells for 1 xls record
* Fix internal hashing bug with styles containing auto colors
* Improve update semantics of ExprEntry in preparation for graphs
* Make sheet_get_extent span when needed.
* Fix old bug exposed by alex's fix to mapping in foocanvas.
Jukka:
* Added shuffling tool.
* Added `Edit'->`Fill'->`Series...' filling tool like in XL.
* Added scenario tools.
Martin Hoffmann:
* Fix autocompletion in the face of multi-byte characters.
Morten:
* Make RenderedValue use a PangoLayout for storing the contents
of a cell. (Operation Snappiness, Part 3.)
* Make mstyle cache pango attributes. (Operation Snappiness,
Part 4.)
* Make sure our pango contexts have language set. (Operation
Snappiness, Part 5.)
* Shave off a few cycles here and there.
* Improve progress display when loading.
* Eliminate rendered_text from struct RenderedValue. (Operation
Snappiness, Part 6.)
* Fix a few stf irritants.
* Security fix for sample data source plugin.
* Security fix for oleo plugin.
* Security fix for sc plugin.
* Fix gnome print configuration.
* Fix latex exporter crash.
* Restore auto-format functionality. (Automatically supply a format
to a new cell based on the formula entered.)
* Work around extremely slow cases in in, e.g., BETAINV.
* Improve speed of generation of many types of random numbers.
* Switch regexp routine to pcre.
--------------------------------------------------------------------------
Gnumeric 1.1.16
Jody:
* Support Mac Office style 1904 date convention.
* Fix recalc problem with MMULT.
* Bump libgsf req to 1.7.0
* Fixed XL export (apologies to all)
* Improve support for negative elapsed time formats.
* Minor lotus-123 import issue.
* Added Skeleton for importing MS Excel XML.
* Changed default toolbar layout to icon only.
Jon KÃ¥re:
* Finish UI for managing hyperlinks of various sorts.
* Skip sheet chooser page in text export when there is only
one sheet (Fixes 84791).
* Paste OpenCalc from clipboard.
* Paste html tables from clipboard.
Morten:
* Fix MDETERM.
* Lower number of matrix LU-decomposition routines from three to
one.
* Add function renaming support for file formats that use function
names different from our.
* Partial buffer overrun audit.
* Improve fraction format.
* Move pango attribute calculation into rendered value. (Operation
Snappiness, Part 1 of many.)
* Eliminate StyleColor member of RenderedValue. (Operation
Snappiness, Part 2.)
Nicolas Peninguy :
http://bugzilla.gnome.org/show_bug.cgi?id=102236
* Decrease depenence on glibc regexp extensions.
Murray Cumming :
* Port to the gnome-print-2.2 api.
Theppitak Karoonboonyanan:
* Improve XIM support.
Wayne Schuller <k_wayne@linuxpower.org>
* Initial implementation of fit-to-pages printing.
--------------------------------------------------------------------------
Gnumeric 1.1.15
Jody:
* Fix some XL95 object issues.
* Find a few undocumented corners of XL's format.
* Fix XL97 export of validation and filters for simple sheets.
* Misc screwups with autofilters
* Ins/Del Col/Row now does mostly the right thing with filters.
* Ins/Del Col/Row now handles frozen panes.
* Lower right of merge extends sheet bounds.
* Fix parser's handling of unknown function.
* Remove unnecessary new/free of dates.
Jon KÃ¥re:
* Open DB connections read only.
* Improve password dialog.
* Show password dialog also for files given on command line.
Morten:
* Fix crash when no undo information is wanted.
* Clean up NULL/FALSE confusion all over.
* Remove GNM_EXPR_PARSE_CREATE_PLACEHOLDER_FOR_UNKNOWN_FUNC.
* New functions GNUMERIC_UNICHAR, GNUMERIC_UNICODE
Nicolas Peninguy:
* Move the generation of the standard formats into StyleFormat
--------------------------------------------------------------------------
Gnumeric 1.1.13/1.1.14
Andreas:
* Fix some stf bugs
Evert Verhellen:
* New icons for +/- precision
* Make bonobo/non-bonobo a whole lot more consistent.
Fernando Herrera:
* Improve desktop file to support bug-buddy.
Jody:
* Make the behavor of save and save-as more comfortable.
* Fix parsing 3d references
* More work on exporting names to xls
* Support the global outline buttons
* Optional outline markers at the begining rather than end
* Make the label object more useful
* Fix XL import for h/v only freeze with non origin start
* More attributes for excel95 objects
* Support pruning 3d references on sheet deletion.
* Clean up some workbook view life cycle issues
* Implement Auto-filters
* Begin support for pivot tables
* Full support for SUBTOTAL magic
* Fix sneaky bug between sheetobjects and frozen panes
* Fix removal of placeholder names
* XLS export for validation and Input Messages
* Improve handling of validation in format dialog
* XL97 export for named expressions
* XLS export for autofilters
* Fix print dialog's entry of repeated cols/rows
Jon KÃ¥re:
* Separate GUI for showing progress and messages before first
spreadsheet window is displayed.
* Fix 98661.
* Port the remaining plugins to gsf output.
* Use desktop font for row and column titles, fixing 98666.
* Fix bugs in the bonobo control version of Gnumeric.
* Install the bonobo control in libexec.
* No longer pretend to support the Bonoobo/PersistFile interface.
* Fix key navigation and scrollbar scrolling in auto-filter combos.
* Clean up editable-label some more.
* Improve image loading. With libwmf-0.2.8 and gtk+-2.1.2 or
later, Gnumeric can now display Windows Metafile images -
common in Excel documents.
* Fix bug in hyperlink import from Excel.
Morten:
* Improve qpro importer.
* Fix 98664 for bonobo.
* Fix sylk importer to do ISO-8859-1 -> UTF-8 conversion.
* Fix dif importer to do ISO-8859-1 -> UTF-8 conversion.
* Attempt a fix for psiconv importer to do ISO-8859-1 -> UTF-8
conversion.
* Make autofill UTF-8 safe and fix a bug with negative numbers.
* Fix FV problem with rate==0.
* Fix DAYS360 incompatibility (with XL).
* Improve parsing infra-structure.
* Fix unnecessary singularities for IPMT, PPMT, and NPER.
* Make print-info use GnomePrintUnit instead of our own half-baked
stuff.
* Overhaul error value layers.
* Fix loading and saving of error values in xml format.
* Fix parser crash. (101658.)
* Fix oleo parser.
--------------------------------------------------------------------------
Gnumeric 1.1.12
Andreas:
* Hide hidden cells in groff/troff export.
* Fix 78356.
* Watch for file extensions not matching filetype when saving.
Evert Verhellen
* Buff up the function guru icon a touch
J.H.M. Dassen (Ray):
* Updates to the build system.
* Some code janitor work.
Jody:
* POISSON is defined for x == 0
* Start work on rotated text
* Enable Excel97 basic export
* Have the importer designate the exporter directly
* Switch to foocanvas for performance
* Just in time rendering for clipboard
* Add 'require_explicit_enable' for plugins
* Support writing dual stream xls files
* http://bugzilla.gnome.org/show_bug.cgi?id=97672
* Rewrite string export for xls (95 & 97)
* Fix inline array export for xls (95 &97)
* Store the xls codepage when importing for use when exporting
* Merge style extent and most common style calcs for xls export
* Improve xls export of custom palettes
* Fix xls export for zoom > 100
* Implement intersheet and 3d references for xls97 export
* Fix xls import of 3d external references
Jon KÃ¥re:
* Merged File/Open and File/Import
* Remove code which supported the File/Open File/Import
distinction.
Morten:
* Spelling fixes all over.
* Add the ability to search expression results.
* Add parameter checks to RAYLEIGH, RAYLEIGHTAIL, EXPPOWDIST,
LAPLACE, PARETO, LOGISTIC functions.
* Plug leaks in function selector dialog.
* Improve memory usage in search centre slighly.
* Fix precision of GAMMALN.
* Fix precision of FACT and extend it to negative non-integers.
* Add BETA and BETALN functions.
* Make CHAR function UTF-8 safe.
* Make CODE function mostly UTF-8 safe.
* Fix SUBSTITUTE (for non-blank fourth argument) and make it UTF-8
safe.
* Make SEARCH function UTF-8 safe.
* Fix sc importer to do ISO-8859-1 -> UTF-8 conversion.
* Fix oleo importer to do ISO-8859-1 -> UTF-8 conversion.
* Make search UTF-8 safe.
Nick Lamb:
* Initial support for pre-ole xls files.
Olaf Till:
* Two new logarithmic regression functions, one of them
with nonlinear fitting of a horizontal curve shift.
--------------------------------------------------------------------------
Gnumeric 1.1.11
Adrian:
* Some LaTeX exporter fixes
Andreas:
* Fix 97246
Dustin Mudryk:
* Hide hidden cells in LaTeX export
Jody:
* Store current sheet in both spots for xls export
* Fix multiple name invalidation within 1 expr on sheet delete
* Work around incorrect XL95 export in OpenCalc
* Enable full simplistic just in time render & span.
* Fix names.
* Tidy and brighten up the name dialog.
* Add more format and alignment support to cell edit.
* Re-enable feedback for autocomplete.
* Fix xls names with unicode ids.
* Fix xls 2000 import for external names.
* Fix edit line behaviour.
Morten:
* Clean up SERIESSUM.
* Fix crash during xml save.
* Fix elusive dependency leak.
* Implemented a new and better qgamma function. (Anything dealing
with the chisq distribution will also benefit from this.)
* More utf8 work.
* Fix ABW in html exporter.
--------------------------------------------------------------------------
Gnumeric 1.1.10
Andreas:
* Add XHTML exporter
* Fix minor bug in the sort dialog
* Fix leak
* Fix 95333
Chris Benedict:
* Do not allow all sheets in a workbook to be deleted.
* Implement a simple configuration dialog for the frame
sheet object
dorami@bu.iij4u.or.jp:
* Add InputMethod support for better international key support
Hal Ashburner:
* Rework derivative valuation routines
Jody:
* Decrease GAL dependence.
* More work on opencalc importer.
* Start clean up of error handling routines.
* Some UTF-8 cleanup.
* Support placeholders for unknown names (incl XL import)
* Restore core <-> split for analysis and random num tools
* Undo support for defining and updating named expressions
* Port Name guru from GtkList -> TreeView
* Fix applix expr parsing now that we consider spaces
* Correct sheet order and naming for Applix import.
* Support named ranges for Applix import.
* XML string quoting in expressions for opencalc importer.
* Fix handling of 3d references in context of sheet reorder
* Some optimization of case insensitive sheet name lookup
* Make named expression ids case sensitive.
* Port cell format dialog to TreeView.
* Handle encryption from 'Tools -> Protection -> Workbook Protected'
* Remove implicit conversion of unquoted strings that are not names
* Import named expressions, arrays and merged regions from OpenCalc
* More cleanup after the big parser rework
* Esoteric XL number formats #,,##0,,
* Simplify some dialog code
* Support Dynamic Depends (eg INDIRECT)
* Add AREAS so that we can finally finish off the lookup functions
* Clean up the function registration api
* Make format parsing utf8 clean
* Fix mishandling of empty strings in xls data validation importer
* Support Horizontal and Vertical only frozen panes
* Some optimizations for filling large regions
* Start work on 'Text from Columns' and 'External Data -> Text File'
* Simple manual recalculation, it won't catch everything yet.
* Some UI for recalc and iteration changes
* Tweak precedence of new operators and clean up the grammar
* Fix parse error reporting
* Fix xls name import for external and builtin names (95 & 2k)
* Fix undo for object movement
* Improve XL95 export and prep framework for 2k
* Add quicky placeholder for importing 'input msg' from xls
Morten:
* Port search center from gal's e-table to gtk's treeview.
* Fix parse-utils to handle large number of columns.
* Reduce the number of source places that need to be changed in
order to get more than 256 columns and/or 65536 rows.
* Fix --geometry, I hope.
* Start handling invalid (== non-utf8) file names.
* Fix minor leak in excel loader.
* Improve precision of GEOMEAN and PRODUCT.
* Fix MOD for non-integer (or just huge) args.
* Fix division by zero in MROUND.
* Fix a bunch of gnum_float issues.
* Fix leaks in COLUMN and ROW.
* Sort names in name dialog.
* SC importer work.
* Various UTF-8 work.
* Fix double replacement problem for search-and-replace with a
regular expression matching an empty string.
* Fix GAMMAINV.
* Improve precision for qgamma (and thus GAMMAINV).
* Fix a few cases of col/row confusion.
Nicolas Peninguy:
* Use regexps to classify currency and accounting formats
Tim A. Garner:
* Hide hidden data in html export
* In the LaTeX exporter optionally export math in italics
Jon KÃ¥re:
* Remove old Python plugin
--------------------------------------------------------------------------
Gnumeric 1.1.9
Andreas:
* Fix #92367, #94300
Christian Neumair:
* Made most dialogs HIG compliant.
Jody:
* Start enabling the graph guru.
* Begin to re-enable xls document metadata.
* Fix translations in the bonobo build.
* Enable translation of function category names.
* Parser support for both syntaxes of 3d reference.
* Parser support for row or col only references (A:C or 1:5)
* Fix some drawing issues related to the pango conversion.
* Remove usage of some deprecated functions.
* Fix handling of files named .xml.gz
* Improvements for ExprEntry
* Make autocorrect unicode-safe, and port dialog to treeview.
* Fix 'address' so that we pass all of the tests.
* Fix handling of optional scalar arguments.
* Convert many of the IS* info functions to nodal:scalar.
* Support implicit iteration for array expressions.
* Fix sheet object ref counting error that Morten found.
* Fix crash when destroying unshared view.
* Start fleshing out support signals to give scripting more power
* Move the CORBA support code into a plugin and make more functional.
* Add some UI for managing hyperlinks of various sorts (unfinished)
* Make the location status box smarter about named ranges
* Begin support for intersection
* Start parsing range sets
* Simple OpenOffice importer (expr and content but no formating)
* Support multi-region version of INDEX
* Handle obscure corner case in xbase importer
Michael Meeks:
* Spruce up the CORBA code to use some bonobo utils.
Morten:
* Leak plugging.
* Leak plugging in support libraries.
* Speeding up a few string value constructions.
* Really make autocorrect utf8 safe.
* Add FIB function.
* Fix loading of sheets with error constants in expressions, such
as #REF!
Lutz Müller:
* Drag & Drop sheet re-ordering
--------------------------------------------------------------------------
Gnumeric 1.1.8
dorami@bu.iij4u.or.jp:
* Begin to use Pango in cells.
Jody:
* Add XL import for polygon colours.
* More pango work.
* Fix icon assignment.
* Support pasting utf8
* Rewrite plan perfect import, significantly more useful now.
Includes some format transfer and uses the wordperfect
charset map from kword (thanks to Ariya Hidayat)
* Cull out a pile of special iconv code in favour of glib
* Fix documentation installtion to match libgnome's expectations
* locale -> utf8 conversion for lotus wk1 importer
* support for BITAND and BITOR in lotus wk1 importer
* Tweak XL export so that MS Excel does not produce a warning when
reading our sheets.
* Partially fix printing images
Jon KÃ¥re:
* Port to new libgsf big file api
Jukka:
* Solver improvements:
- Imported the GLPK (GNU linear programming kit) version 3.2.
It provides a revised simplex algorithm for solving large
scale problems, written by Andrew Makhorin. It performs
much better than lp-solve if the model is large, see
a benchmark in ftp://plato.la.asu.edu/pub/lpsimp.txt.
- Added the algorithm selection into the dialog.
- Other dialog improvements.
* Speed optimizations for the MPS plugin.
Morten:
* Add poor man's utf8 regexp routines.
Christian Meyer:
* Renamed "Print Setup" to "Page Setup" in the file menu and the
gnumeric documents.
Zbigniew:
* Work on the plugins.
* Plugins can now register menu and toolbar items (bonobo only for now)
* Another step towards a gtk only build.
--------------------------------------------------------------------------
Gnumeric 1.1.7
Jody:
* Fix and speed up the XL exporter.
* Make the behaviour for right button consistent in all contexts.
* Fix import of frozen panes.
* Fix XL export of functions with fewer args than XL requires
* Improve the wk1 importer
* Implement some of Harlan's CELL routines to help the wk1 importer
* Make sheet deletion multi-view safe.
* More fixes for named expressions.
* Remove old bogosity when importing the err form of #REF!
* Fix handling of embedded newlines for gtk2
* Fix Chema's bug.
* Don't leak clipboard on exit.
* Have Enter move the edit_pos while in the editline the same way it
does in the cell.
* Support Double click in cell to start editing.
* Change the cursor when the mouse is in the edit item.
* Improve (Fix?) colwidth exporting in xls
* Fix XLS name import in the presence of external links
* Extend XLS array import
* Take a step towards supporting external links in XLS.
* Fix reporting of import errors.
* Fix ref-count problem importing builtin names in XLS.
* Enable and patch the plan perfect importer.
* Fix ref-count problem with cell comments.
* Ultra basic support for Excel 95 Polygon objects.
* Fix colour leak with grid colour change, and small warning.
Jukka:
* New random distribution functions (mostly integrated from the
GNU Scientific Library with some minor modifications):
RANDDISCRETE(), RANDGAUSSIANTAIL() and RANDLANDAU().
* New random distributions for the random number generation tool:
Gaussian Tail, Landau, and Uniform integer.
* New financial function, VDB(), integrated from the OpenOffice
with some modifications and clean up.
* New statistical functions (integrated from the R 1.5.1 and
GSL 1.1.1):
BERNOULLI(), CAUCHY(), EXPPOWDIST(), GEOMDIST(), LANDAU(),
LAPLACE(), LOGISTIC(), PARETO(), RAYLEIGH(), and RAYLEIGHTAIL().
* Added `Filter->Show All'.
* Improved the function description layout in the
`Insert->Function' dialog.
* Function documentation improvements.
* Implemented standard errors output for the exponential
smoothing tool.
* Implemented the `Risk Simulation Tool'. You cannot find it in
XL, you have to pay more to get it as an extra add-in.
* Implemented SIMTABLE() function related to the risk simulation
tool.
* Initial EUROCONVERT() function.
Morten:
* Fix random number generator to really use /dev/urandom.
* More utf8 work.
* Make search utf8 safe (assuming utf8-ready regexp routines).
J.H.M. Dassen (Ray):
* Update desktop to reflect wider mime support.
Zbigniew:
* Work on the plugins.
--------------------------------------------------------------------------
Gnumeric 1.1.6
Andreas:
* Fix and improve html import.
* Make the analysis tools honour the lock state of cells.
* Properly handle output range preparation for analysis tools
even if the user did not want it cleared.
* Create ui to set protection of indiviual sheets.
* Make various edit actions check for locks first.
* Fix 85383, 84396, 88164.
Jody:
* Have the stf dialog use the default font.
* Use GsfInput for importing.
* Improve the Applix importer.
* Fix lifecycle for 3d references.
* Fix goto dialog's handling of invalid addresses.
* forward port missing patches from 1.0
* Finally add SheetView
* Move animated cursor selection to sheetview
* Handle enabling paste special on an application level
* Move selection to SheetView
* Parse and evaluate constructed references, no depends yet.
* Read edit_pos from xls for multi-selection case.
* Save selection correctly for xls.
* Move freeze state to SheetView.
* Decrease dependence on gal in favour of libgsf.
* Move libgsf for XL export
* Remove dependence on libole2 !
* Add a Quattro Pro importer
* Fix Lotus import of relative references, and formulas with strings
* Support url, and in workbook hyper-links, no UI or persistence yet.
* Import url, and in workbook hyper-links from xls
* Take steps towards support implicit iteration for function args.
* Handle cursor changes, and tooltips for hyper-links.
Jukka:
* More solver enhancements:
Reporting improvements.
Documentation updated.
* MPS plugin enhancements.
* New financial functions (integrated from the OpenOffice with
some modifications and clean up):
AMORDEGRC(), AMORLINC(), CUMIPMT(), CUMPRINC(), MDURATION(),
ODDLPRICE(), ODDLYIELD(), and YIELDMAT().
* Renamed Gnumeric's DURATION() as G_DURATION() and implemented
DURATION() like in XL (using OpenOffice code).
* Fixed YIELD().
* Moved all complex number functions from fn-eng plug-in to a
separate plug-in for complex numbers.
* New complex number functions (integrated from the GNU Scientific
Library with some minor modifications):
IMINV(), IMNEG(), IMARCSIN(), IMARCCOS(), IMARCTAN(), IMARCSEC(),
IMARCCSC(), IMARCCOT(), IMSEC(), IMCSC(), IMCOT(), IMSINH(),
IMCOSH(), IMTANH(), IMSECH(), IMCSCH(), IMCOTH(), IMARCSINH(),
IMARCCOSH(), IMARCTANH(), IMARCSECH(), IMARCCSCH(), and IMARCCOTH().
* Moved all random number generation functions from fn-math to a
separate plug-in (fn-random).
* New random distribution functions (mostly integrated from the
GNU Scientific Library with some minor modifications):
RANDBETA(), RANDCAUCHY(), RANDCHISQ(), RANDEXPPOW(), RANDFDIST(),
RANDGAMMA(), RANDGAUSSIAN(), RANDGEOM(), RANDGUMBEL(), RANDHYPERG(),
RANDLAPLACE(), RANDLEVY(), RANDLOG(), RANDLOGISTIC(), RANDLOGNORM(),
RANDPARETO(), RANDRAYLEIGH(), RANDRAYLEIGHTAIL(), RANDTDIST(),
RANDUNIFORM(), and RANDWEIBULL().
* New random distributions for the random number generation tool:
Beta, Cauchy, Chi-Squared, Exponential power, F, Gamma, Geometric,
Laplace, Levy alpha-Stable, Logarithmic, Logistic, Lognormal,
Pareto, Rayleigh, Rayleigh tail, T, Type I Gumbel, Type II Gumbel,
and Weibull.
Morten:
* Improve the Applix importer.
* Update mathfunc.c to R 1.5.1.
* Improve precision of HYPGEOMDIST and NEGBINOMDIST.
* Fix PERMUT crash.
* Fix RANDPOISSON loop and performance.
* Start making Search and Search/Replace UTF-8 safe.
* Resurrect long double support.
Jon KÃ¥re:
* Use GsfInput in the Python plugin loader
* Use GsfInput in the Nautilus component
* Open all probe-able file formats from the Nautilus component
* Added ISOYEAR().
--------------------------------------------------------------------------
Gnumeric 1.1.4
Almer:
* Implement validation criteria checking.
(http://bugzilla.gnome.org/show_bug.cgi?id=72554)
* Port part of the string functions to utf8.
Andreas:
* Improve printing dialogs.
* Make print-setup changes undoable.
* Add zoom factor preference.
* Add sheet selector to print-setup dialog.
* Fix print range selection.
* Added new stats function CRONBACH.
* Improve focus handling in search dialog
(http://bugzilla.gnome.org/show_bug.cgi?id=81087).
* Persist printer information
* Add GUI to plugin manager to add/remove extra plugin
directories
* Add discard all/save all buttons to exit dialog.
* Add a rescan directories button to the plugin manager
(Note: this has seen only minimal testing.)
* Fix bug:
http://bugzilla.gnome.org/show_bug.cgi?id=82272
http://bugzilla.gnome.org/show_bug.cgi?id=80126
http://bugzilla.gnome.org/show_bug.cgi?id=82398
Jody:
http://bugzilla.gnome.org/show_bug.cgi?id=83392
* fix name definition.
http://bugzilla.gnome.org/show_bug.cgi?id=79925
* Only grab if selection succeeds.
* Fix drawing glitch when creating unshared views not at A1
* Copy freeze state and outline info
* Ignore combos associated with filters.
Jukka:
* More solver improvements.
Morten:
* Cleanup fn-database.
* Disentangle fn-stat and fn-database.
* Make fn-database a plugin.
* Make fn-stat a plugin.
* Improve goal seek for the case without a proper df.
* Fix XIRR.
* Plug leaks and improve speed of string functions.
* Fix DOLLAR.
* Fix ROW and COLUMN.
* Prevent gcc 2.96 compilation.
* Fix leaks for unknown function stubs.
Jon KÃ¥re:
* Install bonobo control
* Merge bonobo control commands into container's menus
* Make bonobo control zoomable
* Enable bonobo control to display message dialog.
--------------------------------------------------------------------------
Gnumeric 1.1.3
Andreas:
* Port print-setup dialog.
* Fix print dialog.
* Make all Analysis Tools undoable.
* Add output formatting options to Analysis Tools.
* Make undo-size configurable.
* Plug leaks.
* Add preference dialog.
* Improve treeview cell renderers.
* Make Random Generator Tool undoable.
* Fix and improve row-height dialog.
* Fix hide/show detail and group/ungroup dialog.
* Include more info in HTML 4.0 files.
* Support borders in HTML4.0 exports.
* Fix Sheet-Object-Scrollbar configuration dialog.
* Fix Sheet Object leak.
* Fix Sheet-Object-Checkbox configuration dialog.
* Fix Sheet-Object Arrow/Line configuration dialog.
* Fix Sheet-Object Fill configuration dialog.
* Fix workbook attribute dialog.
* Add preference setting to include sheet name in undo/redo
description
* Fix missing data handling of SUMPRODUCT and friends
* Fix CONCATENATE (http://bugzilla.gnome.org/show_bug.cgi?id=78610)
* Add number of sheets preference
* Start to UTF8 some of the string functions
* Preserve autocorrect exception lists
* Switch plugin manager from gnome-config to gconf
* Add window size preference page to preference dialog
* Add file/xml preference page to preference dialog
* Redesign Error info dialog
* Improve x-selection handling
* Fix http://bugzilla.gnome.org/show_bug.cgi?id=76474
* Add lowering and raising of sheet objects (except widgets).
* Fix http://bugzilla.gnome.org/show_bug.cgi?id=79809
* Add lowering and raising of sheet objects (except widgets) to top and bottom.
* Fix http://bugzilla.gnome.org/show_bug.cgi?id=62127
* Fix http://bugzilla.gnome.org/show_bug.cgi?id=79744
Jody:
* Add password dialog to support encrypted input.
* Make expr parser utf8 clean.
* Fix printing.
* Fix object import from XL.
* Quicky insert image item.
* Tidy drag and Drop.
* Fix dateToUnix.
* Some touchups to bonobo build.
* cleanup autoconf.
* apply some pending japanese patches.
* Improve HIG compliance.
* Start support for filter importing.
* Fix sheetobjects in the presence of panes.
Jon KÃ¥re:
* Enable bonobo
* fix hpux build
* Clean up Guile plugin
* Enable use as a bonobo control
Jukka:
* More solver improvements.
Morten:
* More and better chunk allocation.
* Fixed memory corruption in LINEST and LOGEST.
* Plug gigantic leak in parser.
* Improve gnumeric-expr-entry's utf8 support and speed.
* Plug various little leaks.
* Add logical XOR function.
* Make fn-date a plugin.
* Make fn-eng a plugin.
* Make fn-financial a plugin.
* Make fn-info[rmation] a plugin.
* Make fn-logical a plugin.
* Make fn-lookup a plugin.
* Make fn-math a plugin.
* Make fn-string a plugin.
* Partially untangle remaining fn-files.
--------------------------------------------------------------------------
Gnumeric 1.1.2
Almer:
* Make autoformat edges toggleable.
Andreas:
* Make Single-Factor ANOVA undoable.
* Port search dialog.
* Add merge tool.
* Implement setting and changing of tab colors.
* Port search/replace dialog.
* Reimplementation of function selector.
* Reimplementation of formula guru.
* Add `recently used' to function selector.
* Fix csv importer crash.
* Port summary dialog and make it modeless.
* Make summary changes undoable.
* Fixed #68048.
Jody:
* Fix XL import of external function names.
* plug item-bar leak.
* Rewrite editable-label to use gtkentry and to be utf8 clean.
* Fix scrollbar & checkbox object cloning.
* Support Applix's #AND# #OR# #NOT#
* Rework dependent relocation.
* Improve event handling during sheet-object editing.
* Add dependency support for 3d references. needs work on delete.
* More polish to dependency engine.
* Big ExprTree -> GnmExpr rename in prep for libgnumeric.
* Support importing encrypted XLS workbooks (password is temporarilly
hard coded)
Jukka:
* More solver improvements.
Morten:
* Plug leaks.
* Add aggressive expression sharing during load.
* Add chunk allocators for cells, dependents, and some values.
* Fix conditional formats, more or less.
* Fix F4 key.
* Fix PROB function's argument order.
--------------------------------------------------------------------------
Gnumeric 1.1.0 and 1.1.1
Almer:
* Fixes to the STF exporter. (#72416, #71783)
Andreas:
* Port gnumeric_notice to gnome2.
* Fix #63485.
* Make the autosave dialog non-modal, port to gnome2.
* Make the analysis tools warnings non-modal.
* Make the autocorrect dialog non-modal, port to gnome2.
* Fix gnome2 specific random tool crash.
* Destroy outadated dialogs.
* Port solver dialog to gnome2.
* Make the solver information dialogs non-modal.
* Make the goal-seek warnings non-modal.
* Port consolidate dialog to gnome2.
* Make the consolidate warning dialogs non-modal.
* Allow cross-sheet consolidation.
* Turn sheet-rename dialog into guru.
* Port filter dialog to gnome2 using the expr-entry
widget and improve filter mechanism.
* Port the plugin manager dialog to gnome2.
* Improve numerical precision in single factor ANOVA.
* Correct regression analysis tool (intercept == 0 case).
* Port and redesign sort dialog.
* Reenable the expr entry widgets in gurus.
* Fix about dialog.
* Convert lots of dialogs to use the new expr entry
widget correctly.
* Add help buttons to various dialogs.
* Make reordering of sheets undoable.
* Port zoom dialog and convert it into a guru.
* Improve Sheet-Order dialog.
* Make add/modify comment undoable.
* Make comment clearing undoable.
* Make comment deletion undoable.
* Add `Add/Modify Comments' item to cell context menu.
* Fix 73491.
* Improve comment popup.
* Make adding sheet undoable/redoable
Jakub Steiner:
* Some new icons.
Jody:
* Initial port to gnome2.
* Enable microhash depend mechanism.
* Rework the range relocation logic.
* Rework sheet order dialog and make it a guru.
* Clean sheet object widget creation.
* Improve key handling when there are gurus.
* Crash importing 3d references to external workbooks.
* move libole2 req into excel plugin, and make it optional.
* guruify autoformat dialog, and update autoformat code.
* move format from cell -> value.
* add an icon to the expr-entry (thanks Jacub)
* make images available without bonobo, including printing.
* fix scrollwheels for gnome2.
* more fixage for libxml2.
* improve xl import of images.
* start moving to utf8 internals.
* fix pango context leak.
* improve xl95 export.
* Implement hooks to support per instance depends
(eg data sources or INDIRECT)
* Fix formula guru.
* Initial pass at dumping the translated function docs into a manual.
* Cleanup name import from xls, and handling of fwd sheet decls in xl95.
* Move the font mapping into the core rather than at XL import.
* Cleanup the sheet's use of dependents.
* Improve dependent management.
* Prep for importing external references from XL.
* Better support for 3d references.
* Add a sample external data source.
* fix paste-special.
Jon KÃ¥re:
* More correct import of "automatic" colors from Excel.
* Export "automatic" colors to Excel.
* Simplify and fix bugs in Excel color import and export.
* Support cropping in Excel image import.
Joshua R. Odom:
* Reorganize the custom pixmaps.
Jukka:
* Major rewrite of the Solver. Integrated key parts of the LP
Solve 3.2 written by Michel Berkelaar and others.
Morten:
* Fix DATE2UNIX. (Bug 70814.)
* Fix compiler warnings. (Well, fix the bugs they pointed out.)
* Partially clean up regression code.
* Fix regression's singularity test.
* Fix validation's use of abs to be fabs.
* Improve random number generation using /dev/urandom device.
* Fix Oleo plugin's isdigit usage.
* Support for --with-long-double
* Constify C strings.
* Switch to newer R sources.
* Fix "make -j" in plugins.
* Add extra tests for singularity and near-singularity in
regression.
* Clean up Fourier analysis.
* Fix validation int check.
* Fix analysis tools crashes.
Scott Ananian:
* Update the debian control files.
* Initial support for WorkbookView::is_protected.
Wayne Schuster:
* Implement opening of comment dialog by double clicking marker.
--------------------------------------------------------------------------
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.
