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

Free Support Forum - aspose.com

Some Chart Radar chart's points xy px return 0

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

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.

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


But wrong in ChartType.RADAR_FILLED.

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.

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.

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.