PhpSpreadsheet v1.21.0 Release Notes
Release Date: 2022-01-06 // over 2 years ago-
โ Added
- ๐ Ability to add a picture to the background of the comment. Supports four image formats: png, jpeg, gif, bmp. New
Comment::setSizeAsBackgroundImage()
to change the size of a comment to the size of a background image. Issue #1547 PR #2422 - 0๏ธโฃ Ability to set default paper size and orientation PR #2410
- Ability to extend AutoFilter to Maximum Row PR #2414
๐ Changed
- Xlsx Writer will evaluate AutoFilter only if it is as yet unevaluated, or has changed since it was last evaluated PR #2414
๐ Deprecated
- Nothing
โ Removed
- Nothing
๐ Fixed
- Rounding in
NumberFormatter
Issue #2385 PR #2399 - ๐ Support for themes Issue #2075 Issue #2387 PR #2403
- Read spreadsheet with
#
in name Issue #2405 PR #2409 - ๐ Improve PDF support for page size and orientation Issue #1691 PR #2410
- Wildcard handling issues in text match Issue #2430 PR #2431
- Respect DataType in
insertNewBefore
PR #2433 - ๐ Handle rows explicitly hidden after AutoFilter Issue #1641 PR #2414
- Special characters in image file name Issue #1470 Issue #2415 PR #2416
- ๐ Mpdf with very many styles Issue #2432 PR #2434
- ๐ Name clashes between parsed and unparsed drawings Issue #1767 Issue #2396 PR #2423
- Fill pattern start and end colors Issue #2441 PR #2444
- ๐ General style specified in wrong case Issue #2450 PR #2451
- Null passed to
AutoFilter::setRange()
Issue #2281 PR #2454 - Another undefined index in Xls reader (#2470) Issue #2463 PR #2470
- ๐ Allow single-cell checks on conditional styles, even when the style is configured for a range of cells (#) PR #2483
- ๐ Ability to add a picture to the background of the comment. Supports four image formats: png, jpeg, gif, bmp. New