When rendering charts to images, lines appear

Aspose.Cells Product Family
, , ,
1

This problem occurs for charts Adj.EBITDA_YTD and Adj.EBITDA_MTD in worksheet Appendix D - Adjusted EBITDA AD, Excel file input.xlsx

Charts are also rendered with lines when the Excel file is opened via Excel Editor Online for Free

Repro code:

Workbook workbook = new Workbook("input.xlsx");
Worksheet worksheet = workbook.getWorksheets().get("Appendix D - Adjusted EBITDA AD");
ChartCollection charts = worksheet.getCharts();
Chart chart = charts.get("Adj.EBITDA_YTD");

ImageOrPrintOptions options = new ImageOrPrintOptions();
options.setVerticalResolution(300);
options.setHorizontalResolution(300);
options.setImageType(ImageType.PNG);

chart.toImage("chart.png", options);

input.zip (3.8 MB)
chart.png (106.9 KB)

attaching input.zip (contains input.xlsx) and chart.png file from repro code.

Zoom in chart.png if lines are not visible at first glance.

We are using Aspose Repository Browser /java/repo/com/aspose/aspose-cells/23.4/
Reproduced the same problem with version 23.6

3

@ANDREA.FARRIS
Thanks for the template XLSX file.

We reproduced the issue as you mentioned by converting the charts to images. We found the lines when rendering. We need to evaluate your issue in details.

We have opened the following new ticket(s) in our internal issue tracking system and will deliver their fixes according to the terms mentioned in Free Support Policies.

Issue ID(s): CELLSJAVA-45485

You can obtain Paid Support Services if you need support on a priority basis, along with the direct access to our Paid Support management team.

4

@ANDREA.FARRIS,

We are glad to inform you that your issue has been resolved. The solution will be added to the upcoming release of Aspose.Cells (v23.7) that we plan to release in 1-2 days. We will notify you once the next version is available.

5

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