Dynamic Arrays
- Support for Excel dynamic arrays is added. It is an opt-in feature, so our hope is that there will be no BC breaks, but it is a very large change. Full support is added for Xlsx. It is emulated as Ctrl-Shift-Enter arrays for Ods read and write and Excel2003 and Gnumeric read. Html/Pdf and Csv writers will populate cells on output if they are the result of array formulas. No support is added for Xls or Slk.
Added
- Excel Dynamic Arrays. Issue #3901 Issue #3659 Issue #1834 PR #3962
- String Value Binder Allow Setting "Ignore Number Stored as Text". PR #4141
Changed
- Xlsx Reader default datatype when none is specified in Xml is changed from string to numeric, which is how Excel treats it. There is expected to be little impact because DefaultValueBinder and AdvancedValueBinder correct mis-identification as string, and StringValueBinder usually expects string. PR #4139
- Currency and Accounting Wizards are changed to act like Excel, and a new CurrencyBase Wizard is added for for non-Excel formats. Issue #4125 Issue #4124 PR #4127
- Images will not be added to spreadsheet if they cannot be validated as images.
Deprecated
- Nothing yet.
Removed
- The following items were deprecated in release 2 and are now removed.
- Writer\Xls\Style\ColorMap (no longer needed).
- Reader\Xml::trySimpleXMLLoadString (should not have been public, no public replacement).
- Calculation\Calculation::_translateFormulaToLocale (use method name translateFormulaToLocale without leading underscore).
- Calculation\Calculation::_translateFormulaToEnglish (use method name translateFormulaToEnglish without leading underscore).
Moved
- Nothing yet.
Fixed
- Several security patches.
- Xls Reader Some Ranges Not Handled Properly. Issue #1570 PR #4140
- Better Handling of legacyDrawing Xml. Issue #4105 PR #4122
- Improve Xlsx Reader Speed. Issue #3917 PR #4153