Releases: PHPOffice/PhpSpreadsheet
Releases · PHPOffice/PhpSpreadsheet
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
2.2.1
Security Fix
- Prevent XXE when loading files PR #4119
Fixed
- Add Sheet may leave Active Sheet uninitialized. Issue #4112 PR #4114
- Reference to Defined Name Specifying Worksheet. Issue #206 PR #4096
- Xls Reader Print/Show Gridlines. Issue #912 PR #4098
- ODS Reader Allow Omission of Page Settings Tags. Issue #4099 PR #4101
2.2.0
2024-07-24 - 2.2.0
Added
- Xlsx Reader Optionally Ignore Rows With No Cells. Issue #3982 PR #4035
- Means to change style without affecting current cell/sheet. PR #4073
- Option for CSV output file to have varying numbers of columns for each row. Issue #1415 PR #4076
Changed
- On read, Xlsx Reader had been breaking up union ranges into separate individual ranges. It will now try to preserve range as it was read in. PR #4042
- Xlsx/Xls spreadsheet calculation and formatting of dates will use base date of spreadsheet even when spreadsheets with different base dates are simultaneously open. Issue #1036 Issue #1635 PR #4071
Deprecated
- Writer\Xls\Style\ColorMap is no longer needed.
Moved
- Nothing
Fixed
- Incorrect Reader CSV with BOM. Issue #4028 PR #4029
- POWER Null/Bool Args. PR #4031
- Do Not Output Alignment and Protection for Conditional Format. Issue #4025 PR #4027
- Conditional Color Scale Improvements. Issue #4049 PR #4050
- Mpdf and Tcpdf Borders on Merged Cells. Issue #3557 PR #4047
- Xls Conditional Format Improvements. PR #4030 PR #4033
- Conditional Range Unions and Intersections Issue #4039 PR #4042
- Ods comments with newlines. Issue #4081 PR #4086
- Propagate errors in Text functions. Issue #2581 PR #4080
- Csv Reader allow use of html mimetype. Issue #4036 PR #4040
- Problem rendering line chart with missing plot label. PR #4074
- More RTL in Xlsx/Html Comments Issue #4004 PR #4065
- Empty String in sharedStrings. Issue #4063 PR #4064
- Xlsx Writer RichText and TYPE_STRING. Issue #476 PR #4094
- Ods boolean data. Issue #460 PR #4093
- Html Writer Minor Fixes. PR #4089
- Changes to INDEX function. Issue #64 PR #4088
- Ods Reader and Whitespace Text Nodes. Issue #804 PR #4087
- Ods Xml Reader and Whitespace Text Nodes. Issue #804 PR #4087
- Treat invalid formulas as strings. Issue #1310 PR #4073
2.1.0
MINOR BREAKING CHANGE
- Writing of cell comments to Html will now sanitize all Html tags within the comment, so the tags will be rendered as plaintext and have no other effects when rendered. Styling can be achieved by using the Font property of of the TextRuns which make up the comment, as is already the cases for Xlsx. PR #3957
Added
- Default Style Alignment Property (workaround for bug in non-Excel spreadsheet apps) Issue #3918 PR #3924
- Additional Support for Date/Time Styles PR #3939
Changed
- Nothing
Deprecated
- Reader/Xml trySimpleXMLLoadString should not have had public visibility, and will be removed.
Removed
- Nothing
Fixed
- IF Empty Arguments. Issue #3875 Issue #2146 PR #3879
- Changes to floating point in Php8.4. Issue #3896 PR #3897
- Handling User-supplied Decimal and Thousands Separators. Issue #3900 PR #3903
- Improve Performance of CSV Writer. Issue #3904 PR #3906
- Fix issue with prepending zero in percentage Issue #3920 PR #3921
- Incorrect SUMPRODUCT Calculation Issue #3909 PR #3916
- Formula Misidentifying Text as Cell After Insertion/Deletion Issue #3907 PR #3915
- Unexpected Absolute Address in Xlsx Rels Issue #3730 PR #3923
- Unallocated Cells Affected by Column/Row Insert/Delete Issue #3933 PR #3940
- Invalid Builtin Defined Name in Xls Reader Issue #3935 PR #3942
- Hidden Rows and Columns Tcpdf/Mpdf PR #3945
- RTL Text Alignment in Xlsx Comments Issue #4004 PR #4006
- Protect Sheet But Allow Sort Issue #3951 PR #3956
- Default Value for Conditional::$text PR #3946
- Table Filter Buttons Issue #3988 PR #3992
- Improvements to Xml Reader Issue #3999 Issue #4000 Issue #4001 Issue #4002 PR #4003 PR #4007
- Html Reader non-UTF8 Issue #3995 Issue #866 Issue #1681 PR #4019