PivotTable.RefreshData throw errors

Aspose.Cells Product Family
1

Hi,

Please find the the files attached.

Excels.zip (3.6 MB)

When I call PivotTable.RefreshData method I got the following exceptions

For “Summary Of Activity” and “Operations Analysis”:

   Item has already been added. Key in dictionary: '89' Key being added: '89'

For “Capital Summary”:

   this data source is not supported.

Here is the part of the code that generate error:

Workbook excelFile = new Workbook(“the file”);
foreach (Worksheet sheet in excelFile.Worksheets)
{
foreach (PivotTable pivotTable in sheet.PivotTables)
{
pivotTable.RefreshData();//exception
pivotTable.CalculateData();
}

            foreach (Chart chart in sheet.Charts) 
            { 
                chart.RefreshPivotData(); 
                chart.Calculate(); 
            } 
        }

feel free to let me know if you need more info.

Thanks for the help.

Shuxiao Miao

2

@SNP_Lightman,

Thanks for your query.

We were able to observe the issues but we need to look into it more. We have logged the issues in our database for investigation and for a fix. Once, we will have some news for you, we will update you in this topic.

This issues have been logged as

CELLSNET-46398 - Exception "this data source is not supported" while calling the PivotTable.RefreshData
CELLSNET-46399 - Exception "Item has already been added. Key in dictionary: '5' Key being added: '5'" while calling PivotTable.RefreshData()
CELLSNET-46400 - It hangs while calling PivotTable.RefreshData (Your actual issue is also mentioned similar to CELLSNET-46399
3

@SNP_Lightman,

This is to inform you that we have fixed your issues (“CELLSNET-46399”, “CELLSNET-46400”) now. We will soon provide you the fixed version after performing QA and incorporating other enhancements and fixes.

4

@SNP_Lightman,

Regarding issue “CELLSNET-46398”:
I am afraid, we can’t support to render/refresh the PivotTable with external data source for now.

5

@SNP_Lightman,

Please try our latest version/fix: Aspose.Cells for .NET v18.10.2:

Aspose.Cells18.10.2 For .Net4.0.Zip (4.7 MB)
Aspose.Cells18.10.2 For .Net2_AuthenticodeSigned.Zip (4.7 MB)

Your issues should be fixed in it.

Let us know your feedback.

6

Thanks for fixing the issues! It’s working as expected.

Just wondering when is your next official release?

7

@SNP_Lightman,

Thank you for the feedback. Our next release is expected around the last week of November 2018. Feel free to contact us any time if you need further help or have some other issue or queries, we will be happy to assist you soon.

8

The issues you have found earlier (filed as CELLSNET-46399,CELLSNET-46400) have been fixed in Aspose.Cells for .NET v18.11. This message was posted using BugNotificationTool from Downloads module by Amjad_Sahi