Spout changelog

Changelog History

• v3.1.0 Changes

  December 03, 2019

  🆕 New features:

  • 👍 [XLSX] Added support for writing cell formats
  • [XLSX & ODS] Cell alignment

  🛠 Fixes:

  • [ALL] Cell indexes not being respected when rendering row
  • 👍 [XLSX & ODS] Added support for cells in error when writing
  • 💅 [XLSX] Support for missing styles XML file
  • 👍 [ODS] Added support for whitespaces inside <text:span>

• v3.0.1 Changes

  June 06, 2019

  🛠 This version fixes the reading of 1904 dates option.

• v3.0.0 Changes

  May 24, 2019

  Spout v3 is finally out!
  🍱 🎉🎉🎉🎉🎉🎉

  ⬆️ You can check out what changed in the Upgrade guide.

• v2.7.3 Changes

  September 25, 2017

  👌 Improvements:

  • 🔦 Exposed API to get the last active sheet

  🐛 Bug fixes:

  • 🛠 Fixed shared strings XML file using a prefix
  • 🛠 Fixed shared strings XML Entities auto decode

• v2.7.2 Changes

  March 28, 2017

  👌 Improvements:

  • CSV Reader can now read lines of any length and is not limited to 32768 bytes per line
  • It is now possible to create 2 spreadsheets at the same time and have sheets with the same name. Uniqueness is enforced at the workbook level.
  • 👌 Improved error message when an invalid sheet name is set
  • Introduced hard limit on the character count for XLSX cells (32,767 characters)

  🐛 Bug fixes:

  • 🛠 Fixed parsing of the XLSX spreadsheet dimensions
  • 🛠 Fixed reading of ODS sheet names
  • 👍 Better support for empty rows in XLSX files
  • 👍 Better support for cells with custom inner style/phonetic description in XLSX files
  • Calling close() when a writer is already closed no longer causes an error

• v2.7.1 Changes

  November 03, 2016

  • ✂ Remove control characters to avoid breaking ODS files
  • 🛠 Fix crash when writing an empty row from an associative array (XLSX)

• v2.7.0 Changes

  October 19, 2016

  Major Enhancements:

  • 🆕 New option to preserve empty rows when reading
  • 🆕 New option to disable automatic text wrapping
  • 👍 ODS Reader now supports num-rows-repeated attribute

  Minor Enhancements:

  • 👻 Temporary files are now deleted when an exception is thrown while reading
  • 👌 Improve support for custom date formats
  • Empty rows don't get written to file for XLSX Writer

  🔨 Refactoring:

  • ➕ Added internal ReaderOptions
  • ➕ Added XMLProcessor to easily process XML files
  • And more...

• v2.6.0 Changes

  September 08, 2016

  🆕 New features included in this new version:

  • ➕ Added support for background color
  • 💅 It is now possible to override the default style for the spreadsheet. This leads to a big perf improvement.
  • 💅 Empty cells can now have a custom style applied to them

  🛠 Fixes:

  • 🛠 Fix for borders support in Excel 2013+
  • Cells formatted as dates for XLSX files should respect the shouldFormatDate option
  • 🛠 Extended support for prefixed XML files
  • A few other minor/perf changes

• v2.5.0 Changes

  July 11, 2016

  🛠 This new version contains several fixes/improvements:

  • 👍 better support for dates:
    • support for cells formatted as time
    • option to return formatted dates instead of PHP objects
  • ODS reader and writer improvements:
    • support for hyperlinks/inline formatting
    • ODS writer now accepts associative arrays (like other writers)
  • 👍 Border support!
  • 🆕 New option to skip BOM addition in CSV file
  • 🛠 Numerous fixes to not-so-standard XLSX files. Spout now support spreadsheets with:
    • prefixed XML files
    • missing "uniqueCount" and/or "count" attributes in shared strings table
    • missing cell reference in sheet definition

• v2.4.4 Changes

  April 12, 2016

  • Consistent behavior among all readers when reading cells with leading/ending spaces.
  • ➕ Added protection against closing file handles that were not properly created