Free Support Forum -

#N/A not handled correctly in charts

In Excel, creating a line chart and adding a series with the values “{1,#N/A,3}” produces a connected line with data points at (1,1) and (3,3). In Aspose, the following code:

Workbook book = new Workbook();
Worksheet sheet = book.Worksheets[0];

Chart chart = sheet.Charts[sheet.Charts.Add(ChartType.LineWithDataMarkers, 0, 0, 5, 5)];
chart.NSeries.Add(“A1”, false);
chart.NSeries[0].Values = “{1,#N/A,3}”;

book.Save(“book.xls”, FileFormatType.Default);

produces a different chart every time, with the series values showing “{0,0,0}” and the actual values as tiny nonzero numbers.

The attached file has a chart generated in excel on the left, and three charts generated with exactly the code above on the right. The code was called three times in succession, and those are the three line charts it generated.


<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />

Thank you for sharing the sample code.

We have found your mentioned issue after an initial test. We will look into it and get back to you soon. Your issue has been registered in our internal issue tracking system with issue id: CELLSNET-15612.

Thank You & Best Regards,

Hi,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />

Please try the attached latest version of Aspose.Cells for .NET. We have fixed the issue.

Thank You & Best Regards,