We are using Aspose.Cells to generate reports with charts. And print these to PDF using Excel 2007.
Because our customers are still using Excel 2003 on their PC's we try to check if the reports look the same in both Excel 2003 and Excel 2007.
Only when opening the generate Excel file in Excel 2007 the datalabels are completely different then expected.
In the designer file we have defined that only the percentage should be shown on every "slice" of the circlediagram.
In the code I loop through the datalabels of the NSeries and the ASeries and also tell it to only display the percentage.
If Not objASeries Is Nothing Then
objASeries.DataLabels.IsPercentageShown = True
objASeries.DataLabels.IsLegendKeyShown = False
objASeries.DataLabels.IsSeriesNameShown = False
objASeries.DataLabels.IsValueShown = False
Dim objDataLabels As DataLabels = objExcelChart.NSeries(i - intNSeriesColumnIndex).DataLabels
objDataLabels.IsPercentageShown = True
objDataLabels.IsLegendKeyShown = False
objDataLabels.IsSeriesNameShown = False
objDataLabels.IsValueShown = False
I have include the generated xls, which looks totally different when opened in Excel 2003 and Excel 2007.
Here an example of how it looks (and should look) in Excel 2003:
Here an example how it looks in 2007, notice how the datalabel disappeared from the biggest slice (40%):\
Could you please tell me what I am doing wrong?