Hello,
I’m working with Aspose Cells .NET v8.4.1.0.
I’m trying to combine two workbooks that contains some pivot charts with a template applied to them. When combining the workbooks, the styles of the charts are reseted to “Style2” on Excel.
I’ve applied the template chart on the original chart, but it is not applied on the output file.
This issue also happens when refreshing the associated pivot table.
Example 1:
Workbook wb_a = new Workbook(“C:\wbA.xlsx”);
Workbook wb_b = new Workbook(“C:\wbB.xlsx”);
wb_a.Combine(wb_b);
Example 2:
Workbook wb_a = new Workbook(“C:\wbA.xlsx”);
wb_a.Worksheets[“Sheet1”].Cells.ImportDataTable(data_to_populate, false, 1, 1, new_data_rows, new_data_cols, false, “mm/dd/yy hh:mm AM/PM”);
wb_a.Worksheets[“Sheet1”].PivotTables[0].RefreshData();
As you can see in the example_1.xlsx and example_2.xlsx files, neither the charts keep their styles, nor the pivot table keeps the “banded rows” option in SheetA.
I’ve attached an example.
Do tou know how can I solve this issue?
Thanks in advance!