Releases: PHPOffice/PhpSpreadsheet
Releases · PHPOffice/PhpSpreadsheet
3.4.0
Security Fix
- Several security patches.
Added
- Add Dynamic valueBinder Property to Spreadsheet and Readers. Issue #1395 PR #4185
- Allow Omitting Chart Border. Issue #562 PR #4188
- Method to Test Whether Csv Will Be Affected by Php9. PR #4189
Changed
- Refactor Xls Reader. PR #4118
Deprecated
- IReader::SKIP_EMPTY_CELLS - use its alias IGNORE_EMPTY_CELLS instead.
- Worksheet::getProtectedCells was deprecated in release 2, but was not properly documented, and not removed in release 3. Use getProtectedCellRanges instead.
- Writer/Html::isMpdf property was deprecated in release 2, but was not properly documented, and not removed in release 3. Use instanceof Mpdf instead.
Moved
- Nothing yet.
Fixed
- Xls Writer Condtional Rules Applied to Whole Rows or Columns. Issue #3185 PR #4152
- Xlsx Writer Duplicate ContentTypes Entry for Background Image. Issue #4179 PR #4180
- Check strictNullComparison outside of loops. PR #3347
- SUMIFS Does Not Require xlfn. Issue #4182 PR #4186
- Image Transparency/Opacity with Html Reader Changes. Discussion #4117 PR #4142
- Option to Write Hyperlink Rather Than Label to Csv. Issue #1412 PR #4151
- Invalid Html Due to Cached Filesize. Issue #1107 PR #4184
- Excel 2003 Allows Html Entities. Issue #2157 PR #4187
- Changes to ROUNDDOWN/ROUNDUP/TRUNC. Issue #4213 PR #4214
- Writer Xlsx ignoredErrors Before Drawings. Issue #4200 Issue #4145 PR #4212
- Allow ANCHORARRAY as Data Validation list. Issue #4197 PR #4203
2.3.2
2024-11-10 - 2.3.2
Possible error in release process for 2.3.1.
Fixed
- 2.3.1 omitted.
- Backported security patches.
- Write ignoredErrors Tag Before Drawings. Backport of PR #4212 intended for 3.4.0.
- Changes to ROUNDDOWN/ROUNDUP/TRUNC. Backport of PR #4214 intended for 3.4.0.
Added
- Method to Test Whether Csv Will Be Affected by Php9. Backport of PR #4189 intended for 3.4.0.
2.1.3
2024-11-10 - 2.1.3
Fixed
- 2.1.2 omitted.
- Backported security patches.
- Write ignoredErrors Tag Before Drawings. Backport of PR #4212 intended for 3.4.0.
- Changes to ROUNDDOWN/ROUNDUP/TRUNC. Backport of PR #4214 intended for 3.4.0.
Added
- Method to Test Whether Csv Will Be Affected by Php9. Backport of PR #4189 intended for 3.4.0.
1.29.4
1.29.4 - 2024-11-10
Fixed
- 1.29.3 omitted
- Backported security patches.
- Write ignoredErrors Tag Before Drawings. Backport of PR #4212 intended for 3.4.0.
- Changes to ROUNDDOWN/ROUNDUP/TRUNC. Backport of PR #4214 intended for 3.4.0.
- Replace str_starts_with in Drawing. Issue #4215
Added
- Method to Test Whether Csv Will Be Affected by Php9. Backport of PR #4189 intended for 3.4.0.
3.3.0
This should have been a 3.0.0, but a typo was made when releasing. This has no technical impact and will stay as-is.
Dynamic Arrays
- Support for Excel dynamic arrays is added. It is an opt-in feature, so our hope is that there will be no BC breaks, but it is a very large change. Full support is added for Xlsx. It is emulated as Ctrl-Shift-Enter arrays for Ods read and write and Excel2003 and Gnumeric read. Html/Pdf and Csv writers will populate cells on output if they are the result of array formulas. No support is added for Xls or Slk.
Added
- Excel Dynamic Arrays. Issue #3901 Issue #3659 Issue #1834 PR #3962
- String Value Binder Allow Setting "Ignore Number Stored as Text". PR #4141
Changed
- Xlsx Reader default datatype when none is specified in Xml is changed from string to numeric, which is how Excel treats it. There is expected to be little impact because DefaultValueBinder and AdvancedValueBinder correct mis-identification as string, and StringValueBinder usually expects string. PR #4139
- Currency and Accounting Wizards are changed to act like Excel, and a new CurrencyBase Wizard is added for for non-Excel formats. Issue #4125 Issue #4124 PR #4127
- Images will not be added to spreadsheet if they cannot be validated as images.
Deprecated
- Nothing yet.
Removed
- The following items were deprecated in release 2 and are now removed.
- Writer\Xls\Style\ColorMap (no longer needed).
- Reader\Xml::trySimpleXMLLoadString (should not have been public, no public replacement).
- Calculation\Calculation::_translateFormulaToLocale (use method name translateFormulaToLocale without leading underscore).
- Calculation\Calculation::_translateFormulaToEnglish (use method name translateFormulaToEnglish without leading underscore).
Moved
- Nothing yet.
Fixed
- Several security patches.
- Xls Reader Some Ranges Not Handled Properly. Issue #1570 PR #4140
- Better Handling of legacyDrawing Xml. Issue #4105 PR #4122
- Improve Xlsx Reader Speed. Issue #3917 PR #4153
2.3.0
2024-09-29 - 2.3.0
Fixed
- Backported security patches.
- Improve Xlsx Reader speed (backport of PR #4153 intended for 3.0.0). Issue #3917
- Change to Csv Reader (see below under Deprecated). Backport of PR #4162 intended for 3.0.0. Issue #4161
- Tweak to AMORDEGRC. Backport of PR #4164 intended for 3.0.0.
Changed
- Images will not be added to spreadsheet if they cannot be validated as images.
Deprecated
- Php8.4 will deprecate the escape parameter of fgetcsv. Csv Reader is affected by this; code is changed to be unaffected, but this will mean a breaking change is coming with Php9. Any code which uses the default escape value of backslash will fail in Php9. It is recommended to explicitly set the escape value to null string before then.
2.1.1
2024-09-29 2.1.1
Fixed
- Backported security patches.
- Change to Csv Reader (see below under Deprecated). Backport of PR #4162 intended for 3.0.0. Issue #4161
- Tweak to AMORDEGRC. Backport of PR #4164 intended for 3.0.0.
Changed
- Images will not be added to spreadsheet if they cannot be validated as images.
Deprecated
- Php8.4 will deprecate the escape parameter of fgetcsv. Csv Reader is affected by this; code is changed to be unaffected, but this will mean a breaking change is coming with Php9. Any code which uses the default escape value of backslash will fail in Php9. It is recommended to explicitly set the escape value to null string before then.
1.29.2
1.29.2 - 2024-09-29
Fixed
- Backported security patches.
- Support for Php8.4.
- Change to Csv Reader (see below under Deprecated). Backport of PR #4162 intended for 3.0.0. Issue #4161
- Tweaks to ROUNDUP, ROUNDDOWN, TRUNC, AMORDEGRC (results had been different under 8.4).
Changed
- Images will not be added to spreadsheet if they cannot be validated as images.
Security Patch
2.2.2
Added
- Nothing yet.
Changed
- Nothing yet.
Deprecated
- Nothing yet.
Moved
- Nothing yet.
Fixed
- Html Reader Preserve Unicode Whitespace. Issue #1284 PR #4106
- RATE Function Floating Point Number of Periods. PR #4107
- Parameter Name Change Xlsx Writer Workbook. Issue #4108 PR #4111
- New Algorithm for TRUNC, ROUNDUP, ROUNDDOWN. Issue #4113 PR #4115
- Worksheet applyStylesFromArray Retain Active Cell (Excel 16 was having a problem with some files). Issue #4128 PR #4132