1.21.0

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
• 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