Chart.SetChartDataRange will skip empty cell in data range

Aspose.Cells Product Family
1

The datas

The result of Excel:

967×583 33.7 KB

the result of Chart.SetChartDataRange:
1513×595 47.3 KB

(I moved the charts to data sheet)

Here is the sample code:
AsposeCellsBugReport.zip (28.1 KB)
Please don’t break this fix when you fixing current bug.

image.png (1.1 KB)
image.png (33.7 KB)
image.png (47.3 KB)

Another issue about this example is here: Worksheet.Charts.Add can specify the data range, but not the data direction

2

@Flithor,

Thanks for the template file and screenshots.

Please notice, I am able to reproduce the issue as you mentioned by using your template file. I found Chart.SetChartDataRange will skip empty cells in data range. I have logged a ticket with an id “CELLSNET-50995” for your issue. We will look into it soon.

Once we have an update on it, we will let you know.

3

The issues you have found earlier (filed as CELLSNET-50995) have been fixed in this update. This message was posted using Bugs notification tool by johnson.shi

4

The issues you have found earlier have been fixed in this update. If you have downloaded the prior one(22.6.0), please use this update to replace the downloaded one because 22.6 has a bug which sometimes may cause generated file corrupted.