Gnumeric 1.12.22 aka "TBD" is now available.

The Gnumeric Team is pleased to announce the availability of Gnumeric version 1.12.22. This release requires the concurrently released goffice 0.10.22 and libgsf 1.14.33.

Noteworthy news in this release:

  • Graph fixes and improvements.
  • Test suite improvements.
  • ODF/XLSX import and export fixes.
  • A schema for the ODF files we produce.

As part of our testing we check that the ODF, XLSX, and Gnumeric files we produce are valid according to the relevant xml schema.

  • For Gnumeric files we provide the schema.
  • For XLSX there is an official schema which we use with a few fixes so Excel can read our files. (We consider the format to be defined by what XLSX writes.)
  • For ODS the situation is more problematic. We appear to be the first to release a schema for the ODS files we produce. That is mildly shocking -- several spreadsheets have ODS as their primary format, yet no-one seem to be validating the files they produce! There is an official schema for the format without extensions which is fine, except that no-one uses that format because there are lots of fairly basic things that cannot be expressed in the format without extensions.

Details of changes by contributor:

  • Andreas
    • Improve ODF import/export of additional axes. [Bug 746321].
    • Fix ODF export of styles for additional axes. [Bug 746621].
    • Simplify export of SEC and SECH to ODF. [Bug 747211].
    • Harden ODF import against fuzzed files. [Bug 747447][Bug 747448].
    • Fix ODF import/export of unlinked checkboxes and radio buttons.
    • Plug leak in ODF import and export. [Bug 747590].
    • Improve pattern fill round trip through ODF.
    • Fix export of Ring plots to ODF. [Bug 747763].
    • Fix import/export of Pie charts from/to ODF. [Bug 747807].
    • Add more determinism to ODF export. [Bug 747916].
  • Jean
    • Fix signal handling while running Python. [Bug 744638].
    • Implement absolute anchoring for sheet objects.
    • Make graphs (and images) not resize with cells by default. [Bug 684450].
  • Morten
    • 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. [Bug 747210].
    • Fix sheet filter problem.
    • Minor R.DNORM improvement.
    • Improve RAYLEIGH accuracy.
    • Improve R.QCAUCHY accuracy.
    • Add TANPI and COTPI functions.

goffice 0.10.22 aka "TBD" is now available.

The Gnumeric Team is pleased to announce the availability of goffice version 0.10.22.

Noteworthy news in this release:

  • Graph fixes and enhancements.

Details of changes by contributor:

  • Jean
    • Fix selection of axes using only part fo the plot area. [Bug 746456].
    • Protect colored xy and bubble plots against NULL z values.
    • Update circular axis bounds after a unit change. [Bug 746738].
    • Auto fill color made transparent for opened markers. [Bug 691025].
    • Make manual scale really manual. [Bug 700599].
  • Johannes Deutsch
    • Do not draw the line over the arrow head at start. [Bug 745736].
  • Morten
    • Improve log axis bounds. [Bug 745960].
    • Fix format used for stacked percentage graphs.
    • Don't force bar/col axis to include 0 for log axis.
    • Don't force radial plots to include 0 for log axis.
    • Rewrite pattern-fill rendering. [Bug 747212].
    • Add go_cotpi and go_atan2pi.
    • Fix persistence of ring plot center size.