Pivot tables in XLS files cause corruption

Aspose.Cells Product Family
1

If the attached file is opened by Aspose and then re-written, the resulting file causes errors when opened in Excel.

If the resulting file is an xls file, then the error message is:

PivotTable report 'PivotTablke1' on '[TestFile.xls]Pivot Table' was discarded due to integrity problems.

If the resulting file is an xlsx file, then the error message is:

Removed Feature: View from /xl/worksheets/sheet1.xml part
Removed Feature: View from /xl/worksheets/sheet2.xml part
Repaired Records: PivotTable report from /xl/pivotTables/pivotTable1.xml part (PivotTable view)

There is a single worksheet in the workbook. That worksheet has a pivot table, and nothing else, and there's really not anything else in the document.

Is there any chance to get this fixed? While most of our clients are using xlsx files, we still have a large number of clients who still use the older format.

Editing to add: We're using Aspose.Cells v7.5.2.2, and the repro is simply to open the workbook and then save it again, with no other changes to the document.

Thanks,

Michael Whalen

2

Hi,

Thanks for your posting and using Aspose.Cells for .NET.

We were able to replicate this issue using your source file with the following code. The output file is corrupted and MS-Excel shows warning on opening it. We have logged this issue in our database. We will look into it and resolve this issue. Once, the issue is resolved or we have some other update for you, we will let you know asap.

This issue has been logged as CELLSNET-41983.

We have attached the output file for a reference.

C#


string filePath = @“F:\Shak-Data-RW\Downloads\Test+File.xls”;


Workbook workbook = new Workbook(filePath);

workbook.Save(filePath + “.out.xls”, SaveFormat.Excel97To2003);

3

Hi,

Thanks for your posting and using Aspose.Cells for .NET.

We have fixed the issue.

Please download and try this fix: Aspose.Cells for .NET v7.5.3.2 and let us know your feedback.

4

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

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

The issues you have found earlier (filed as ) have been fixed in this update. This message was posted using BugNotificationTool from Downloads module by MuzammilKhan