1.28.0

1.28.0 - 2023-02-25

Added

• Support for configuring a Chart Title's overlay PR #3325
• Wizards for defining Number Format masks for Numbers, Percentages, Scientific, Currency and Accounting PR #3334
• Support for fixed value divisor in fractional Number Format Masks PR #3339
• Allow More Fonts/Fontnames for Exact Width Calculation PR #3326 Issue #3190
• Allow override of the Value Binder when setting a Cell value PR #3361

Changed

• Improved handling for @ placeholder in Number Format Masks PR #3344
• Improved handling for ? placeholder in Number Format Masks PR #3394
• Improved support for locale settings and currency codes when matching formatted strings to numerics in the Calculation Engine PR #3373 and PR #3374
• Improved support for locale settings and matching in the Advanced Value Binder PR #3376

Deprecated

• Rationalisation of Pre-defined Currency Format Masks

Removed

• Nothing

Fixed

• Calculation Engine doesn't evaluate Defined Name when default cell A1 is quote-prefixed Issue #3335 PR #3336
• XLSX Writer - Array Formulas do not include function prefix Issue #3337 PR #3338
• Permit Max Column for Row Breaks Issue #3143 PR #3345
• AutoSize Columns should allow for dropdown icon when AutoFilter is for a Table Issue #3356 PR #3358 and for Center Alignment of Headers Issue #3395 PR #3399
• Decimal Precision for Scientific Number Format Mask Issue #3381 PR #3382
• Xls Writer Parser Handle Boolean Literals as Function Arguments Issue #3369 PR #3391
• Conditional Formatting Improvements for Xlsx Issue #3370 Issue #3202 PR #3372
• Coerce Bool to Int for Mathematical Operations on Arrays Issue #3389 Issue #3396 PR #3392