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 220.127.116.11.
Any feedback will be highly appreaciated.
Sr Software Engineer
*Aspose.Cells version 18.104.22.168.
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.
Tested against Aspose.Cells version 22.214.171.124 and it seems the issue was solved.
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.