What's new in Gnumeric 1.12.46
Nov 7, 2019
- Andreas:
- Fix format import from ODF. [#403]
- Jean:
- Fix charts size in XLS format. [#414]
- Fix loading string from arrays in charts. [#416]
- Implement wrapping of rotated text. [#394]
- Morten:
- Fix over-eager guessing of dates in csv. [#401]
- Fix Mac build problem. [#402]
- Fix inter-process paste crash [#406]
- Fix problem saving cell protection to xlsx. [#409]
- Look for python3 before python. [#419]
- Fix SUMIF (etc) problem with blank criteria. [#423]
- Improve editing of percentages. [#413]
- Thomas Kuehne:
- Improve html import. [#392]
- Shlomi Fish:
- Command line export of graphs. [#410]
New in Gnumeric 1.12.45 (Jun 4, 2019)
- Doc fixes. [Bug 380] [Bug 381] [Bug 382].
- Add DIGAMMA function.
- Support ISO-8601 UTC date/time input. Mostly. [Bug 371].
- Improve cvs separator guessing. [Bug 397].
- Add export option "active-sheet". [Bug 396].
- Fix compilation issue. [Bug 378].
- Handle odf files with no styles whatsoever. [Bug 389].
- Improve Excel standalone-xml import. [Bug 391].
New in Gnumeric 1.12.44 (Nov 26, 2018)
- Fix document properties types. [#367]
- Call pygobject_init() if needed. [#368]
- Fix SWITCH's default argument. [#354]
- Fix problem with setting auto-func. [#357]
- Fix problem reading really old xls format.
- Fix sheet filter problem. [#359]
- New NT_RADICAL function.
- Fix conditional style crash.
- Fix applix locale problem. [#362]
- Fix applix encoding and escape problems. [#363]
- New LAMBERTW function.
- Plug sheet object leak with paste.
- Fix documentation problem for vararg functions.
New in Gnumeric 1.12.42 (Aug 11, 2018)
- Plug leaks.
- Introspection fixes.
- Work around gtk+ breakage re. link colors.
- Fix problems with ssconvert --export-file-per-sheet. [#694408]
- Enable ssconvert --export-file-per-sheet for html, latex, and pdf.
- Test suite improvements.
- ssconvert improvements.
- Makefile improvements.
- Don't save any configuration when running ssconvert/ssdiff/...
- Turn GnmFunc into a GObject.
- Make clipboard output deterministic.
- Fix conditional format crash [#343].
New in Gnumeric 1.12.41 (May 10, 2018)
- Fix problem with object pasting.
- Fix undo problem for cell comments. [#732653]
- Exit with non-zero with we fail to load file on command line.
- Fix undo crash. [#795861]
- Introspection fixes.
- Don't offer more than 15 significant digits by default. [#754391]
New in Gnumeric 1.12.40 (Apr 30, 2018)
- Andreas:
- Fix histogram tool for the case of no labels. [#795475]
- Dean McCarron:
- Introspection fixes.
- Morten:
- Add floating-point environment sanity check. [#794515]
- Before saving, verify that files hasn't changed on disk. [#334024]
- Add GUI for comparing sheets.
- Introspection fixes.
- Clean up workbook view construction.
- Test suite improvements.
- Fix problems with boxed types.
- Avoid most punting for object properties.
- Fix paste from LibreOffice.
- Fix paste to LibreOffice -- use Biff8. [#795280]
- Allow inter-process paste-special. [#346630]
- Fix ssconvert --merge-to problem with names. [#795408]
- Fix problem with image pasting.
- Allow pasting an image into Gnumeric. [#366816]
- Full-column paste includes column width. [#121722]
- Auto-fix shared array formulas in gnumeric files.
- No-net-access doc build. [#790226]
- No-net test suite fixes.
New in Gnumeric 1.12.39 (Mar 14, 2018)
- Morten:
- Fix ssdiff problem. [#792038]
- Fix ISREF.
- Some internal array formula code cleanups.
- Fix problem with stopping a glpk solver.
- Improve workaround for gtk+ scrollbar bug. [#792417]
- Fix minor issue for MUNIT.
- Rafael Fontenelle:
- Doc fixes. [#792556] [#792592]
New in Gnumeric 1.12.38 (Dec 29, 2017)
- Avoid large stack use here and there.
- Test suite improvements.
- Improve sylk writer. Don't ask.
- Teach ssdiff about column/row sizes.
- Teach ssdiff about defined names.
- Fix a few ssdiff crashes.
- Fix crash on text import.
New in Gnumeric 1.12.37 (Dec 27, 2017)
- Test suite improvements.
- Improve format guessing for newly entered formulas.
- Improve PERMUTATIONA for unusual arguments. [#790742]
- Extend range of NT_PI.
- Improve xlsx export of cell comments. [#790756]
- Plug leaks.
- Fix potential crash on exit.
- Speed-up number theory functions.
- Fix combo object icon.
- Code cleanups for main binary.
- Fix potential crash in gtk scroll bar bug workaround.
- Avoid large stack use here and there.
New in Gnumeric 1.12.36 (Nov 21, 2017)
- Andreas:
- Improve contour plot export/import to/from ODF. [#788728]
- Improve contour plot import of Excel generated ODF. [#788801]
- Improve surface plot export to ODF. [#788447]
- Fix export/import of CONCATENATE to and from ODF.
- Fix export/import of minor axis divisors to and from ODF.
- Fix import of affice trendline from ODF. [#789538]
- Jean:
- Fix background of multiple selection. [#789411]
- Workaround for gtk scroll bar bug. [#789412]
- Morten:
- Convert all xpm files to png.
- Avoid to-pixdata options for resources. It's going away.
- Minor CORREL improvement.
- Fix error on xlsx files with bogus Print_Area.
- xlsx import improvements for contour graphs.
- xlsx export improvements for contour graphs.
- Fix xlsx export of trend line equation.
- Fix xlsx import and export of trend line affine flag.
- Avoid critical on exporting unnamed xlsx trend line.
- Fix VDB for partial periods. [#790299]
New in Gnumeric 1.12.35 (Jul 7, 2017)
- Jean:
- Fix cell border style selectors with recent gdk-pixbuf. [#781988]
- Morten:
- Test suite improvements.
- Improve relative accuracy of BESSELJ and BESSELY.
- New function REDUCEPI.
- Fix further fallout from glpk format change. [#783077]
New in Gnumeric 1.12.34 (Mar 23, 2017)
- Noteworthy news in this release:
- Hyperlinks fixes
- xlsx/ods import fixes.
- Details of changes by contributor:
- Andreas:
- Fix hyperlinks import from ODF. [Bug 779635].
- Jean:
- Fix xlsx export of chart series names. [Bug 778618].
- Always export a transparent fill style in charts. [Bug 779160].
- Morten:
- Doc fixes.
- Fix xlsx import with missing header/footer. [Bug 778292].
- Minor xlsx import improvements with alias colors.
- Test suite improvements.
- Improve Excel handling of hyperlinks.
- Hyperlinks improvements. [Bug 706671].
- Plug leaks.
- Fix issues with sheet-local names.
- ssdiff improvements with hyperlinks, input messages, conditional formats, and validations.
- Make exit code from ssdiff follow diff's.
- Fix ssdiff with inter-sheet references.
- Fix style border colour sharing.
New in Gnumeric 1.12.33 (Jan 30, 2017)
- Fix export/import of scaling information to/from ODF.
- Fix Wilcoxon Signed Rank Test handling of ties. [#772718]
- Fix xlsx export of scale to page information. [#776196]
- Fix use of cell formats in graphs data labels. [#777338]
- Speed up sstest part of test suite.
- Bring documentation build into the 21 century.
- Non-linear solver improvements.
- Avoid atomizing style regions with conditional formats.
- Adapt to glpk file format changes.
- Fix stf problems with text format. [#777543]
New in Gnumeric 1.12.32 (Aug 30, 2016)
- Andreas:
- Improve html4.0 fragment export. [#769343]
- Fix moving averages, exponential smothing and principal component tools. [#769659]
- Jean:
- Fix paradox plugin build with pxlib-0.6.7. [#769319]
- Morten:
- Avoid gnome-common dependency.
- New text functions CONCAT, TEXTJOIN.
- New selection functions IFS, SWITCH.
- New aggregation functions SUMIFS, AVERAGEIFS, MINIFS, MAXIFS, COUNTIFS.
- Fix criteria function issue with errors in the selector area.
- Fix corner case for MINA and MAXA.
- Fix criteria matching of numbers against strings.
- Test suite improvements.
New in Gnumeric 1.12.31 (Jun 30, 2016)
- Fix case issues for database functions.
- Anchor COUNTIF criteria at end too.
- Add tests for COUNTIF.
- Fix inter-process paste crash. [Bug 768164].
New in Gnumeric 1.12.28 (Mar 23, 2016)
- Noteworthy news in this release:
- Solver sensitivity report
- Complex number improvements
- Fuzzed file fixes. [Bug 761663] [Bug 761727] [Bug 762278].
- Plug leaks.
- Fix problems with ssconvert to lp/cplex formats.
- Add sensitivity report to solver.
- Fix bounds problem with cplex exporter.
- Fix IMARCCOSH(1).
- Add more tests for complex number evaluation.
- Improve accuracy of IMLOG10.
New in Gnumeric 1.12.27 (Feb 8, 2016)
- ODF roundtrip fixes.
- Fixes for more fuzzed-file problems with thanks to Juha Kylmänen from Oulu University Secure Programming Group.
- Work around gtk+ problem in some versions of gtk+ causing windows to grow on each save and reload.
- Details of changes by contributor:
- Read/write rich-text font-size from ODF files. [Bug 759983].
- Read/write zoom values to/from ODF files in LO compatible way. [Bug 700013].
- Read new attribute to am/pm element in ODF import. [Bug 760043].
- Fix NETWORKDAYS. [Bug 760576].
- Fuzzed file fix. [Bug 760546].
- Fix data labels when the source is a range with several rows and columns. [Bug 761048].
- Teach ssconvert to split sheets into separate .txt files [Bug 694408].
- Improve test suite.
- Fuzzed file fixes. [Bug 760046] [Bug 760085] [Bug 760087] [Bug 760089] [Bug 760043] [Bug 760103] [Bug 760102] [Bug 760101] [Bug 760105] [Bug 760106] [Bug 760104] [Bug 760229] [Bug 760231] [Bug 760232] [Bug 760544] [Bug 760545] [Bug 761295].
- Fix R.DBINOM extreme-value case. [Bug 760230].
- New function AGM.
- Fix canvas problem leaving grab in place. [Bug 760639].
- Work around gtk+ bug causing growing windows. [Bug 761142].
- Improve BESSELJ and BESSELY.
- Improve BETA accuracy.
- Fix problem with database functions. [Bug 761305].
- Fix font problem for ssconvert to pdf. [Bug 761296].
- Fix bison check. [Bug 761398].
- Improve IMIGAMMA coverage.
New in Gnumeric 1.12.26 (Dec 30, 2015)
- Fix potential crasher on showing initial window.
New in Gnumeric 1.12.25 (Dec 28, 2015)
- Add support in recent files dialog for multiple selesction and double click.
- Fix TABLE problems.
- Fuzzed file fixes.
- Add R.DGUMBEL, R.PGUMBEL, R.QGUMBEL.
- Fix conditional format problem.
- Test also RANDWEIBULL and RANDLOGNORM.
- Fix problem with R.QHYPER
- Add R.DRAYLEIGH, R.PRAYLEIGH, R.QRAYLEIGH.
- Fix GUI translation problems.
- Fix bugs with merged cells.
- Make builds more reproducible.
- Improve ssdiff for validation.
- Fix problem with xls export of list validation.
New in Gnumeric 1.12.24 (Oct 14, 2015)
- Fix printing of sheet objects with one cell or absolute anchors. [Bug 753961].
- Fix snap to grid for one cell or absolute anchored objects. [Bug 754792].
- On export, just change the extension, not more. [Ubuntu Bug 1497344].
New in Gnumeric 1.12.23 (Jul 29, 2015)
- Fix memory handling error on fuzzed sxc file. [Bug 748535].
- Improve import/export of page layout from/to ODF.
- Improve function import to ODF. [Bug 750627].
- Add CONFIDENCE.T, MODE.MULT, PERCENTILE.EXC, PERCENTRANK.EXC and QUARTILE.EXC.
- Fuzzed file fixes. [Bug 751060] [Bug 751501] [Bug 751851] [Bug 751922].
- Fix ODF import of named expressions. [Bug 750627].
- Import reference unions from ODF. [Bug 750627].
- Improve CONVERT function.
- Fix xlsx import of plot area manual layout. [Bug 748016].
- Fix out of bounds read. [Bug 749121].
- Fuzzed file fixes. [Bug 750042] [Bug 751217] [Bug 751270] [Bug 751271] [Bug 751383] [Bug 751384] [Bug 751758] [Bug 751744] [Bug 751908] [Bug 751920] [Bug 751249] [Bug 751945] [Bug 751909] [Bug 751946] [Bug 751968] [Bug 751969] [Bug 751971] [Bug 751989].
- Fix import/export of graph backplane.
- Fix export of unlabelled axes.
- Fix export of rotated axis labels.
- Fix xlsx save crash related to shared strings. [Bug 748477].
- Solver code refactoring.
- Plug leaks.
- Fuzzed file fixes. [Bug 748595] [Bug 748597] [Bug 749031] [Bug 749030] [Bug 749069] [Bug 748533] [Bug 749118] [Bug 749166] [Bug 749181] [Bug 749184] [Bug 749236] [Bug 749240] [Bug 749234] [Bug 749235] [Bug 749271] [Bug 749270] [Bug 749424] [Bug 749917] [Bug 749919] [Bug 750043] [Bug 750044] [Bug 750046] [Bug 750811] [Bug 750810] [Bug 750857] [Bug 750864] [Bug 750862] [Bug 750858] [Bug 751126] [Bug 751254] [Bug 751253] [Bug 750851] [Bug 751258] [Bug 751259] [Bug 751502] [Bug 751390] [Bug 751579] [Bug 751659] [Bug 751660] [Bug 751662] [Bug 751970] [Bug 752022] [Bug 751988] [Bug 752021] [Bug 752080] [Bug 752081] [Bug 752124].
- Make solver check linearity of model.
- Fix xls saving of marker style. [Bug 749185].
- Make compilation with clang work again. [Bug 749138].
- Fix xlsx problem with import of header/footer. [Bug 750853].
- Fix xls save problem with characters outside codepage. [Bug 750856].
- Fix named expression problem. [Bug 751056].
- Fix xlsx namespace problem. [Bug 751120].
- Protect database functions against malformed database. [Bug 751392].
- Fix csv problem with invalid UTF-8 data. [Bug 751577].
- Fix GROWTH. [Bug 751658].
- Restrict TABLE to array context. [Bug 751871].
New in Gnumeric 1.12.22 (Apr 17, 2015)
- Improve ODF import/export of additional axes. [#746321]
- Fix ODF export of styles for additional axes. [#746621]
- Simplify export of SEC and SECH to ODF. [#747211]
- Harden ODF import against fuzzed files. [#747447][#747448]
- Fix ODF import/export of unlinked checkboxes and radio buttons.
- Plug leak in ODF import and export. [#747590]
- Improve pattern fill round trip through ODF.
- Fix export of Ring plots to ODF. [#747763]
- Fix import/export of Pie charts from/to ODF. [#747807]
- Add more determinism to ODF export. [#747916]
- Fix signal handling while running Python. [#744638]
- Implement absolute anchoring for sheet objects.
- Make graphs (and images) not resize with cells by default. [#684450]
- xlsx import/export of log axis.
- xlsx export of multiple plots in chart.
- Fix xlsx import of multiple axes.
- Fix xlsx title export problem.
- Fix xlsx export problem with series' style.
- Fix xlsx import/export of sheet tab text colour.
- Improve test suite.
- Actually implement DECIMAL.
- Fix BETA problem with special case.
- Fix MIDB and REPLACEB length check.
- Fix PERMUATIONA corner case.
- Fix RANDLOG.
- Fix RANDGEOM to use same distribution as R.DGEOM.
- Improve xlsx roundtrip of GOStyle.
- Improve reading of xlsx theme colours.
- Plug leaks.
- Fix REPLACEB problem. [#747210]
- Fix sheet filter problem.
- Minor R.DNORM improvement.
- Improve RAYLEIGH accuracy.
- Improve R.QCAUCHY accuracy.
- Add TANPI and COTPI functions.
New in Gnumeric 1.12.21 (Mar 6, 2015)
- ODF import/export general plot data specifications. [Bug 743818].
- ODF import/export the z-index for line objects.
- Fix ODF import of stroke colours of sheet objects.
- Fix ODF import/export of fill colour and type. [Bug 744051].
- Fix ODF import/export of marker fill and outline colours.
- Improve ODF export of manually positioned charts in multi-chart graphs. [Bug 743789].
- Fix ODF export of serieslines styles.
- Fix ODF import/export of axes label visibility. [Bug 743788].
- ODF import/export additional axislines.
- Fix ODF import/export of fonts in charts. [Bug 744632].
- ODF import/export additional axes. [Bug 743787].
- Fix ODF style import of secondary plots. [Bug 744930].
- Fix ODF style export for data points in plots. [Bug 745091].
- Implement xlsx import of sheet widgets.
- Implement xlsx export of sheet widgets.
- Fix xlsx import/export of patterns.
- Plug leaks.
- Arrow properties editor. [Bug 158327].
- Fix xlsx export of line style None.
- Fix search-and-replace problem with text format.
- Fix xlsx import/export of gradients.
- Fix undo problems with scrollbars.
- Fix spinner properties dialog.
- SheetObjectImage fixes.
- Fix problem reading images from xls.
- Namespace fixes.
- Test suite improvements.
- Fix various dtd version problems.
New in Gnumeric 1.12.20 (Feb 5, 2015)
- ODF import/export trendline names. [Bug 743448].
- ODF import/export trendline affinity and dimensions.
- ODF import/export major and minor chart axis tick marks.
- ODF import/export chart axis min and max formulae.
- Fix ODF export of single cell ranges in graphs. [Bug 743619].
- ODF import/export series fill types. [Bug 743613].
- ODF import/export marker outline colour.
- ODF export all charts in a graph.
- ODF import/export axis positions.
- ODF import/export series lines. [Bug 743785].
- ODF import/export all plots in a chart. [Bug 743786].
- xlsx chart import: fix font family name.
- xlsx import/export trend line names.
- Fix gda plugin compilation. [Bug 743506].
- Fix xlsx export problem with auto markers.
- Import/export xlsx chart axis min/max/steps.
- Export xlsx chart axis tick marks.
- Fix xlsx problem with inverted axis.
- Export sliders as scrollbars for xls.
- Fix xls loading of horizontal scrollbars. [Bug 743754].
- Plug leaks.
- Fix xlsx comment export.
- Make XL see our exported xlsx axes.
- Fix xlsx import/export of axis font info. [Bug 743822].
New in Gnumeric 1.12.19 (Jan 24, 2015)
- Add latex fragment exporter of visible rows only. [Bug 739512].
- Fix ants problems.
- Plug leaks.
- Pay more attention to union access rules.
- Attempt a fix for clipboard crash. [Redhat Bug 1160975].
- Truncate long strings for display in stf import.
- Fix crash on closing a graph sheet.
- Fix undo crash with conditional formatting and insert row. [Bug 741197].
- Fix xlsx export of HYPGEOMDIST.
- Fix xlsx export of document properties.
- Fix multihead issue with graph windows.
- Improve test suite.
- Reorganize icon handling.
- Allow removing a specific item from the history. [Bug 735305].
- Fix GNM_HALIGN_DISTRIBUTED rendering. [Bug 726155].
- Restore translations of function help texts.
- Fix import of extended float formula results from wk4 files.
- Fix ADDRESS problem.
- Fix sheet-filter problem with errors. [Bug 742601].
- Improve error handling for .gnumeric a bit.
- Improve xlsx graph import: line colour; marker size; marker color; no lines; bounding box; trend lines; regression equations; axis label.
- Improve xlsx graph export: line style; bar/col direction; marker shape; marker size; marker color; axis label; chart title; trend lines.
- Improve xlsx export: default col widths; schema validity.
- Improve modifier handling. [Bug 743130].
- Fix import of extended floats from wk4 files. [Bug 739679].
New in Gnumeric 1.12.18 (Sep 26, 2014)
- Noteworthy news in this release:
- Workaround gtk+ api/abi breaks.
- Details of changes by contributor:
- Improve documentation. [Bug 733466].
- Add warning dialog. [Bug 733352].
- Fix rich text roundtrip through ODF. [Bug 737039].
- Fix dialogs behavior in full screen mode. [Bug 736395].
- Save axis format to xls. [Bug 736656].
- Fix recent files dialog crasher. [Bug 737261].
- Fix xls export problem. [Bug 733771].
- Update WEEKDAY function.
- Fix xlsx export problem for strings. [Bug 736202].
- Improve xlsx import of rich text.
- Text suite improvements.
- Fix minor ods rich text import problem.
New in Gnumeric 1.12.17 (Jun 10, 2014)
- xlsx import/export improvements.
- Fix UMR. [Bug 730727].
- Fix crashes on exit. [Bug 730857] [Bug 730884].
- Handle value formats for xlsx export. [Bug 724517].
- Improve xlsx import/export of rich text. [Bug 726189].
- Fix solver critical.
New in Gnumeric 1.12.16 (May 24, 2014)
- ODS import/export improvements.
- Fix database-range import from ODF. [Bug 730197].
- Improve chart roundtrip through ODF. [Bug 728197].
- Fix export of non-ODF interpolation types to ODF.
- Fix export of titles and subtitles to ODF. [part of Bug 730397].
- Fix axis sub-element order in ODF export. [part of Bug 730397].
- Fix undo crash related to hyperlinks. [Bug 730466].
- Start moving off GtkUIManager.
- Clean out old #ifdef.
- Fix ods series marker import/export.
- Fix plan-perfect issue. [Debian Bug 748054].
- Make installtion work without scrollkeeper.
- Improve import/export testing. [Bug 730397].
- Speed up certain large ranges of conditional formatting.
- Work towards making ods export deterministic.
New in Gnumeric 1.12.15 (May 1, 2014)
- Fix chart size in ODF import. [#728278]
- Improve chart roundtrip through ODF. [#728197]
- Export centre-across-selection in a way LO can understand. [#726010]
- Improve format roundtrip through ODF.
- For xlsx, don't complain over "ext" elements.
- xlsx graph import improvements.
- Attempt a fix for tabs appearance with gtk+ 3.12. [#728465]
- Make it possible to have all callables as python functions. [#728611]
- Improve format roundtrip through ODF.
- Plug leaks.
- Make search dialog non-modal again. [#728817]
New in Gnumeric 1.12.14 (Apr 14, 2014)
- Improve format import from ODF files.
- Plug leaks.
- xlsx conditional format fixes. [#726202]
- Fix semantics of conditional format operators. [#726806]
- Fix xlsx quotes in formula strings. [#726824]
- Fix xls export of rich text.
- Fix problems with large, circular farms of VLOOKUP etc. [#723894]
- Let goffice handle conditional number formats.
- Attempt a workaround for Ubuntu scroll bars.
- Fix odf parse problems.
- Fix array editing.
- Fix column/row header colouring problem. [#728007]
New in Gnumeric 1.12.13 (Mar 19, 2014)
- Fix export of comboboxes to ODF.
- Fix export of help messages to ODF.
- Import invisible alignment characters in number formats from ODF. [part of #725852]
- Fix fill-alignment export/import to and from ODF. [part of #726035]
- Fix distributed-alignment export to ODF. [part of #726035]
- Fix ODF roundtrip of "center accross selection". [#726010]
- Improve ODF roundtrip of conditional formats. [#726201]
- Fix import & export of cell indent from/to ODF.
- Fix ODF roundtrip of underlines.
- Fix tooltip position for scale or RTL sheets. [#725941]
- Really fix the hyperlink tips persistence. [see #706659]
- Support volatile functions. [#305798]
- Improve testing.
- Import/Export super/subscript fonts to xlsx. [Part of #726035]
- Import xlsx auto-filters. [#725460]
- Update Gnumeric schema.
- Fix rich text problem. [#726086]
- Improve xls import/export of conditional formats. [#726202]
- Fix case sensitivity for conditional formats. [#726246]
- Fix minor conditional format GUI issues.
- Plug leak.
- Fix font dialog problem with underline.
- Fix crash reading strange xls file. [Redhat #1076912]
- Fix problem clearing existing values in some xlsx cells. [#726297]
- Fix criticals for dynamic deps in conditional formats. [#726163]
- Fix LOG2 problem. [#726464]
New in Gnumeric 1.12.11 (Feb 17, 2014)
- Fix hang on xls/biff7 save. [#724399]
- Release infrastructure improvements.
- Improve testing for xls/biff7.
New in Gnumeric 1.12.9 (Nov 29, 2013)
- Implement double click for graph sheets. [Bug 712216]
- Minor improvement to history dialog.
- Fix drop-down sizing (gtk+ regression). [Bug 710749].
- Improve accuracy of R.QCAUCHY.
- Acquire more special function test cases.
- Improve accuracy of R.QGAMMA and thus R.QCHISQ.
- Improve accuracy of R.QBETA, R.QF, R.QTUKEY, R.QSNORM, and R.QST.
- Improve accuracy of COMBIN, PERMUT, POCHHAMMER, FACT, GAMMA.
- Improve accuracy of bessel functions with large non-integer alpha.
- Improve accuracy of ACOTH.
- Fix fuzzed file problems. [Bug 708091] [Bug 712662] [Bug 712685] [Bug 712700] [Bug 712708] [Bug 712772] [Bug 712788] [Bug 712731] [Bug 715003].
- Restore sheet reordering by drag.
- Fix BETA on win32.
- Fix win32 registry initialization.
- Fix win32 gdk-pixbuf install heisen-crash.
- Incorporate new tests from crlibm.
- New functions SINPI and COSPI.
- Improve accuracy of SIN/COS/TAN on win32.
- Work around GTK+ ABI break. [Redhat Bug 1033827].
- Fix dialog button order. [Bug 710378].
New in Gnumeric 1.12.8 (Oct 8, 2013)
- Win32 fixes
- Update/fix documentation [Bug 708679][Bug 707075][Bug 708556].
- Fix paste into locked cells [Bug 702292].
- Fix radio buttons behavior in covariance dialog. [Bug 707595].
- Add a border around font selector in cell format dialog. [Bug 708567].
- Fix fuzzed file crash. [Bug 707875].
- Use lighter green for function markers. [Bug 708573].
- Fix item cursor problem. [Bug 709320].
- Fix win32 compilation.
New in Gnumeric 1.12.7 (Sep 2, 2013)
- Extend BESSELJ and BESSELY to handle fractional order. [#706720]
- Fix crash with split pane. [#707047]
New in Gnumeric 1.12.6 (Aug 28, 2013)
- A redraw problem with gtk+ 3.9.x has been fixed.
- A performance problem with large sheets has been fixed.
New in Gnumeric 1.12.5 (Aug 20, 2013)
- Fixes for more fuzzed-file problems with thanks to Juha Kylmänen from Oulu University Secure Programming Group.
- Input messages have been implemented
- ODF import/export fixes
- Andreas
- Improve ODF import of cells with links. [Bug 704022].
- Fix import of multi-paragraph text from ODF. [Bug 704391].
- Fix ODF export of empty rows. [Bug 704438].
- Export custom shapes. [Bug 704421].
- Fix export to ODF of empty cells with default column styles. [Bug 704563].
- Improve import to ODF of empty cells with default column styles. [Bug 704563].
- Speed up loading of some ODF files. [Bug 704422].
- Fix ODF style import. [Bug 704563].
- Fix crash on corrupted files. [Bug 704636] [Bug 705385] [Bug 705421] [Bug 705420] [Bug 706075].
- Fix ODF import of charts with series consisting of multiple ranges. [Bug 704742].
- Fix ODF export of charts with series consisting of multiple ranges.
- Implement input message editing. [Part of Bug 705310].
- Fix export of input-message only validations. [Bug 705384].
- Fix warnings. [Part of Bug 705313].
- Show input messages. [Bug 705310].
- Fix Excel XML import. [Bug 705223].
- Fix documentation. [Bug 705541].
- Avoid crashing when printing sheet object widgets from ssconvert. [Bug 705638].
- Fix printing of sheet object widgets. [Bug 705650] [Bug 705653].
- Use current GTK style when printing sheet object widgets from Gnumeric. [Bug 705684].
- Scale tiny buttonssheet objects when printing. [Bug 705689].
- Dmitry Matveev
- Bring back gda support. [Bug 604690].
- Jean
- Fix text wrap inside sheet objects. [Bug 704417].
- Fix export of scatter/bubble plots to xls. [Bug 705311].
- Fix crash when importing fuzzed chart from xls. [Bug 705353].
- Accept nodes in guppi graphs. [Debian Bug 718594].
- Avoid crashing after destroying a SheetWidgetAdjustment associated widget. [see Gtk+ bug Bug 705692].
- Morten
- Fix crazy parsing problem. [Bug 704109] [Bug 704140].
- Fix crashes on corrupted files. [Bug 704102] [Bug 704004] [Bug 704325] [Bug 704562] [Bug 705866].
- Fix conditional format problem. [Bug 704445].
- Fix R1C1 parsing issue. [Bug 705637].
- Improve handling of large-area conditional styles.
- Fix (?) Applix pattern importer. [Bug 705946].
- Fix FMR. [Part of Bug 705913].
- Fix sheet removal dep problem. [Bug 706095].
- Fix test failure. [Bug 705947].
New in Gnumeric 1.12.4 (Jul 15, 2013)
- Andreas:
- Improve xlsx export of Gnumeric functions.
- Improve xlsx import of Excel 2010 functions.
- Improve xls import of Excel 2010 functions.
- Fix documentation of r.q* and r.*nbinom. [Bug 703164].
- Add Excel 2010's BETA.DIST.
- Fix crash on corrupted files. [Bug 703149] [Bug 703215] [Bug 703625] [Bug 703895].
- Fix import of sxc files. [Bug 703249].
- Fix TDIST Import/Export from/to ODF.
- Write manual legend position to ODF. [Bug 703362].
- Fix position handling in strict ODF export.
- Jean:
- Don't attempt to add a path item when there is no path object. [Bug 703052].
- Morten:
- Improve accuracy for 2-argument ERF.
- Fix crashes on corrupted files. [Bug 703143] [Bug 703307] [Bug 703306].
- Fix --with-long-double tests. [Bug 703397].
- Fix problems saving auto filters to xls. [Bug 703308].
- Improve handling of large graph ranges. [Bug 703546].
- Fix analysis issue with translations. [Bug 703355].
- Fix COUNTIF (etc) pattern matching. [Bug 703770].
New in Gnumeric 1.12.3 (Jun 26, 2013)
- Andreas:
- Fix border handling for merged cells in LaTeX export.
- Fix 'Go to First'. [Bug 699631].
- Fix data merges. [Bug 699897].
- Fix editing of hyperlinks. [Bug 700732].
- Fix conditional formatting crash. [Bug 700969].
- Do not include hidden cells in automatic print range. [Bug 700994].
- Make buttons 1 and 2 behave similarly when selecting cells. [Bug 700792].
- Warn when encountering extLst in xlsx import. [Bug 700018].
- Use ctrl-a only to select the whole sheet, if the sheet has focus. [Bug 699746].
- Add a keyboard shortcut to jump to the current cell indicator. [Bug 699710].
- Fix placement of hyperlink tooltip. [Bug 701436].
- Adjust cell comment display. [Bug 698519].
- Make reference display in paste/define names dialog consistent with sheet preferences. [Debian Bug 699054].
- Write/read pagesetup settings to/from xlsx. [Bug 701834].
- Fix in-cell-combos attached to merged cells. [Bug 702146].
- Use the pagesetup setting to determine the landscape option in LaTeX export [Bug 702169].
- Fix ODF crash. [Bug 702197].
- In ODF import ignored mentioned but not included sheets. [Bug 698388].
- Fix crash on corrupted files. [Bug 702205] [Bug 702219] [Bug 702285] [Bug 702288] [Bug 702364] [Bug 702409] [Bug 702486] [Bug 702485] [Bug 702498] [Bug 702322] [Bug 702689].
- Some documentation improvements. [Debian Bug 621735] [Debian Bug 530462].
- Fix crash on xlsx import due to external references. [Bug 702407].
- Fix reading of conditional formats from xls files. [Bug 702612].
- Fix reading of solid fill conditional formats from xlsx files. [Bug 702615].
- Improve xlsx import of new stat function names.
- Fix export of FLOOR(x) to xlsx. [Debian Bug 464732].
- Fix clipboard related crash. [Bug 702868].
- Darrell Tangman:
- Update documentation for Edit and Insert menus. [Bug 700596].
- Update documentation for comments and hyperlinks. [Bug 700797].
- Consolidate comment, hyperlinks, names documentation.
- Update documentation for Manage Sheets, R1C1 notation, sheet ranges. 1.12 updates, typo corrections, misc. cleanup.
- Dmitry Smirnov:
- Fixes to the gnumeric and ssconvert manual pages.
- Jean:
- Adjust labels vertical alignment in document properties dialog. [Bug 700156].
- Don't crash when exchanging missing axes. [Bug 702126].
- Don't accept GNM_SHEET_PATTERNS as a valid pattern. [Bug 702833].
- Morten:
- Improve xlsx import of style-only cells.
- Don't write empty cells to .gnumeric.
- Add MPSEUDOINVERSE function.
- Add ctrl-shift-z as extra accelerator for redo. [Bug 699579].
- Fix conditional format problem. [Bug 699647].
- Remove gobject property strings from translation corpus.
- Improve LINEST. [Bug 551457].
- Improve statfuns tests. [Bug 700294].
- Improve mathfuns tests. [Bug 700295].
- Add new R.PTUKEY function. [Bug 700132].
- Add new Q.PTUKEY function. [Bug 700132].
- Fix missing translation of certain function examples.
- Add new SNORM.DIST.RANGE function.
- Fix critical when last row deleted.
- Fix criticals in about dialog.
- Introspection fixes.
- Fix xls/biff5 link export. [Bug 701604].
- Workaround problems with automake 1.13.
- Fix crashes on corrupted files. [Bug 702101] [Bug 702182] [Bug 702218] [Bug 702267] [Bug 702277] [Bug 702379] [Bug 702658] [Bug 703006].
- Improve xls import of new stat function names.
- Plug leaks.
New in Gnumeric 1.12.2 (Apr 27, 2013)
- New font selector
- ODF import improvements
- XLS import/export fixes
- Graph property editor fixes
- Various GUI parts can be styled via css
- New sheet functions: POCHHAMMER, OWENT, NT_OMEGA, R.PST, R.QST, and R.QSNORM.
New in Gnumeric 1.12.1 (Mar 9, 2013)
- Crash for certain csv files from the command line fixed.
- Conditional formats' dependents tracked.
- New ssdiff command line utility to compare spreadsheets.
- New file history dialog.
- Avoid most deprecated parts of GTK+.
- GObject introspection fixes.
New in Gnumeric 1.10.17 (Aug 1, 2011)
- Andreas:
- Fix some style import from ODF. [#652492]
- Import/Export print formatting from/to ODF. [#653186]
- Write and read some document properties to and from XLSX.
- Fix xlsx schema violations.
- Fix keyword handling in properties dialog. [#653378]
- Allow document properties to be edited and added.
- Add an interface for conditional styles.
- Fix ODF import of styles with inherited conditional styles. [#654214]
- Provide undo for cut between 2 gnumeric processes. [#640922]
- Fix bar and column chart import/export to ODF.
- Speed up frequent calls to INTERPOLATION with the same
- abscissae/ordinates. [#654538]Export defined names to xlsx. [#655010]
- Implement printing of errors as blanks, dashes or NAs.
- Fix printing of column headers and borders when formulae are shown. [#655389]
- Fix import of Excel 2003 xml files in non-C locale. [#655554]
- Jean:
- Fix selection background. [#648676]
- Morten:
- Fix --with-gnome compilation: [#652802]
- Fix parsing crash. [Redhat #726860]
New in Gnumeric 1.10.13 (Feb 3, 2011)
- Andreas
- Calculate residuals when using the regression tool. [Bug 635064].
- Permit data entry by-passing autocorrection.
- Work around OpenOffice date formatting bugs. [Bug 636131].
- Export text formats to and import from ODF. [Bug 636158].
- Fix ODF import of sheets with far forward references. [Bug 636968].
- Add EEK support to EURO and EUROCONVERT.
- Fix leaks in potentially failing analysis tools.
- Make the row and column headers and selection match the theme better. [Bug 639019].
- Fix locale specific sorting. [Bug 638874].
- Ensure we have sub- and superscript icons. [Bug 639086].
- Fix advanced filter. [Bug 639444].
- Suppress function tooltips on text-formatted cells. [Bug 638832].
- Fix documentation of ATAN2. [Bug 640344].
- # Jean
- Only disable the formula bar when a chart sheet is selected. [Bug 636031].
- Make sheet objects invisible outline from .xls files persistent. [Bug 637393].
- Fixed arrows and line object position when zoomed. [Bug 637453].
- Fixed series lines color export to .xls. [Bug 637658].
- Fixed sheet objects position on zoomed sheets. [Bug 637739].
- Override edition-canceled property for GnmExprEntry. [Bug 639287].
- # Morten
- Fix array intersection problem with IF. [Bug 633433].
- Make sure columns are wide enough for dates in csv import.
- Plug a few leaks.
- Fix number-match issue regarding fraction.
- Fix problems with pivot reading from xls. [Bug 638776].
- Allow version-agnostic template files. [Bug 630247].
New in Gnumeric 1.10.12 (Nov 26, 2010)
- Andreas:
- Add argument to FOURIER to separate parts.
- Extend TREND function to handle multiple regression. [#630085]
- Fix selection for sheet object lists and combos. [#631322]
- Preserve selection for sheet object lists when we change content. [#631327]
- Add option to sheet object lists and combos to enter values rather than index. [#629333]
- Fix manual pagebreak handling when printing. [#631570]
- Add menu items to remove and add manual page breaks.
- Improve the sc import.
- Fix button sensitivity in sort dialog. [#632999]
- Fix ODF export of files with large formatted sheets. [#634135]
- Fix extensions of supported ODF files. [#635111]
- Hans de Goede:
- Fix import of dib format images in XLS. [#553098]
- Jean:
- Fixed maximum for col/row number in sheet resize dialog. [#631702]
- Eliminate glade usage. [#631717]
- Fixed crash in print setup. [#634149]
- Fixed image bounds in zoomed sheets.
- Morten:
- Fix crash related to broken xls. [#632050]
- Fix print area problem from broken xls.
- Fix printing crash. [#632439]
- Partially fix problem with undefined names. [#633140]
- Fix analysis tools problems when "as values" is chosen.
- Fix gtk+/X crash with large tooltips.
- Take care of dead kittens.
- Fix text object clipping issue. [#634597]
- Fix problem with disappearing window for empty file. [#634792]
- Fix ranges-in-expression criticals.
- Sameer Morar:
- Add key combinations to move sheets. [#634139]
- Modify quit dialog to be able to discard multiple files without saving. [#527133]
New in Gnumeric 1.10.10 (Sep 6, 2010)
- Andreas:
- Significantly improve chart export and import to/from ODF.
- Improve handling of corrupted ODF files.
- Fix percentage style import from ODF. [#627517]
- Fix INTERPOLATION documentation. [#627461]
- Provide progress info in ODF export.
- Improve warnings dialog in ODF import.
- Fix button sensitivity in sort dialog.
- Jean:
- Fix some interpolation and periodogram issues.
- Fixed graph scalar data editor behavior. [#628721]
- Morten:
- Plug sylk importer leak.
- Plug xml importer leak.
- Plug odf importer leak. [#627759]
- Extend domain of IMPOWER. [#627775]
- Allow use of glib's memory profiler.
- Fix some confusion of char vs. xmlChar.
- Fix elapsed-time entry. [#628082]
- Fix problems with limits for date axes.
- Improve function docs self test.
- Fix errors in function docs.
New in Gnumeric 1.10.8 (Jul 31, 2010)
- Andreas:
- Add new Excel and Openformula units ("pica" and "picapt") to CONVERT.
- Save default search settings. [#105615][#625185]
- Improve configurable text export of numbers. [#126444]
- Improve horizontal fill. [#594193]
- Improve function syntax tooltips. [#623317]
- Add weekend specifier to WORKDAY and NETWORKDAYS. [#172458]
- Fix ngettext usage.
- Fix undo text for sheet object duplication. [#623557]
- Fix additional undo entry for sheet object duplication. [#623559]
- Fix undo of object creation followed by duplication. [#623566]
- Avoid creating interacting auto filters. [#607086]
- Improve items of the cell context menu. [#74359]
- Fix various function docs issues. [#623669][#624559][#625102]
- Improve the presentation of the examples in the function documentation. [#623455]
- Fix HDATE and friends. [#623764][#625177]
- New functions DATE2HDATE, DATE2HDATE_HEB and DATE2JULIAN.
- Add hyperlink and comment removal menu items.
- Add merge and unmerge menu items.
- Add menu item to autofit column width or row height based on the selection only. [#125595]
- Add autofit actions to cell context menu.
- Add new function ARRAY. [#570689]
- Add new function SORT. [#59144]
- Add menu item to wrap SORT around an existing range.
- Show the number of rows filtered by the auto filter. [#346002]
- Improve function tooltips. [#623322]
- Improve expression entry range selection. [#80725][#624288][#624289][#624581]
- Add preference setting to disable the extension check for the configurable text exporter. [#594151]
- Add optional marker to indicate that a cell contains an expression. [#55124]
- Add merge and unmerge items to the cell context menu.
- Permit double-clicking of functions in the function selector.
- Allow single merge to single merge copying. [#87296]
- Make the font style buttons override the character attributes. [#163410]
- Provide name completion (F4) when entering functions. [#587084]
- Implement access to the function selector to paste function names while editing cells (Shift-F4).
- Add preference settings whether to show function name and/or argument tooltips.
- Fix undo of Clear->All and Clear->Comments. [#625151][#623803]
- Add menu items to allow clearing of filtered rows only.
- Fix editing of hyperlinks.
- Work around OOo's failure to correctly define its named ranges. [#625332]
- Remove range hightlighting while not editing expressions. [#625361]
- Reduce the size of the text import dialog. [#625281]
- Fix import of underlined/double underlined comments from xls. Part of [#405951]
- Improve xl import of underlines.
- Correctly size the autoexpressions. [#625521]
- Fix row height dialog. [#625543]
- Add menu to specify whether to enter as array, into multiple cells, etc. Part of [#53733]
- Make autofilter condition changes undoable. [#625143]
- Jean:
- Fix strong/weak cursor display. [#623241]
- Fix regression in ms_excel_chart_read. [#623960]
- Fix a regression in chart series evaluation. [#624263]
- Fix crash in cell_calc_span. [#624274]
- Install a self-consistent headers list.
- Fixed borders display in cell format dialog.
- Morten:
- Ask user to locate solver binaries when plain search fails. [#619519]
- Fix problem with solver target cell entry.
- Fix date function docs issues. [#623669]
- Fix gtk_show_uri problem affecting win32. [#623605]
- Fix mistakes pointed out by sparse.
- Fix win32 versioning problem. [#624171]
- Improve function doc checks.
- Eliminate almost all remnaining GdkGC usage.
New in Gnumeric 1.10.5 (May 31, 2010)
- Andreas:
- Add Wilcoxon-Mann-Whitney test tool.
- Morten:
- Fix stf crash. [#619283]
- Persist solver model type.
- Add non-linear solver. [#614865]
- Feed the gtk+ deprecation monster. [#572240]
- Fix win32/paradox problem. [#619942]
- Sameer Morar:
- Improve page setup dialog. [#619421]
New in Gnumeric 1.10.2 (Apr 17, 2010)
- Some documentation updates
- Fix build with --disable-solver. [#612820]
- Fix column and row header display under Quartz. [#600085]
- Fix preferences in gconf-less situations. [#613523]
- Implement first letter capitalization. [#613768]
- Extend regression tool to perform multiple simple regressions. [#614031]
- Fix ZTEST description. [#614746]
- Don't write unnecessary manifest entries in ODF export.
- Various ODF export fixes.
- Adjust regression tool to reflect the changes to TDIST.
- Basic import and export of text boxes from ODF files.
- Watch for the null date in OOXML import. [#615777]
- Write the null date in OOXML export.
- Print pattern backgrounds. [#615365]
- Improve object sizing tooltip positioning a bit.
- Fix filter critical. [#611073]
- Make more menu entries available when an object is selected.
- Improve partitioning of status area.
- Fix goal seek problem affecting XIRR. [#614147]
- Fix export xls of XIRR, FVSCHEDULE, and XNPV. [#614257]
- Set win32 stack size to 64M. [#571346]
- Patch gtk+ so GtkEntry widgets on win32 draw right. [#603667]
- Fix xls export of cell comments. [#615845]
- Fix error propagation problem. [#615772]
- Partially clean up INDEX implementation.
- Make regression functions return a result when goffice reports that the problem is near singular, but still good.
New in Gnumeric 1.10.1 (Mar 9, 2010)
- This is a bug-fix release.
New in Gnumeric 1.9.9 (Sep 14, 2009)
- This release fixes scrolling via mouse wheels.
- It improves ODF import and export, XLS/XLSX import, text import and export, and HTML export.
- It improves tools (2 factor ANOVA, Rank & Percentiles, and Fourier transform).
- New functions: FOURIER, COT, ACOT, GD, COTH, and ACOTH.
- It fixes the functions NPER, GCD, FIXED, and IF.
- It breaks GnmCommand out to allow commands in multiple files.
- It adds search-for-number.
- It fixes the format-as-currency action.
- It fixes increase/decrease precision for accounting formats.
- It has better handling of x^y^z.
- It implements new-from-template.
- It starts introducing external references for function documentation.
- It fixes TSA crashes.
New in Gnumeric 1.9.8 (Sep 14, 2009)
- Saves and loads text formatting of comments and sheet object labels.
- Improvements to the ODF exporter, ODF importer, and XLSX exporter.
- Closer to a turnkey Win32 build.
- fn-lookup caches are pruned in case someone is being silly.
- Respects the sheet size prefs for new blank workbooks.
- Caches large ranges, possibly sorted.
- Makes it possible to have horizontal widgets too.
- Fixes a sheet-object paste crash, a critical error in the format dialog, date conventions in graphs, and R1C1 issues.
- The GUI for date/time axes is improved.
- ssconvert has been extended to also merge multiple sheets.
New in Gnumeric 1.9.7 (Sep 14, 2009)
- An interface to format cell comments was added.
- Meta data is loaded from gnumeric files.
- rendr_value no longer crashes for NULL values.
- The use of builtin formats was enabled for XL2003-XML, and the ".sml" kludge was dropped.
- A preference entry was added to set the default value of autosave.
- Numerous load, export, and crash fixes were made.
New in Gnumeric 1.9.6 (Sep 14, 2009)
- Sheet sizes are now variable.
- Sheet sizes are shown in the manage sheet dialog.
- Metadata is written from the property dialog to the files.
- The list sheet object configuration dialog is complete.
- All sheet object configurations were made undoable.
- Text in the sheet object label is printed.
- Editing of a sheet object label was implement.
- More 2003-spreadsheetml formats are supported.
- Elapsed time formats are handled better on text export.
- XIRR was improved a bit. Applix, Lotus, XLS, and mps loading crashes were fixed.
- Sheet object, str.h usage was cleaned up.
- CSV and txt files are loaded into sheets as big as needed.
- A validation problem was fixed.
- The code was moved to libgda4.