Saving column chart with RefreshChartCache rotates the chart

Aspose.Cells Product Family
1

Hi,

We have a stacked column chart in 3D, attached to this post as Book2.xlsx.

The following piece of code saves this chart again, but on the output the chart itself suffers a 3D rotation. The result we obtain is attached as out.xlsx.

var workbook = new Workbook(“book2.xlsx”);
using (var memoryStream = new MemoryStream())
{
workbook.Save(memoryStream, SaveFormat.Xlsx);
var array = memoryStream.ToArray();
using (var tempStream = new MemoryStream(array))
{
var asposeDocument = new Workbook(tempStream);
var saveOptions = new OoxmlSaveOptions(SaveFormat.Xlsx) { RefreshChartCache = true };
asposeDocument.Save(“out.xlsx”, saveOptions);
}
}

The Aspose.Cells version we are using is 7.5.2.0.

2

Hi,

Thanks for your posting and using Aspose.Cells for .NET.

We were able to replicate this issue using your sample code and source file. We have tested it with the latest version but the problem still occurs. The output chart is rotated. We have logged this issue in our database. We will look into it and fix the issue. Once, the issue is fixed or we have some other update for you, we will let you know asap.

This issue has been logged as CELLSNET-42036.

3

Hi,


Please try the latest version/fix: Aspose.Cells for .NET v7.5.3.6 , we have fixed your issue.

Let us know your feedback.

Thank you.

4

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

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