You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
This commit was created on GitHub.com and signed with GitHub’s verified signature.
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.
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 #4125Issue #4124PR #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).