Hello,
When we refresh pivot tables on worksheets, the pivotChart seems to lose “Filter Connections” settings.
It also happens when you simply save some complex files.
Sometimes the filters are unchecked and sometimes there are just no effect until we uncheck and recheck them.
Before uncheck and recheck (27.5 KB)
After uncheck and recheck (14.9 KB)
A manual refresh on Excel seems to fix this problem but not in Aspose.
We have tried to refresh plivot table and refresh charts pivot tables but no effects.
It also seems to have a problem with slicers settings. The setting “Hide items with no data” is lose until recheck them or refresh data on Excel or until we uncheck and recheck the filters parameters of the chart.
Before uncheck and recheck (14.3 KB)
After uncheck and recheck (14.0 KB)
All was working on Aspose.Cells is 18.12 but is broken on 19.5 and 19.7
You will find below the minal code to reproduce the problem.
In attachment 1: The starting file.
In attachment 2: The result.
Attachments.zip (166.8 KB)
var wb = new Workbook(new MemoryStream(File.ReadAllBytes("inputPath")));
foreach (var worksheet in wb.Worksheets)
{
try
{
worksheet.RefreshPivotTables();
}
catch (System.Exception e)
{
}
}
wb.FileName = downloadFileName;
wb.Settings.Region = CountryCode.France;
var fs = new MemoryStream();
wb.Save(fs, SaveFormat.Xlsm);
var outPath = Path.Combine(outDirectory, downloadFileName);
using (var fileStream = File.Create("outPath"))
{
fs.Seek(0, SeekOrigin.Begin);
fs.CopyTo(fileStream);
}