We're pleased to announce the release of Spire.XLS 16.8.2. This version adds support for the TEXTSPLIT formula and fixes several known issues related to OFD stream saving, mixed-type data export, and formula calculation. More details are listed below.
Here is a list of changes made in this release
| Category | ID | Description |
| New Feature | SPIREXLS-6201 | Added support for the TEXTSPLIT formula.
sheet.getCellRange("A8").setFormula("=TEXTSPLIT(\"A,B,C\", \",\")");
|
| Bug Fix | SPIREXLS-6193 | Fixed an issue where the file content was corrupted when saving to an OFD stream. |
| Bug Fix | SPIREXLS-6194 | Fixed an issue where data was lost due to incorrect type inference when exporting mixed-type columns with KeepDataType enabled. |
| Bug Fix | SPIREXLS-6198 | Fixed an issue where formula calculation with CalculateAllValue returned "N/A" errors. |
Click the link below to download Spire.XLS 16.8.2:
More information of Spire.XLS new release or hotfix:
