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>
Assets
2
This version fixes the reading of 1904 dates option.
Assets
2
Spout v3 is finally out!
You can check out what changed in the Upgrade guide.
Assets
2
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
Assets
2
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
Assets
2
- Remove control characters to avoid breaking ODS files
- Fix crash when writing an empty row from an associative array (XLSX)
Assets
2
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...
Assets
2
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
shouldFormatDateoption - Extended support for prefixed XML files
- A few other minor/perf changes
Assets
2
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
Assets
2
- Consistent behavior among all readers when reading cells with leading/ending spaces.
- Added protection against closing file handles that were not properly created