2.0.0

BREAKING CHANGE

• Typing was strengthened by leveraging native typing. This should not change any behavior. However, if you implement
  any interfaces or inherit from any classes, you will need to adapt your typing accordingly. If you use static analysis
  tools such as PHPStan or Psalm, new errors might be found. If you find actual bugs because of the new typing, please
  open a PR that fixes it with a detailed explanation of the reason. We'll try to merge and release typing-related
  fixes quickly in the coming days. PR #3718
• All deprecated things have been removed, for details, see 816b91d0b4

Added

• Split screens (Xlsx and Xml only, not 100% complete). Issue #3601 PR #3622
• Permit Meta Viewport in Html. Issue #3565 PR #3623
• Hyperlink support for Ods. Issue #3660 PR #3669
• ListWorksheetInfo/Names for Html/Csv/Slk. Issue #3706 PR #3709
• Methods to determine if cell is actually locked, or hidden on formula bar. PR #3722
• Add iterateOnlyExistingCells to Constructors. Issue #3721 PR #3727
• Support for Conditional Formatting Color Scale. PR #3738
• Support Additional Tags in Helper/Html. Issue #3751 PR #3752
• Writer ODS : Write Border Style for cells Issue #3690 PR #3693
• Sheet Background Images Issue #1649 PR #3795
• Check if Coordinate is Inside Range PR #3779
• Flipping Images Issue #731 PR #3801
• Chart Dynamic Title and Font Properties Issue #3797 PR #3800
• Chart Axis Display Units and Logarithmic Scale. Issue #3833 PR #3836
• Partial Support of Fill Handles. Discussion #3847 PR #3855

Changed

• Drop support for PHP 7.4, according to https://phpspreadsheet.readthedocs.io/en/latest/#php-version-support PR #3713
• RLM Added to NumberFormatter Currency. This happens depending on release of ICU which Php is using (it does not yet happen with any official release). PhpSpreadsheet will continue to use the value returned by Php, but a method is added to keep the result unchanged from release to release. Issue #3571 PR #3640
• toFormattedString will now always return a string. This was introduced with 1.28.0, but was not properly documented at the time. This can affect the results of toArray, namedRangeToArray, and rangeToArray. PR #3304
• Value of constants FORMAT_CURRENCY_EUR and FORMAT_CURRENCY_USD was changed in 1.28.0, but was not properly documented at the time. Issue #3577
• Html Writer will attempt to use Chart coordinates to determine image size. Issue #3783 PR #3787

Deprecated

• Functions _translateFormulaToLocale and _translateFormulaEnglish are replaced by versions without leading underscore. PR #3828

Removed

• Nothing

Fixed

• Take advantage of mitoteam/jpgraph Extended mode to enable rendering of more graphs. PR #3603
• Column widths, especially for ODS. Issue #3609 PR #3610
• Avoid NULL in String Function call (partial solution). Issue #3613 PR #3617
• Preserve transparency in Memory Drawing. Issue #3624 PR #3627
• Customizable padding for Exact Column Width. Issue #3626 PR #3628
• Ensure ROW function returns int (problem exposed in unreleased Php). PR #3641
• Minor changes to Mpdf and Html Writers. PR #3645
• Xlsx Reader Namespacing for Tables, Autofilters. Issue #3665 PR #3668
• Read Code Page for Xls ListWorksheetInfo/Names BIFF5. Issue #3671 PR #3672
• Read Data from Table on Different Sheet. Issue #3635 PR #3659
• Html Writer Styles Using Inline Css. Issue #3678 PR #3680
• Xlsx Read Ignoring Some Comments. Issue #3654 PR #3655
• Fractional Seconds in Date/Time Values. PR #3677
• SetCalculatedValue Avoid Casting String to Numeric. Issue #3658 PR #3685
• Several Problems in a Very Complicated Spreadsheet. Issue #3679 PR #3681
• Inconsistent String Handling for Sum Functions. Issue #3652 PR #3653
• Recomputation of Relative Addresses in Defined Names. Issue #3661 PR #3673
• Writer Xls Characters Outside BMP (emojis). Issue #642 PR #3696
• Xlsx Reader Improve Handling of Row and Column Styles. Issue #3533 Issue #3534 PR #3688
• Avoid Allocating RowDimension Unneccesarily. PR #3686
• Use Column Style when Row Dimension Exists Without Style. Issue #3534 PR #3688
• Inconsistency Between Cell Data and Explicitly Declared Type. Issue #3711 PR #3715
• Unexpected Namespacing in rels File. Issue #3720 PR #3722
• Break Some Circular References. PR #3716 PR #3707
• Missing Font Index in Some Xls. PR #3734
• Load Tables even with READ_DATA_ONLY. PR #3726
• Theme File Missing but Referenced in Spreadsheet. Issue #3770 PR #3772
• Slk Shared Formulas. Issue #2267 PR #3776
• Html omitting some charts. Issue #3767 PR #3771
• Case Insensitive Comparison for Sheet Names PR #3791
• Performance improvement for Xlsx Reader. Issue #3683 [PR PHPOffice#3810](https...

1.29.0

• Wizards for defining Number Format masks for Dates and Times, including Durations/Intervals. PR #3458

• Specify data type in html tags. Issue #3444 PR #3445

• Provide option to ignore hidden rows/columns in toArray() methods. PR #3494

• Font/Effects/Theme support for Chart Data Labels and Axis. PR #3476

• Font Themes support. PR #3486

• Ability to Ignore Cell Errors in Excel. Issue #1141 PR #3508

• Unzipped Gnumeric file PR #3591

• Xlsx Color schemes read in will be written out (previously Excel 2007-2010 Color scheme was always written); manipulation of those schemes before write, including restoring prior behavior, is provided PR #3476

• Memory and speed optimisations for Read Filters with Xlsx Files and Shared Formulae. PR #3474

• Allow CellRange and CellAddress objects for the range argument in the rangeToArray() method. PR #3494

• Stock charts will now read and reproduce upDownBars and subsidiary tags; these were previously ignored on read and hard-coded on write. PR #3515

• Nothing

• Nothing

• Updates Cell formula absolute ranges/references, and Defined Name absolute ranges/references when inserting/deleting rows/columns. Issue #3368 PR #3402

• EOMONTH() and EDATE() Functions should round date value before evaluation. Issue #3436 PR #3437

• NETWORKDAYS function erroneously being converted to NETWORK_xlfn.DAYS in Xlsx Writer. Issue #3461 PR #3463

• Getting a style for a CellAddress instance fails if the worksheet is set in the CellAddress instance. Issue #3439 PR #3469

• Shared Formulae outside the filter range when reading with a filter are not always being identified. Issue #3473 PR #3474

• Xls Reader Conditional Styles. PR #3400

• Allow use of # and 0 digit placeholders in fraction masks. PR #3401

• Modify Date/Time check in the NumberFormatter for decimal/fractional times. PR #3413

• Misplaced Xml Writing Chart Label FillColor. Issue #3397 PR #3404

• TEXT function ignores Time in DateTimeStamp. Issue #3409 PR #3411

• Xlsx Column Autosize Approximate for CJK. Issue #3405 PR #3416

• Correct Xlsx Parsing of quotePrefix="0". Issue #3435 PR #3438

• More Display Options for Chart Axis and Legend. Issue #3414 PR #3434

• Apply strict type checking to Complex suffix. PR #3452

• Incorrect Font Color Read Xlsx Rich Text Indexed Color Custom Palette. Issue #3464 PR #3465

• Xlsx Writer Honor Alignment in Default Font. Issue #3443 PR #3459

• Support Border for Charts. PR #3462

• Error in "this row" structured reference calculation (cached result from first row when using a range) Issue #3504 PR #3505

• Allow colour palette index references in Number Format masks Issue #3511 PR #3512

• Xlsx Reader formula with quotePrefix Issue #3495 PR #3497

• Handle REF error as part of range Issue #3453 PR #3467

• Handle Absolute Pathnames in Rels File Issue #3553 PR #3554

• Return Page Breaks in Order Issue #3552 PR #3555

• Add position attribute for MemoryDrawing in Html [Issue PHPOffice#3529](PHPOffice#3529 PR #3535

• Allow Index_number as Array for VLOOKUP/HLOOKUP [Issue PHPOffice#3561](PHPOffice#3561 PR #3570

• Add Unsupported Options in Xml Spreadsheet [Issue PHPOffice#3566](PHPOffice#3566 [Issue PHPOffice#3568](PHPOffice#3568 [Issue PHPOffice#3569](PHPOffice#3569 PR #3567

• Changes to NUMBERVALUE, VALUE, DATEVALUE, TIMEVALUE [Issue PHPOffice#3574](PHPOffice#3574 PR #3575

• Redo calculation of color tinting Issue #3550 PR #3580

• Accommodate Slash with preg_quote PR #3582 PR #3583 PR #3584

• HyperlinkBase Property and Html Handling of Properties Issue #3573 PR #3589

• Improvements for Data Validation Issue #3592 Issue #3594 PR #3605

1.16.0

• CSV Reader - Best Guess for Encoding, and Handle Null-string Escape #1647

• Updated the CONVERT() function to support all current MS Excel categories and Units of Measure.

• Nothing.

• Nothing.

• Fix for Xls Reader when SST has a bad length #1592

• Resolve Xlsx loader issue whe hyperlinks don't have a destination

• Resolve issues when printer settings resources IDs clash with drawing IDs

• Resolve issue with SLK long filenames #1612

• ROUNDUP and ROUNDDOWN return incorrect results for values of 0 #1627

• Apply Column and Row Styles to Existing Cells #1712 PR #1721

• Resolve issues with defined names where worksheet doesn't exist (PHPOffice#1686)[https://github.com/PHPOffice/issues/1686] and #1723 - PR #1742

• Fix for issue #1735 Incorrect activeSheetIndex after RemoveSheetByIndex - PR #1743

• Ensure that the list of shared formulae is maintained when an xlsx file is chunked with readFilterIssue #169.

• Fix for notice during accessing "cached magnification factor" offset #1354

• Fix compatibility with ext-gd on php 8

• Prevent XSS through cell comments in the HTML Writer.