Chart points info error

[xhaixia]

Workbook wb = new Workbook("c:/RR.xlsx");

wb.calculateFormula();

Chart chart = wb.getWorksheets().get(0).getCharts().get(0);

chart.calculate();

ChartPoint point = chart.getNSeries().get(0).getPoints().get(0);

System.out.println(point.getYValue());

System.out.println(point.getShapeWidthPx());

This output

null

0

in aspose.cells 8.2.2.3, it is error!

This output

83535.0

16

in aspose.cells 8.2.2, it is ok.

[Amjad_Sahi]

Hi,

Thanks for the sample file and code segment.

I observed the issue as you mentioned by using your sample code with your template file using Aspose.Cells for Java v8.2.2.3 (latest fix). I found wrong values are retrieved for Chart’s points details, it works fine with v8.2.2.0 though.

e.g

Sample code:

Workbook wb = new Workbook(“c:/RR.xlsx”);

wb.calculateFormula();

Chart chart = wb.getWorksheets().get(0).getCharts().get(0);

chart.calculate();

ChartPoint point = chart.getNSeries().get(0).getPoints().get(0);

System.out.println(point.getYValue());

System.out.println(point.getShapeWidthPx());

Output:

null

0

I have logged a ticket with an id “CELLSJAVA-41087” for your issue. We will look into it soon.

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

Thank you.

[shakeel.faiz]

Hi,

Thanks for your using Aspose.Cells.

Please download and try the latest fix: Aspose.Cells for .NET v8.3.0.1 and let us know your feedback.

[xhaixia]

…

I use java version. Please provide java version download link

[Amjad_Sahi]

Hi,

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

We have fixed your issue now.

Let us know your feedback.

Thank you.

[aspose.notifier]

The issues you have found earlier (filed as CELLSJAVA-41087) have been fixed in this update.

---

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