BREAKING CHANGES
- Data Validations will be stored by worksheet, not cell. Index can be one or more cells or cell ranges. Issue #797 Issue #4091 Issue #4206 PR #4240
- Conditional Formatting adds Priority property and handles overlapping ranges better. Issue #4312 Issue #4318 PR #4314
- Csv Reader will no longer auto-detect Mac line endings by default. Prior behavior can be explicitly enabled via
setTestAutoDetect(true), and it will not be possible at all with Php9+. Issue #4092 PR #4340 - Html Writer will now use "better boolean" logic. Booleans will now be output by default as TRUE/FALSE rather than 1/null-string. Prior behavior can be explicitly enabled via
setBetterBoolean(false). PR #4340 - Xlsx Writer will now use false as the default for
forceFullCalc. This affects writes withpreCalculateFormulasset to false. Prior behavior can be explicitly enabled viasetForceFullCalc(null).PR #4340 - Deletion of items deprecated in Release 3. See "removed" below.
Added
- Pdf Charts and Drawings. Discussion #4129 Discussion #4168 PR #4327
- Allow spreadsheet serialization. Discussion #4324 Issue #1741 Issue #1757 PR #4326
Removed
- Worksheet::getStyles - no replacement. PR #4330
- The following items were deprecated in release 3 and are now removed.
- Drawing::setIsUrl - no replacement.
- Settings::setLibXmlLoaderOptions() and Settings::getLibXmlLoaderOptions() - no replacement.
- Worksheet::getHashCode - no replacement.
- IReader::SKIP_EMPTY_CELLS - use its alias IGNORE_EMPTY_CELLS instead.
- Worksheet::getProtectedCells - use getProtectedCellRanges instead.
- Writer/Html::isMpdf property - use instanceof Mpdf instead.
Fixed
- Xls writer Parser Mishandling True/False Argument. Issue #4331 PR #4333
- Xls writer Parser Parse By Character Not Byte. PR #4344
- Minor changes to dynamic array calculations exposed by using explicit array return types in some tests. PR #4328