We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

Potential bug in excel charts

We recently upgraded to Cells 4.6 from 4.4 and some of our excel charts stopped displaying correct data. Upon further investigation it looks like the Chart.nseries.categorydata, and .add methods are incorrectly interpreting lowercase column letters. For example, “b23:b50” is getting translated to $AG$23:$AG$50. We were able to fix the problem by changing all our strings into uppercase in code, but somewhere between version 4.4 and 4.6 the behavior of lowercase letters changed.

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

Thank you for considering Aspose.

After an initial test, we are able to reproduce the issue you have mentioned. We will fix it and get back to you soon.

Thank You & Best Regards,

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

Thank you for considering Aspose.

Please try the attached latest fix of Aspose.Cells. We have supported the chart data source which contains lowercase column letters.

Thank You & Best Regards,

Hi,

Please ignore the fix (4.6.0.7) attached in Nausherwan's post as there was still a bug regarding lowercase column letters. Please try the attached version/fix (4.0.0.8), we have fixed it now.

Thank you.