Problem with the creation of a chart LINE on XLSX file

Aspose.Cells Product Family
1

Hello,

I want to create a simple Chart, of type “Line”. Unfortunately, when I save my Excel file as a XSLX format, the chart type is “Line with data markers” and not “Line”.

To create the Chart, I use the following code:

Workbook workbook = new Workbook();
Worksheet ws = workbook.getWorksheets().getSheet(0);
Cells cells = ws.getCells();
cells.getCell(“A1”).setValue(1);
cells.getCell(“A2”).setValue(2);
cells.getCell(“A3”).setValue(3);
cells.getCell(“A4”).setValue(4);
cells.getCell(“B1”).setValue(4);
cells.getCell(“B2”).setValue(7);
cells.getCell(“B3”).setValue(6);
cells.getCell(“B4”).setValue(7);
// Create the Chart
Chart chart = ws.getCharts().addChart(ChartType.LINE, 5, 1, 15, 5);
chart.getNSeries().add(“A1:B4”, true);
workbook.save(“c:\test.xls”, FileFormatType.EXCEL97TO2003); // In XLS, it is correct
workbook.save(“c:\test.xlsx”, FileFormatType.XLSX); // In XLSX, the type of chart is not correct

The chart on the Excel 97/2003 is correct.
I am using Aspose Cells v2.5.3.8, Java 1.6 and Excel 2007 sp2.

You can find the two Excel files generated attached to this post.

What am I doing wrong?

Thanks in advance.

2

Hi,


Thank you for bringing this to our knowledge.
We are able to reproduce your said issue, so we have logged it in our bug tracking system under Ticket ID CELLSJAVA-27932. Soon we will update you on this.
3

Hi,

Thanks for reporting.

I was able to reproduce this issue with Aspose.Cells for Java v2.5.3.8. We will fix it as soon as possible.

This issue has been logged as CELLSJAVA-27933.

4

Thanks for your quick reply.

However, be carefull as you created 2 defects for the same issue :slight_smile:

5

Hi,

Thanks for your posting.

No problem, these issues have been marked as related and duplicate in our database.

6

Hi,


We have fixed your said issue in latest fix version of Aspose.Cells for JAVA v2.5.4.1 [attached]. Please try your requirement with this new JAR and let us know of your feedback.
Thank you.
7

Hello,

I’ve tried with 2.5.4.1 version, and the problem is now solved!

Thanks again.

8

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

This message was posted using Notification2Forum from Downloads module by aspose.notifier.