Xls file crashes Excel 2007 after updating data for Pivot Table with a PivotChart

Aspose.Cells Product Family
1

HI

I have an existing xls file that has a pivot table with a pivot chart. When I update the source data for the pivot table using Aspose.Cells and then try opening the updated file in Excel , Excel crashes.

I have included sample project that takes the source file and create the output file that crashes.

I have also included both the source and output file I am getting.

Source File is made up for 3 sheets.

1) PivotTable

2) SEMSData - this is the data I am changing.

3) Chart - This is where the chart that is connected to the pivot table is.

Any help or direction would be greatly appreciated

2

Hi,

Thanks for posting the sample code and source files.

I was able to replicate the problem using the latest version:
Aspose.Cells
for .NET v7.0.4.3


We have logged this issue in our database. We will look into it and fix the problem and update you asap.

This issue has been logged as CELLSNET-40241.

3

Hi,

Please download: Aspose.Cells for .NET v7.0.4.4

Please comment the following code in the method of CreatePivotTable():

For Each pTable As Aspose.Cells.Pivot.PivotTable In Pivotsheet.PivotTables
pTable.RefreshDataOnOpeningFile = True
'pTable.RefreshData() //comment this code
pTable.SaveData = False
Next

4

Hi ,
I tried to download the file from the provided link for 7.0.4.4 but I get the message that the zip file is corrupted.
Thanks
Josh

5

Hi,

Will you please try again? I have downloaded it and it is unzipping fine without any error.

6

Hi,
Got it to open had to switch Zip tools. Looks like zip support in windows didn’t like it but 7zip was fine.
Thanks


7

The issues you have found earlier (filed as CELLSNET-40241) have been fixed in this update.

This message was posted using Notification2Forum from Downloads module by aspose.notifier.