I’m trying to plot a chart where “#N/A” values are gaps in the series. I’m populating the chart directly with data (rather than referencing cells). This means I’m using a string with the values of interest:
Hi,
Hi,
output excel file
and output pdf file
generated by it for your reference.PS:When I simply load and re-save yoursource excel file
into pdf, the chart does not match with source excel file, so it means, pdf is wrong and there is no issue with output excel file.
string series0Values = @"{#N/A,#N/A,#N/A,#N/A,#N/A,#N/A,#N/A,#N/A,#N/A,#N/A,#N/A,#N/A,#N/A,#N/A,#N/A,#N/A,#N/A,#N/A,#N/A,#N/A,#N/A,#N/A,#N/A,#N/A,#N/A,#N/A,#N/A,#N/A,#N/A,#N/A,#N/A,#N/A,#N/A,#N/A,#N/A,#N/A,#N/A,#N/A,#N/A,#N/A,#N/A,#N/A,#N/A,#N/A,#N/A,#N/A,#N/A,#N/A,#N/A,#N/A,1.1599999999999999,0.06,1.41,1.3,1.3,1.38,1.05,1.43,1.39,1.2,1.39,1.25,1.42,1.42,1.24,1.35,1.34,1.3,1.26,1.2,1.29,1.26,1.29,1.3,1.3,1.29,1.32,1.31,1.23,1.27,1.25,1.33,1.33,1.24,1.2,1.29}";
string series1Values = @"{#N/A,#N/A,#N/A,#N/A,#N/A,#N/A,#N/A,#N/A,#N/A,#N/A,#N/A,#N/A,#N/A,#N/A,#N/A,#N/A,#N/A,#N/A,#N/A,#N/A,#N/A,#N/A,#N/A,#N/A,#N/A,#N/A,#N/A,#N/A,#N/A,#N/A,#N/A,#N/A,#N/A,#N/A,#N/A,#N/A,#N/A,#N/A,#N/A,#N/A,#N/A,#N/A,#N/A,#N/A,#N/A,#N/A,#N/A,#N/A,#N/A,#N/A,7.6E-3,3.7100000000000001E-2,1.26E-2,9.7000000000000003E-3,9.7000000000000003E-3,1.2E-2,9.1000000000000004E-3,1.2699999999999999E-2,1.2500000000000001E-2,1.14E-2,1.4E-2,1.3299999999999999E-2,1.4999999999999999E-2,1.61E-2,1.3899999999999999E-2,1.3899999999999999E-2,1.43E-2,1.44E-2,1.23E-2,1.17E-2,1.2500000000000001E-2,1.21E-2,1.3599999999999999E-2,1.38E-2,1.3899999999999999E-2,1.4800000000000001E-2,1.6400000000000001E-2,1.7899999999999999E-2,1.83E-2,1.77E-2,1.7399999999999999E-2,2.06E-2,1.9800000000000002E-2,1.55E-2,1.24E-2,1.6400000000000001E-2}";
Workbook workbook = new Workbook("Book1.xlsx");
Worksheet worksheet = workbook.Worksheets["Sheet1"];
Chart chart = worksheet.Charts[0];
Series series0 = chart.NSeries[0];
series0.XValues = categories;
series0.Values = series0Values;
Series series1 = chart.NSeries[1];
series1.XValues = categories;
series1.Values = series1Values;
chart.Calculate();
workbook.Save(@"Test.xlsx");
//workbook.Save(@"Test.pdf");
Were you able to recreate the issue where #N/A values were replaced with -1.#QNAN values?
And, when looking at your Excel workbook “Test.xlsx”, I still see the -1.#QNAN values, so that means the #N/A values are still being replaced.
Hi,
And, when looking at your Excel workbook “Test.xlsx”, I still see the -1.#QNAN values, so that means the #N/A values are still being replaced.
Also, the PDF output you are seeing (Test.pdf) is the original issue I was investigating, and that is when I noticed the -1.#QNAN values. Do you think the -1.#QNAN are causing the PDF version of the workbook to incorrectly display?
Ok, glad you were able to reproduce the Export-To-PDF issue I was seeing.
Hi,
We use Office 2010 as of now. The only thing different between the “Book1.xlsx” I originally attached, and the latest (attached) is I cleared out the series data (left just one data point, {1}, in each series).
Hi,
Thank you!
Hi,
Hi,
Sounds good. Assuming the -1.#QNAN was not causing the export-to-pdf issue (CELLSNET-44902), then the replaced #N/A values does not seem to be adversely affecting functionality.
Hi,
Hello, Do you have an update on CELLSNET-44902? I’m wondering when we can expect a fix. Thanks!
Hi,
Hi,
Great! Thanks. Do you know when you plan to release to Nuget (including this fix)?
Hi,