Free Support Forum - aspose.com

Opening and saving file containing pivot table result in corrupt content according to Excel

Hi,

When opening and saving to another the attached Excel file containing pivot table, the new file is reported as corrupted when opened in MS Excel. No exception is thrown like the previous bug reported here:

http://www.aspose.com/community/forums/permalink/601543/601543/showthread.aspx#601543

so I assume this bug is a different one.
For reproducing the issue please use the following code the open the new file in MS Excel:

var workbook = new Workbook(“test2.xls”);
workbook.Save(“output.xls”, SaveFormat.Excel97To2003);


Best regards,
Aurelian Iordache
Software Developer
IBM Romania

Hi Aurelian,


Thank you for contacting Aspose support.

We have evaluated your presented scenario while using the latest version of Aspose.Cells for .NET 8.3.2, and we are able to observe the said problem. After re-saving your provided spreadsheet with Aspose.Cells, the MS Excel application cannot load the resultant spreadsheet without repair. We have logged this incident in our bug tracking system under the ticket CELLSNET-43340 for further investigation. Please spare us little time to isolate the problem cause, and to provide the fix. In the meanwhile, we will keep you posted with updates in this regard.

Hi Babar,

Do you have an update on this issue? Thank you!

Raluca

Hi Raluca,


I am afraid, the ticket logged earlier as CELLSNET-43340 is still open. We have requested the concerned product team member to share the insight of this issue, and most preferably an estimated time for the fix. We will shortly get back to you with updates in this regard.

Hi Raluca,


This is to inform you that we will be able to provide the fix for the issue logged earlier as CELLSNET-43340 during the month of May 2015. We are sorry for the inconvenience.

Hi,


Please try the latest version/fix: Aspose.Cells for .NET v8.4.0.8

We have fixed your issue now.

Let us know your feedback.

Thank you.

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


This message was posted using Notification2Forum from Downloads module by Aspose Notifier.

Hello,

Sadly, we are still having issues with this file, only it does not report it as corrupt by just saving it with Aspose. However, refreshing data (pivotTable.RefreshData() ) causes it to become corrupt again.

It seems to be the same issue as the one reported here.

The excel error: Global PivotTable report information was repaired due to integrity problems.

Here is the code needed to reproduce this issue and I have also attached the file again:

var excelDocument = new Workbook(“testFile.xls”);

foreach (var pivotTable in from worksheet in excelDocument.Worksheets
from pivotTable in worksheet.PivotTables
where pivotTable.RefreshDataOnOpeningFile
select pivotTable)
{
pivotTable.RefreshData();
}

excelDocument.Save(“testFile.xls”, SaveFormat.Excel97To2003);


InternalID: 14274

Best regards,
Stanescu Jean-Alexandru
Junior Developer
IBM Romania

Hi,


I have tested your scenario/ case using your sample code and template file, it does produce the corrupted file as you mentioned. As we already logged a ticket with an id “CELLSNET-43786” for it in your other thread (we reopened the original issue already), so kindly follow up your other thread for resolution (We will also include the fix for this scenario/ case using your template file as well).
http://www.aspose.com/community/forums/thread/650363/pivottable.refreshdata-corrupting-content.aspx

Thank you.