News & Releases
|
|

Spire.XLS 10.3.8 supports calculating SUBTOTAL formula
We're pleased to announce the release of Spire.XLS 10.3.8. This version supports calculating SUBTOTAL formula and setting chart marker's border weight. Besides, it also fixes some issues that occurred when converting excel to pdf, setting page order type and creating meter chart. See the content below for more details.
Here is a list of changes made in this release
| Category | ID | Description |
| New Feature | SPIREXLS-1998 | Supports setting chart marker's border weight.
chart.Series[0].DataFormat.MarkerBorderWeight = 2.5; //the unit is pt |
| New Feature | SPIREXLS-2163 | Supports calculating SUBTOTAL formula. |
| Bug | SPIREXLS-2008 | Fixes the issue that it failed to open output excel after setting time data validity. |
| Bug | SPIREXLS-2015 | Fixes the issue that the value of the chart pointer was lost when creating a meter chart. |
| Bug | SPIREXLS-2020 | Fixes the issue that it failed to set conditional format of the date. |
| Bug | SPIREXLS-2023 | Fixes the issue that it failed to remove hyperlinks of text. |
| Bug | SPIREXLS-2026 | Fixes the issue that it failed to set page order type. |
| Bug | SPIREXLS-2029 | Fixes the issue that it failed to unlock the protected worksheet. |
| Bug | SPIREXLS-2031 | Fixes the issue that it failed to hide/show sheet tab. |
| Bug | SPIREXLS-2032 | Fixes the issue that the incorrect version of the excel document was detected. |
| Bug | SPIREXLS-2076 | Fixes the issue that the coordinate axis value was incorrect when converting PivotChart to images. |
| Bug | SPIREXLS-2121 | Fixes the issue that the alignment of text was incorrect when converting excel to pdf. |
| Bug | SPIREXLS-2162 | Fixes the issue that the data source of chart was incorrect after using CopyFrom() method to copy sheet including a chart. |
| Bug | SPIREXLS-2175 | Fixes the issue that formula value was incorrect after calculating formula. |
| Bug | SPIREXLS-2027 | Fixes the issue that it failed to set the order of PivotTable fields. |
Click the link to download Spire.XLS 10.3.8:
More information of Spire.XLS new release or hotfix: