Wrong border color in Chart's PDF

Aspose.Cells Product Family
1
Hello,

I am using Aspose.Cells v8.6.2.1 to generate PDF of chart - Chart one in the attached excel file. In the PDF output, the border color is purple whereas in actual chart the border color is gray.

Following code is used to generate the output:

void chartToPDF() throws Exception {
Workbook workbook = new Workbook("test.xls");
WorksheetCollection ws = workbook.getWorksheets();
String worksheetName = "PRODCAP Country BY Company";
Chart chart = ws.get(worksheetName).getCharts().get("Chart one");
chart.toPdf("D:\\test.pdf");
}

Can you please analyse this issue.

Thanks,
Neha
2

Hi Neha,


Thank you for sharing the sample spreadsheet.

We have evaluated the presented scenario while using the latest version of Aspose.Cells for Java 8.6.2.1, and we are able to notice the said issue, that is; the chart borders render purplish in resultant PDF. We have logged this incident as CELLSJAVA-41622 in our bug tracking system. Please allow us some time to investigate the matter and to provide a fix. In the meanwhile, we will keep you posted with updates in this regard.
3

Hi,

Thanks for using Aspose.Cells.

We have fixed the issue CELLSJAVA-41622.

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

4

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

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

Hello,


I have used Aspose.Cells v8.6.3 to generate the PDF but unfortunately, this issue is still not resolved. The chart’s border color appears purple while the actual color is gray. If you will Zoom-in the PDF, the purple color is clearly visible.

I have attached the PDF taken using Aspose.Cells v8.6.3.

Can you please analyse this issue.

Thanks,
Neha
6

Hi Neha,

Thanks for your fine and sharp observation and using Aspose.Cells.

We were able to observe this issue with the latest version 8.6.3 after zooming the output chart to 400% or more and found that border color is purple instead of grey.

We have therefore reopened this issue and logged your observations. We will look into it further and fix this issue. Once the issue is resolved or we have some other update for you, we will let you know asap.

7

Hi Neha,

Thanks for your posting and using Aspose.Cells.

Since you are using XLS format, therefore it does not support unlimited colors, it only supports 256 colors. And if you open your file in Excel 2003, you will see the color is Blue-Gray (or Purple as you say) so this is not a bug but the limitation of XLS format. As the color is different when open in Excel 2003 and Excel 2013, we must follow the Excel 2003 standard.

Please check the screenshot attached with this post for your more clarification. It displays your chart in Excel 2003.