Problem with chart

[Torta_Alberto]

Hi all!
i have problems with xltx file that have a chart with multiple series. When i open the file i can see the chart but the chart object has no series.

Dim xlsChart As FlexCel.Core.ExcelChart = xlfFile.GetChart(1, nothing)
xlsChart.seriesCount() is equal to zero.

When i open a xlt file (excel 2003) using the same code snippet i see the series.

Are there some bugs regarding the chart series? I have saved the xlt file in xltx file and test for compatibility issue.

Filippo.

[adrian]

Hi,

This was answered by email, but I'll paste the answer here:

Hi,

Indeed, SeriesCount, GetSeries and SetSeries aren’t yet implemented for xlsx/xltx/xlsm files, only for xls/xlt. Charts in xlsx will be preserved, they will be copied, the range of data will be expanded, but they won’t be exported to pdf/html, and getseries/setseries won’t work. In fact, the reason they aren’t exported is because GetSeries isn’t yet implemented.

Implementing a better xlsx chart support is in or plans for FlexCel 7, especally the chart exporting to pdf/html (which will mean we will have to implement Get/SetSeries and SeriesCount). Sadly the charts changed completely between xls and xlsx, and we will have to implement a completely new chart engine, which is a lot of work. This is why this can’t be done sooner.