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 #3810
• Prevent loop in Shared/File. Issue #3807 PR #3809
• Consistent handling of decimal/thousands separators between StringHelper and Php setlocale. Issue #3811 PR #3815
• Clone worksheet with tables or charts. Issue #3820 PR #3821
• COUNTIFS Does Not Require xlfn. Issue #3819 PR #3827
• Strip xlfn. and xlws. from Formula Translations. Issue #3819 PR #3828
• Recurse directories searching for font file. Issue #2809 PR #3830
• Reduce memory consumption of Worksheet::rangeToArray() when many empty rows are read. Issue #3814 PR #3834
• Reduce time used by Worksheet::rangeToArray() when many empty rows are read. PR #3839
• Html Reader Tolerate Invalid Sheet Title. PR #3845
• Do not include unparsed drawings when new drawing added. Issue #3843 PR #3846
• Do not include unparsed drawings when new drawing added. Issue #3861 PR #3862
• Excel omits between operator for data validation. Issue #3863 PR #3865
• Use less space when inserting rows and columns. Issue #3687 PR #3856
• Excel inconsistent handling of MIN/MAX/MINA/MAXA. Issue #3866 PR #3868