Releases: PHPOffice/PhpSpreadsheet
Releases · PHPOffice/PhpSpreadsheet
5.1.0
Added
- Add Conditional Formatting with IconSet (Xlsx only). Issue #4560 PR #4574
- Copy cell adjusting formula. Issue #1203 PR #4577
- splitRange and ProtectedRange. Issue #1457 PR #4580
- Option to create Blank Sheet if LoadSheetsOnly doesn't find any. PR #4618
Fixed
- Google-only formulas exported from Google Sheets. Issue #1637 PR #4579
- Maximum column width. PR #4581
- PrintArea after row/column delete. Issue #2912 PR #4598
- Remove deprecated imagedestroy call. PR #4625
- Excel 2007 problem with newlines. Issue #4619 PR #4620
- Compatibility changes for Php 8.5. PR #4601 PR #4611
3.10.1
2.4.1
5.0.0
Breaking Changes
- Images will be loaded from an external source (e.g. http://example.com/img.png) only if the reader is explicitly set to allow it via
$reader->setAllowExternalImages(true). We do not believe that loading of external images is a widely used feature. - Deletion of items deprecated in Release 4. See "removed" below.
- Move some properties from Base Reader to Html Reader. PR #4551
- DefaultValueBinder will treat integers with more than 15 digits as strings. Issue #4522 PR #4527
Removed
- Theme public constants COLOR_SCHEME_2013_PLUS_NAME (use COLOR_SCHEME_2013_2022_NAME) and COLOR_SCHEME_2013_PLUS (use COLOR_SCHEME_2013_2022).
Fixed
- Additional floating-point precision changes. Issue #1324 PR #4575
- Header/Footer images expand location. Issue #484 Issue #1318 PR #4572
- Create uninitialized cell if used in calculation. Issue #4558 Issue #4530 PR #4565
- Shared/Date::isDateTime handle cells which calculate as arrays. Issue #4557 PR #4562
- Xlsx Writer eliminate xml:space from non-text nodes. Issue #4542 PR #4556
3.10.0
Breaking Changes
- Images will be loaded from an external source (e.g. http://example.com/img.png) only if the reader is explicitly set to allow it via
$reader->setAllowExternalImages(true). We do not believe that loading of external images is a widely used feature. This is a necessary change for security purposes. It unfortunately breaks Semantic Versioning for reasons described above; there is no way to start a new major version for this branch.
2.4.0
Breaking Changes
- Images will be loaded from an external source (e.g. http://example.com/img.png) only if the reader is explicitly set to allow it via
$reader->setAllowExternalImages(true). We do not believe that loading of external images is a widely used feature. This is a necessary change for security purposes. It unfortunately breaks Semantic Versioning for reasons described above; there is no way to start a new major version for this branch.
2.1.12
Breaking Changes
- Images will be loaded from an external source (e.g. http://example.com/img.png) only if the reader is explicitly set to allow it via
$reader->setAllowExternalImages(true). We do not believe that loading of external images is a widely used feature. This is a necessary change for security purposes. It unfortunately breaks Semantic Versioning for reasons described above; there is no way to start a new major version for this branch.
1.30.0
Breaking Changes
- Images will be loaded from an external source (e.g. http://example.com/img.png) only if the reader is explicitly set to allow it via
$reader->setAllowExternalImages(true). We do not believe that loading of external images is a widely used feature. This is a necessary change for security purposes. It unfortunately breaks Semantic Versioning for reasons described above; there is no way to start a new major version for this branch.
4.5.0
Added
- Add to all readers the option to allow or forbid fetching external images. This is unconditionally allowed now. The default will be set to "allow", so no code changes are necessary. However, we are giving consideration to changing the default. PR #4543
- Address Excel Inappropriate Number Format Substitution. PR #4532
Fixed
- Html Writer Conditional Formatting Inline Css. Issue #4539 PR #4541
- Do not use htmlspecialchars when formatting XML. Issue #4537 PR #4540
- Writer Html/Pdf support RTL alignment of tables. Issue #1104 PR #4535
- Xlsx Reader use dynamic arrays if spreadsheet did so. PR #4533
- Ods Reader Nested table-row. Issue #4528 Issue #2507 PR #4531
- Recognize application/x-empty mimetype. Issue #4521 PR #4524
- Micro-optimization in getSheetByName. PR #4499
- Bug in resizeMatricesExtend. Issue #4451 PR #4474
- Allow Replace of Dummy Function with Custom Function. PR #4544
- Preserve 0x0a in Strings if Desired. Issue #347 PR #4536