Convert Excel file with graphs to PDF in Java

Problem: Spreadsheets sometimes show incorrect graph data

Description:
Some spreadsheets do not show the correct graph data when converted to PDF through GroupDocs. In the attached file the pie graph only shows 2 colors instead of 4 after being run through GroupDocs xlsx to pdf.

Environment:

  • GroupDocs Conversion SDK: Java (1.8.0_181)
  • Operating System: Ubuntu 14.04.5 LTS
  • GroupDocs version: 18.7

Spreadsheet:

  • Microsoft Excel: 16.9

Provided: sample-spreadsheet.xlsx.zip (11.7 KB)

@bkirkby,

Thanks for your inquiry.
Can you please share the code sample that you used for the conversion process?

@bkirkby,

This issue is reproduced at our end using following code:

ConversionHandler conversionHandler = new ConversionHandler(Utilities.getConfiguration());
PdfSaveOptions saveOption = new PdfSaveOptions(); 

// Set absolute path to file
String guid = fileName;

ConvertedDocument convertedDocumentPath = conversionHandler.<String> convert(guid, saveOption);
convertedDocumentPath.save(fileName + "." + convertedDocumentPath.getFileType());

Hence, we have logged it in our internal issue tracking system with ID CONVERSIONJAVA-518. As we have any update on it, you’ll be notified.

1 Like

@bkirkby,

We have an update regarding CONVERSIONJAVA-518. This issue will be resolved in version 19.1.
Expected output is attached - pie chart output.pdf (32.6 KB)

1 Like

thanks atirtahir3! i can’t seem to find a download for version 19.1 for java. do you have a link for that?

thanks!

-bk

@bkirkby,

As release package/API gets on-board, we shall share download link with you. We’ll appreciate your patience in this regard.

1 Like

@bkirkby,

Your reported issue CONVERSIONJAVA-518 is now resolved in GroupDocs.Conversion for Java 19.4.
See this output - output.JPG (51.0 KB)

1 Like