Spire.XLS 8.6.6 adds new properties and methods to handle pivot tables

We're pleased to announce that Spire.XLS 8.6.6 is released today. This version adds a new property “XlsPivotTable.Options.IsAutoFormat” to set whether the auto format is applied to a pivot table, adds new methods to delete filter in pivot tables, and fixes some issues relating to formula, chart and other stuff. View more details below.

New features:

• Add a new property "XlsPivotTable.Options.IsAutoFormat" for setting whether the autoformat is applied for pivot table or not. Default value is true.

bool IsAutoFormat { get; set; }

• Add following three new methods to delete filters in pivot table.

public void ClearColumnFieldFilter(string fieldName);
public void ClearFilter(string fieldName);
public void ClearRowFieldFilter(string fieldName);

• Add a new property "IChart.ChartArea.Shadow.SoftEdge" to support the setting for chart soft edge.

public int SoftEdge { get; set; }

Bug Fixes:

• Fixes the issue that the content of R1C1-Formula would change when inserting a row.
• Fixes the issue that the "CellRange.FormulaValue" returned the wrong value.
• Fixes the issue that the "ValueFromCell" setting would result in an invalid color effect for the negative column.
• Fixes the issue that the original images in Excel1 had all been replaced when copying one of the sheets in Excel2 to Excel1.
• Fixes the issue that some structural references were not supported.
• Fixes the issue that the property "IsAutoMajor" must be set to false when setting the label unit.
• Fixes the issue that the "pageInfoList[0].Count" returned wrong value for the page count.
• Fixes the issue that the application thraw an "ArgumentOutOfRangeException" when loading an EXCEL document.