I am using Spire.XLS to convert Excel files to PDF and IMG formats. My Excel document consists of a single line chart on 1 worksheet and a data table on a 2nd worksheet. The line chart is created by referencing the data in the data table. Everything works great when the data in the table is continuous but this isn't always the case. Sometimes I will have empty values for a given month on the line chart. Excel renders this correctly and will show a gap in the chart whenever blanks are encountered but when I render the Excel to PDF or IMG the gap in the chart is replaced by a line connecting the points. When creating the chart I am setting the "DisplayBlankAs" property to Not Plotted but the PDF and IMG don't seem to be obeying it. I noticed that there are 2 other eunms in the Spire.Xls class that might deal with this but I can't figure out where they get used. Those enums are:
ChartPlotEmpty2007
XLSXChartPlotEmpty
Should I be setting something with one of those to get this working or is this a bug in the IMG and PDF exporting? See below for example.
Correct (In Excel):
- From Exel - Correct
- From Excel (Correct).png (8.27 KiB) Viewed 1525 times
Incorrect (In PDF)
- From PDF - Incorrect
- From PDF (Incorrect).png (14.12 KiB) Viewed 1525 times
Thanks very much.
Jason
