We're pleased to announce the release of Spire.XLS 15.1.3. This version adds the support for many functions, CSCH, RANDARRAY, COTH, SEQUENCE, EXPAND, CHOOSECOLS, CHOOSEROWS, and DROP. Besides, it also fixes some issues that occurred when converting XLSM to PDF, Excel to PDF, calculating formula values and setting tab color. More details are shown below.
Here is a list of changes made in this release
| Category | ID | Description |
| New feature | SPIREXLS-5542 | Supports the CSCH function |
| New feature | SPIREXLS-5548 | Supports the RANDARRAY function. |
| New feature | SPIREXLS-5621 | Supports the COTH function. |
| New feature | SPIREXLS-5622 | Supports the SEQUENCE function. |
| New feature | SPIREXLS-5627 | Supports the EXPAND function. |
| New feature | SPIREXLS-5638 | Supports the CHOOSECOLS function. |
| New feature | SPIREXLS-5639 | Supports the CHOOSEROWS function. |
| New feature | SPIREXLS-5642 | Supports the DROP function. |
| New feature | SPIREXLS-5656 | Support setting HyLink for XlsPrstGeomShape.
PrstGeomShapeCollection prstGeomShapeType = worksheet.PrstGeomShapes;
for (int i = 0; i < prstGeomShapeType.Count; i++)
{
XlsPrstGeomShape shape = (XlsPrstGeomShape)prstGeomShapeType[i];
shape.HyLink.Address = "https://www.baidu.com/";
}
|
| Bug | SPIREXLS-5570 | Fixes the issue that the charts were lost when converting XLSM to PDF. |
| Bug | SPIREXLS-5608 | Fixes the issue that the content was lost when converting Excel to PDF. |
| Bug | SPIREXLS-5611 | Fixes the issue that setting ShowLeaderLines did not take effect. |
| Bug | SPIREXLS-5612 | Fixes the issue that the data bar colors were incorrect when converting Excel to PDF. |
| Bug | SPIREXLS-5625 SPIREXLS-5647 |
Fixes the issue that the values were incorrect after calling the CalculateAllValue() method to calculate formula values. |
| Bug | SPIREXLS-5635 | Fixes the issue that setting the worksheet tab color to Color.Empty resulted in black. |
| Bug | SPIREXLS-5640 | Fixes the issue that the images were extracted incorrectly. |
| Bug | SPIREXLS-5657 | Fixes the issue that it failed to delete pivot fields in pivot tables. |
| Bug | SPIREXLS-5659 | Fixes the issue that the text orientation in shapes was reversed when converting Excel to PDF. |
Click the link to download Spire.XLS 15.1.3:
More information of Spire.XLS new release or hotfix:
