Spout Versions Save

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

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

• Fixed an issue when writing boolean values to XLSX files - #175
• Added optional support for custom stream wrappers (only works with CSV) - #176
• Fixed an issue when reading CSV files which happen to have a EOL delimiter inside an enclosed text - #183
• Fixed an issue when reading zeros and empty strings from ODS files - #184
• XLSX and ODS writers did not properly release the file handle - #190

Added support for variable EOL in CSV files

• Added support for XLSX files that have sheets not defined in order of appearance
• Fixed bug when parsing large numbers

Multiple optimizations:

• empty cells are not written, saving space
• hot functions have been optimized for better performance

The created files' mime type is now correctly detected. Support for dates beyond 2037.

This release includes a few improvements:

• Better support for CSV files with very long lines
• Reading numeric timestamp in XLSX files now returns a proper date
• Prevention of folder name conflict when 2 folders are created at exactly the same microsecond

This release contains 2 fixes:

• prevent infinite loop for multi-lines CSV when all lines are empty
• Resolve "Cannot open file" issue occurring on some Windows platforms

Spout now supports a new document format: ODS! Through the same interface, it is now possible to read CSV, XLSX and ODS files.

Other improvements:

• explicit error when trying to configure the writer after opening it
• better support for boolean values in XLSX files

Fixed bug preventing a XLSX file to be read in iOS and Numbers. Added detection of invalid sheet names (which resulted in an error message when the file was opened in Excel) Added font color support