Free Support Forum - aspose.com

Excel 2016 chart content not kept after manipulating worksheet with Aspose.Cells

Issue found with Aspose.Cells 18.9.0.0. After opening and saving the Excel file with Aspose.Cells chart content will be removed. This happens only for Excel 2016 charts: Map, TreeMap, Sunburst, Histogram,Box & Whisker, WaterFall, Funnel

I have attached a sample excel and the output: sample.zip (1.1 MB), created using the following code:

Workbook workbook = new Workbook(“excel.xlsx”);
Worksheet sheet = workbook.Worksheets[0];
for (int i = 0; i < sheet.Charts.Count; i++)
{
Chart ch = sheet.Charts[i];
ch.Title.Text = "Chart Type is " + ch.Type.ToString();
}
workbook.Save(“excel_output.xlsx”);

@adrian.anton,

We were able to observe the issue but we need to look into it more. We have logged the issue in our database for investigation and for a fix. Once, we will have some news for you, we will update you in this topic.

This issue has been logged as

CELLSNET-46416 - Charts data lost while loading and saving the XLSX file

@adrian.anton

This is to inform you that we have fixed your issue now. We will soon provide you the fixed version after performing QA and incorporating other enhancements and fixes.

Once the fix is available for public use, we will share the Download link here.

@adrian.anton,

Please try our latest version/fix: Aspose.Cells for .NET v18.10.2:

Aspose.Cells18.10.2 For .Net4.0.Zip (4.7 MB)
Aspose.Cells18.10.2 For .Net2_AuthenticodeSigned.Zip (4.7 MB)

Your issue should be fixed in it.

Let us know your feedback.

The issues you have found earlier (filed as CELLSNET-46416) have been fixed in Aspose.Cells for .NET v18.11. This message was posted using BugNotificationTool from Downloads module by Amjad_Sahi