File become corrupted after shape.UpdateSelectedValue()

Aspose.Cells Product Family
1
Here is the code:
var workbook = new Workbook(@"input.xlsx");
var data0 = new object[,] { { new DateTime(2016, 2, 1) }, { new DateTime(2016, 1, 1) }, { new DateTime(2015, 12, 1) } };
var worksheet0 = workbook.Worksheets[1];
worksheet0.Cells.ImportTwoDimensionArray(data0, 17, 0);
workbook.CalculateFormula();
var listobject0 = worksheet0.ListObjects[0];
listobject0.AutoFilter.Sorter.Sort();
foreach (var worksheet in workbook.Worksheets)
{
foreach (var shape in worksheet.Shapes)
{
shape.UpdateSelectedValue();
}
}
workbook.CalculateFormula();
var workbook1 = new Workbook();
workbook1.Copy(workbook);
workbook1.Save(@"output.xlsx");

Input file is attached
2

Hi Dmitry,


Thank you for contacting Aspose support.

I have evaluated the presented scenario while using the latest major release of Aspose.Cells for .NET 8.8.2, and I am not able to replicate the said issue on my side. Please check the attached resultant spreadsheet, and give the latest version a try on your end.

3

Hi again,


This is to update you that we are able to replicate the said problem by loading the resultant spreadsheet in Excel 2007 (please check attached snapshots) whereas the problem does not replicate if resultant spreadsheet is loaded in Excel 2013. We have logged this incident in our bug tracking system as CELLSNET-44488 for further investigation. That said, it would be appropriate that you should also confirm the Excel version being used on your side so we could attached that information to the aforementioned ticket. Moreover, please feed us back with the test results carried out against the latest release.
4

Yes, we use excel 2007. And same error with latest Aspose.Cells

5

Hi,

Thanks for your confirmation and using Aspose.Cells.

We have logged your comment in our database against this ticket i.e CELLSNET-44488 for product team consideration and investigation. We will look into it and fix this. Once, the fix is available for you, we will update you asap.

6

Hi,

Thanks for using Aspose.Cells.

This is to inform you that we have fixed your issue CELLSNET-44488 now. We will soon provide the fix after performing QA and including other enhancements and fixes.

FYI: This issue was caused by the order of xml nodes in the file which is not same as MS Excel.

7

Hi,


Please try our latest version/fix: Aspose.Cells for .NET v8.8.2.3 (attached)

We have fixed your issue in it.

Let us know your feedback.

Thank you.
8

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

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