Some Chart Radar chart's points xy px return 0

Aspose.Cells Product Family
1
Workbook wb = new Workbook("C:/S.xlsx");
ChartCollection charts = wb.getWorksheets().get(0).getCharts();
charts.get(0).calculate();
System.out.println(charts.get(0).getNSeries().get(0).getPoints().get(0).getShapeXPx());

charts.get(1).calculate();
System.out.println(charts.get(1).getNSeries().get(0).getPoints().get(0).getShapeXPx());


output
40
0
2

Hi,


Thanks for the template file and sample code.

After an initial test, I observed the issue as you mentioned by using your sample code with your template file. I found that Radar chart’s points X/Y (in pixels) return 0 although I am not entirely certain if this is expected for a Radar chart:
e.g
Sample code:

Workbook wb = new Workbook(“s.xlsx”);
ChartCollection charts = wb.getWorksheets().get(0).getCharts();
charts.get(0).calculate();
System.out.println(charts.get(0).getNSeries().get(0).getPoints().get(0).getShapeXPx());

charts.get(1).calculate();
System.out.println(charts.get(1).getNSeries().get(0).getPoints().get(0).getShapeXPx());
System.out.println(charts.get(1).getNSeries().get(0).getPoints().get(0).getShapeYPx())

I have logged a ticket with an id “CELLSJAVA-42223” for your issue. Our concerned developer will evaluate it soon.

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

Thank you.
3

If it is a ChartType.RADAR chart, it work fine.


But wrong in ChartType.RADAR_FILLED.
4

Hi,


Thanks for your findings.

I have logged it to share with the product team. Our concerned developer from product team will analyze your issue soon.

Thank you.
5

Hi,


Please try our latest version/fix: Aspose.Cells for Java v17.3.7 (attached).

We have fixed your issue now.

Let us know your feedback.

Thank you.
6

The issues you have found earlier (filed as CELLSJAVA-42223) have been fixed in Aspose.Cells for Java 17.4.0.

This message was posted using Notification2Forum from Downloads module by Aspose Notifier.