Worksheet.Charts.Add can specify the data range, but not the data direction

[Flithor]

Separated from this bug feedback:

Chart.SetChartDataRange will skip empty cell in data range

The datas [image] The result of Excel: [image] the result of Chart.SetChartDataRange: [image] (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

The fourth sheet of the attached example.xlsx

method Worksheet.Charts.Add(ChartType, string, int, int, int, int) need a “isVertical” argument.

[amjad.sahi]

@Flithor,

We have logged a ticket with an id “CELLSNET-50996” for your requirements. We will check if we can add an overloaded method: ChartCollection.Add (ChartType, String, Boolean, Int32, Int32, Int32, Int32). We will look into it soon.

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

[amjad.sahi]

@Flithor,

This is to inform you that your issue has been resolved. The fix will be included in the next release (Aspose.Cells for .NET v22.6) which is scheduled in the second week of June 2022. You will also be notified when the next version is released.

[aspose.notifier]

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

[johnson.shi]

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.