box/spout

Noteworthy changes:

• [ODS/XLSX] Big performance improvement, mostly related to how Styling is done (thanks @alamirault!)
• [XLSX] Support for strict OOXML

Fixes:

• [ALL] Headers setting now follows RFC6266
• [ODS/XLSX] Floats are no longer stored as locale dependent
• [XLSX] Spout now supports inline strings with multiple value nodes
• [XLSX] Fixed skipped cells that were possibly in the wrong order

Noteworthy changes:

• [ALL] Support for PHP 7.1 was removed. 7.2 is the oldest version supported now.
• [ALL] Spout now fully supports PHP 8

Fixes:

• [ODS] Improved boolean support

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>

This version fixes the reading of 1904 dates option.

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

You can check out what changed in the Upgrade guide.

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

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

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

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...

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