Spire.XLS 10.3.8

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: