PDF Converting Issue using Aspose.Cells (JAVA)

Aspose.Cells Product Family
1

When converting Excel to PDF, some issues are found and reported.
test.zip (155.2 KB)

  1. testsample 1 : When the section written “SAMPLE FILE FOR TEST” is converted into pdf using aspose.cell, it is not exported properly. “TEST”. The part of the letter “TEXT” is cut.
  2. testsample 2 : When the circle image is converted into pdf using aspose.cell, it is not exported properly. The background color is converted to black.
  3. testsample 3: When Testsheet1 is converted into pdf using aspose.cell, it is not exported properly.
    1 page is set up to the 36th row of the table, 1 page is output up to the 37th row via Aspose.Cells. Also, Note1 is set to 3 page, but Note1 is output in the last line of 2 page.

The above is not an issue that does appear when converted to pdf through MS office.

My code is as below;

public static void main(String[] args) throws Exception {

    Workbook workbook = new Workbook( "...");

    PdfSaveOptions pdfSaveopt = new PdfSaveOptions();
    pdfSaveopt.setEmfRenderSetting(EMF_PLUS_PREFER);
    pdfSaveopt.setImageResample(220,100);
    pdfSaveopt.setCompliance(PDF_15);

    workbook.save("...", pdfSaveopt);
2

@kpkim
By using sample files and code for testing, we can reproduce the three issues you described. Found text truncation, incorrect shape background color, and file pagination errors when converting files to PDF.

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-45731: Text is truncated when converting the file to PDF
CELLSJAVA-45732: Shape background color error when converting file to PDF
CELLSJAVA-45733: File pagination error when converting file to PDF

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.

3

@kpkim,

This is to inform you that your two issues (“CELLSJAVA-45731” and “CELLSJAVA-45733”) have been resolved. The fixes will be included in our upcoming release (Aspose.Cells v23.12) that we plan to release in the second week of December. You will be notified when the new version is published.

4

The issues you have found earlier (filed as CELLSJAVA-45731,CELLSJAVA-45733) have been fixed in Aspose.Cells for Java 23.12.

5

Regarding CELLSJAVA-45733, A similar issue is still occurring during converting. Can you check the attached file?

sample.zip (281.4 KB)

6

@kpkim ,

The new attached “testsample 3.xlsx” is binary same as your shared in origin post.
Please check the pdf file directly saved Microsoft Excel on my side:
testsample 3_SavedByExcel.zip (81.8 KB)
The pagination is same as the pdf generated by Aspose.Cells.

Also, your new attached “testsample 3 by excel.pdf” is not match with the following:

7

I checked that my local pc has some issue when .xlsx is opened. Thanks.

8

@kpkim ,

Please share more details and screenshots about your issue.

If it is the pagination issue, as we have described that the pagination is same:

9

Any updates for CELLSJAVA-45732 ?

10

Hi @kpkim
The implementation of this feature is complex, we’re still working on it, it’s not supported yet.