Filter Connections on pivotChart lose settings on save and refresh pivot tables


#1

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);
        }

#2

@gle,

Thanks for the template file, sample code and screenshots.

After an initial test, I am able to reproduce the issue (as per your screenshots) as you mentioned by using your sample code with your template file. I found that filter connections on pivot chart lose some settings on save after refreshing pivot tables. I have logged a ticket with an id “CELLSNET-46857” for your issue. We will look into it soon.

Once we have an update on it, we will let you know.


#3

@gle,

This is to inform you that we have fixed your issue now. We will soon provide you the fixed version after performing QA and incorporating other enhancements and fixes. We will soon share the Download link to the fixed version.


#4

@gle,

Please try our latest version/fix: Aspose.Cells for .NET v19.8.1 (attached)

Your issue should be fixed in it.

Let us know your feedback.
Aspose.Cells19.8.1 For .Net2_AuthenticodeSigned.Zip (4.9 MB)
Aspose.Cells19.8.1 For .Net4.0.Zip (4.9 MB)


#5

The issues you have found earlier (filed as CELLSNET-46857) have been fixed in Aspose.Cells for .NET v19.9. This message was posted using BugNotificationTool from Downloads module by Amjad_Sahi