We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

[.Net][1.8.6.0.0] Can't calculate chart with lots of data points

Hi,

In the attached excel document, I’m attempting to use calculate on a chart, which throws a System.Overflow exception from System.Drawing. This code will throw the exception:

var workbook = new Workbook("filepath");
var worksheet = workbook.Worksheets.FirstOrDefault(x => x.Name == "SP01");
worksheet.Charts.First().calculate();

Thanks!487.zip (3.2 MB)

@joeymilyli,

Thanks for your query.

We have tested this issue with the latest version of Aspose.Cells for .NET 18.7.0 but no problem is raised. Please test this issue with the latest version and provide your feedback again. If this issue is not resolved, send us the complete solution along with the version of Aspose.Cells for our testing.

It turns out the issue with the code I provided was because I was calculating the wrong chart in the code block. However, the issue is fixed in 1.8.9 anyway so we’re good!

@joeymilyli,

Thank you for the feedback and feel free to write us back if you have any other query.