SheetRender fails when UpdateSelectedValue is used

Hello,

We’ve identified an issue with SheetRender when exporting a Shape image, when refreshing Shapes within the workbook by using UpdateSelectedValue. I’ve attached a sample console application describing the issue.

The included test file is an xlsx file created by using Excel 2010:
- Data sheet contains some data used on Sheet1
- Sheet1 contains a Chart linked to the Data sheet, and also a (Camera) Picture linked to cells from the same Data sheet
- Sheet2 contains a (Camera) Picture over the Sheet1’s

The test tries to use SheetRender to render the area containing the picture from Sheet2, and it fails at per the attached outputImage.png. I have to note that commenting the UpdateSelectedValue line results in the image is being correctly outputed, but we need the UpdateSelectedValue in order for the other Chart and Image from the Sheet1 to be updated to latest values which we dynamically insert in the file.

We are using Aspose.Cells version 8.8.0.0.

Any feedback will be highly appreaciated.

Thank you,
Mihai Andrei
Sr Software Engineer
IBM Romania

*Aspose.Cells version 8.0.0.0.

Hi Mihai,


Thank you for bringing this issue to our knowledge.

We are able to replicate the presented problem on our end while using Aspose.Cells for .NET 8.0.0. For further investigation and correction purposes, we have logged the problem in our bug tracking system under ticket Id CELLSNET-42523. Please spare us little time to properly analyze the problem cause, and to provide a fix. In the meanwhile, we will keep you posted with updates in this regard.

Hi Mihai,

Thanks for using Aspose.Cells.

We have fixed this issue.

Please download and try the latest major release:

Aspose.Cells for .NET 8.0.2

and let us know your feedback.

Hello,

Tested against Aspose.Cells version 8.0.2.0 and it seems the issue was solved.

Thank you,
Mihai Andrei

Hi Mihai,

Thanks for your feedback and using Aspose.Cells.

It is good to know that your issue is resolved with the latest fix. Let us know if you encounter any other issue, we will be glad to look into it and help you further.

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


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