Free Support Forum - aspose.com

Problem and bugs after converting xls to pdf

We took into consideration your library (Aspose.Cells) for converting from xls and xlsx to pdf files. We decided to try your library on some examples. After testing we found some problems and bugs. We tried to convert files using PdfSaveOptions, but bugs didn’t disappear.

There are the following bugs:

  1. Changed backgroud colour of header table. (Summary sheet or second page of test_file_Aspose.pdf, see pic bug_1)
  2. Different diagrams. (Chart sheet or third page of test_file_Aspose.pdf, see bug_2)
  3. Different height pdf pages (See pic bug_3, TEST_PDF_Aspose.pdf).
  4. Cell text is not displayed fully (See pic bug_4, Agg_Call_and_Dist_Aspose.pdf)

Attached please find pdf files created from library (Aspose.Cells), pdf files created from excel, excel files, java code (files.zip) and pictures with bugs .
How fix this bugs? When will this bugs in library fix?

bug_1.png (186.9 KB)

bug_3.png (570.9 KB)

files.zip (522.2 KB)
bug_2.png (97.3 KB)
bug_4.png (61.8 KB)
bug_1.png (187 KB)
bug_3.png (429 KB)
files.zip (522 KB)

@Tesla19,
We have observed these issues and logged a ticket in our database for further investigation. We will write back here once any update is ready for sharing.

This issue is logged as:
CELLSJAVA-43350 - Issues while converting Excel files to PDF

Regarding issue 4, MS Excel has also not rendered full text so it does not seem to be an issue with Aspose.Cells.

@Tesla19,
We have investigated it bit more. We can reproduce the bug_1 and logged a issue as “CELLSJAVA-43351”.

For bug_2, your shared screenshot “bug_2.png” is not consistent with page 3 of the shared pdf files “test_file_Aspose.pdf” and “test_file_from_excel.pdf”, please share a new screenshot with issue highlighted.

For bug_3 and bug_4, our generated pdf files are same as Excel 2016 on windows 10 generated. See the attachment “bug_3 and bug_4.zip”
bug_3 and bug_4.zip (536.3 KB)

@ Tesla19,
This is to inform you that we have fixed the issue (“CELLSJAVA-43351”) now. We will soon provide you the fixed version after performing QA and incorporating other enhancements and fixes.

“Regarding issue 4, MS Excel has also not rendered full text so it does not seem to be an issue with Aspose.Cells.”
Yes, but it looks difference. When we convert to pdf with the help excel word “necessary” almost complete rendered. But when we convert to pdf with the help aspose, only “nece…” from word “necessary” rendered on the page.
May be because I used Excel 2016 for Mac Os.
bug_4.png (61.8 KB)

Blockquote
For bug_2, your shared screenshot “bug_2.png” is not consistent with page 3 of the shared pdf files “test_file_Aspose.pdf” and “test_file_from_excel.pdf”, please share a new screenshot with issue highlighted.
Blockquote

Sorry me. I have attached new files and picture.
filles_bug_2_2.zip (689.4 KB)
bug_2_2.png (341.7 KB)

Also I found bug-5. This bug is consist at the following: after converting with aspose to pdf, percentages was not showed at the small histograms. I have attached picture and files.
bug_5.png (429.5 KB)
files_for_bug_5.zip (110.9 KB)

Please try our latest version/fix: Aspose.Cells for Java v20.11.5 (included)
Let us know your feedback.
aspose-cells-20.11.5-java.zip (7.2 MB)

1 Like

@Tesla19,
Please note that CELLSJAVA-43351 fixes the reported issue “bug_1.png”.

We have logged following issues:

CELLSJAVA-43353: For the issue with "bug2_2.png"
CELLSJAVA-43354: For the issue with "bug_5.png"

For issue “bug_3.png” and “bug_4.png”, we have shared the results of Excel 2016 on Win10 (see attachment: “bug_3 and bug_4.zip”) which are same as our generated. We consider the results of Excel on Windows as the good results. So bug_3 and bug_4 are not the issues.

Hello!
Also we found bug when we had been converting file from xls to xlsx. We attached files.
Thanks.
bug_6.png (244.2 KB)
excel_files.zip (226.3 KB)

@Tesla19,
I am facing error while extracting data from the zip file. Could you create a new zip file and share it again for our analysis.

excel_files.zip: Unknown method in Collected_Capital_Chart_Aspose.xlsx
excel_files.zip: Unknown method in Collected_Capital_Chart.xlsx
excel_files.zip: Unknown method in Collected_Capital_Chart.xls
excel_files.zip: No files to extract

Try again, please.
excel_files.zip (237.6 KB)

@Tesla19,
Thank you for the files. We have logged the following issue:

CELLSJAVA-43361: Incorrect cell color on xls to xlsx conversion

Once we will have some news for you, we will update you in this topic.

Hello! Bug 1 was fixed at [aspose-cells-20.11.5-java.zip]. We checked it. Thanks.

@Tesla19,

Thanks for your confirmation on the issue “CELLSJAVA-43351” and good to know that Aspose.Cells for Java v20.11.5 fixes the issue.

@Tesla19,
We have fixed the issue CELLSJAVA-43361.
By the way, which tool creates this file? There is some invalid data in the file.

The issues you have found earlier (filed as CELLSJAVA-43351,CELLSJAVA-43361) have been fixed in this update. This message was posted using Bugs notification tool by johnson.shi

@Tesla19,

This is to inform you that we have fixed the issue (“CELLSJAVA-43353”) now. We will soon provide you the fixed version after performing QA and incorporating other enhancements and fixes.

@Tesla19,

Please try our latest version/fix: Aspose.Cells for Java v20.12.5 (attached)

CELLSJAVA-43353 should be fixed now.

Let us know your feedback.
aspose-cells-20.12.5-java.zip (7.2 MB)

@Tesla19,

This is to inform you that we have also fixed your issue (logged earlier as “CELLSJAVA-43354”) now. We will soon provide you the fixed version after performing QA and incorporating other enhancements and fixes.