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:
https://forum.aspose.com/t/45298
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,
Hi Babar,
Do you have an update on this issue? Thank you!
Raluca
Hi Raluca,
Hi Raluca,
Hi,
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,