Chart's series name error

Aspose.Cells Product Family
1

Workbook workbook = new Workbook("/Users/admin/Downloads/asposeBug/sample.xlsx");

Worksheet worksheet = workbook.getWorksheets().get(0);

ChartCollection charts = worksheet.getCharts();

for ( int i = 0; i < charts.getCount(); i++) {

SeriesCollection nSeries = charts.get(i).getNSeries();

for ( int j = 0; j < nSeries.getCount(); j++) {

nSeries.get(j).getPoints();

}

}

String fileName = “/Users/admin/Downloads/asposeBug/output.xlsx”;

Workbook src = workbook;

ByteArrayOutputStream out = new ByteArrayOutputStream();

src.save(out, SaveFormat. XLSX );

Workbook book = new Workbook( new ByteArrayInputStream(out.toByteArray()));

book.save(fileName, SaveFormat. XLSX );

System. out .println(“done”);

Chart’s series name is name, but show “v” in output.xlsx

sample.xlsx.zip (10.2 KB)

2

@xhaixia,

Thanks for the template file and sample code.

We will check and get back to you soon.

3

@xhaixia,

After an initial test, I am able to reproduce the issue as you mentioned by using your sample code with your template file. I found an issue with chart’s series name when referencing workbook to other workbook. I found chart’s series name is “name” but shows “v” in the output.xlsx file. I have logged a ticket with an id “CELLSJAVA-43175” for your issue. We will look into it soon.

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

4

@xhaixia,

Please try our latest version/fix: Aspose.Cells for Java v20.5.3 (attached)
aspose-cells-20.5.3-java.zip (7.1 MB)

Your issue should be fixed with it.

Please give us your feedback.

5

The issues you have found earlier (filed as CELLSJAVA-43175) have been fixed in Aspose.Cells for Java v20.6. This message was posted using Bugs notification tool by ahsaniqbalsidiqui