Excel: File is corrupt and cannot be opened (xls)

Crossing · August 2, 2011, 4:15am

I receive a “file is corrupt” error in Excel. This error occurs after creating a worksheet with aspose (5.3.1.0) with a pivottable ,saving the file as .xls. and opening in Excel 2010.

When i change the SaveFormat to xlsx everything works fine. I use the saveformat Excel97To2003.
I found a workaround for this: Adding a new trusted location in the Trust Center Settings in Excel, saving the file to that location and than no error occurs and the correct output shows.

Is there a better solution for this problem?

thanks in advance,
Floris

shakeel.faiz · August 2, 2011, 4:38am

Hi,

Thanks for your interest in Aspose.Cells for .NET and reporting the problem.

Kindly provide and your sample C# project replicating this problem. We will look into it and fix it asap.

Please also test your issue with the latest version:
Aspose.Cells for .NET (Latest Version)

amjad.sahi · August 2, 2011, 4:39am

Hi,

Please download our latest version/fix: Aspose.Cells for .NET (Latest Version)

and try it if it works fine. We have made tremendous enhancements regarding PivotTable features.

If you still find the issue, kindly do create a simple console application, zip it and post it here to show the issue, we will check it soon.

Thank you.

Crossing · August 2, 2011, 7:29am

Hi, thanks for the quick reply. Using the latest version of Aspose.Cell does not fix my problem.

I have created a sample application for my issue.

greetings,

Floris

shakeel.faiz · August 2, 2011, 8:10am

Hi,

Thanks for your testing this issue with the latest version and providing us your sample project and feedback.

I have logged this issue in our database. We will update you asap.

This issue has been logged as CELLSNET-29582.

Crossing · August 4, 2011, 1:43am

Hi, is it possible for you the give an indication date for when you have looked at the issue and came up with a solution or workaround?

thanks.

shakeel.faiz · August 4, 2011, 2:05am

Hi,

Normally, you have to wait for 2~3 days to get a fix. However, it might take a week too if the problem is difficult to be resolved.

shakeel.faiz · August 7, 2011, 9:10pm

Hi,

We have fixed this issue. Please download:
Aspose.Cells for .NET (Latest Version)

Crossing · August 23, 2011, 4:19am

hi,
thanks for the fix. the problem no longer occurs.

shakeel.faiz · August 24, 2011, 5:22pm

Hi,

That’s good to find your problem is finally resolved.

aspose.notifier · August 29, 2011, 2:46am

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

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