Added
- Add ability to add custom functions to Calculation. PR #4390
- Add FormulaRange to IgnoredErrors. PR #4393
- TextGrid improvements. PR #4418
- Permit read to class which extends Spreadsheet. Discussion #4402 PR #4404
- Conditional and table formatting support for html writer PR #4412
Changed
- Phpstan Version 2. PR #4384
- Start migration to Phpstan level 9. PR #4396
- Calculation locale logic moved to separate class. PR #4398
- TREND_POLYNOMIAL_* and TREND_BEST_FIT do not work, and are changed to throw Exceptions if attempted. (TREND_BEST_FIT_NO_POLY works.) An attempt to use an unknown trend type will now also throw an exception. Issue #4400 PR #4339
- Month parameter of DATE function will now return VALUE if an ordinal string (e.g. '3rd') is used, but will accept bool or null. PR #4420
Fixed
- Ignore fractional part of Drawing Shadow Alpha. Issue #4415 PR #4417
- BIN2DEC, OCT2DEC, and HEX2DEC return numbers rather than strings. Issue #4383 PR #4389
- Fix TREND_BEST_FIT_NO_POLY. Issue #4400 PR #4339
- Ods Reader No DataType for Null Value. Issue #4435 PR #4436
- Column widths not preserved when using read filter. Issue #4416 PR #4423
- Fix typo in Style exportArray quotePrefix. Issue #4422 PR #4424
- Tweak Spreadsheet clone. PR #4419
- Better handling of Chart DisplayBlanksAs. Issue #4411 PR #4414