Can not use column exceed IV in chart

Aspose.Cells Product Family
1

Hello dear,

we are encountering the problem which we can not use column exceed column IV in chart.

e.g.

if we are setting NSeries[0].Values = "JN7:JO7" it will be set to "AR7:AS7".

Could you help us to sort this out?

we are using the 7.2 version of aspose.cell, thank you in advance.

2

Hi,


Are you creating / adding the chart from the scratch. For example, if you are creating and instantiating a new workbook by using, e.g Workbook wb = new Workbook(), here you may specify the file formatting type to XLSX and save the file to XLSX file format instead of XLS. See the line of code that you may use instead:
Workbook wb = new Workbook(FileFormatType.Xlsx);

For your information IV is the last column for an XLS file format (MS Excel 97 - 2003), so the chart is created based on the data range within the range Ax:IVx. So, you can always save the file in XLSX file format which does not have IV column’s limitation.

Let us know if you still have any problem or confusion.

Thank you.

3

Thanks. It works

4

Hi,


Good to know that your issue is sorted out. Feel free to contact us any time if you need further help or have any other query/issue, we will be happy to assist you soon.

Thank you.