We found another problem with Excel 2 PDF conversion.
As you can see in the attached samples, there are some pages of plain text splitted into 2 columns (starting with the 2nd page of pdf or the 2nd sheet in xls).
There is a big difference between printed versions of this text from pdf and
xls: a lot of blank spaces between text lines in the same paragraph and sometimes text overflows the next paragraph.
If your issue still occurs, then please highlight your issues in a screenshot with red circles around it or you may add comments in your output pdf highlighting the issues and attach it here for our reference. We will look into it and help you asap.
Thank you for sharing the screenshots, however, we are still not sure what problem(s) you are referring to. If you are talking about the horizontal spaces between the words then they are visible in Excel view as well therefore PDF rendering is correct in that reference. Anyway, we have noticed that you are missing a font in your environment by the name “Arial Cyr” which is used in your spreadsheet. By installing/placing the TTF of the aforementioned font in your environment (and setting the font location at the start of your application) will give better result than what you are getting right now. Please check attached snapshots as well as the resultant PDF which was generated after installing the “Arial Cyr” font in Windows environment. You may compare the fonts used in this PDF against the one you shared in your original post. You will notice that “Arial Cyr” font was not embedded in your shared PDF. Please also check if you are able to see any problem in the attached PDF. If yes, please highlight the problematic areas for better understanding of the scenario.
Regarding the error caused by Acrobat Reader while loading the Aspose.Cells’ generated PDF, we are able to replicate it therefore we have logged it as CELLSJAVA-41722 for further investigation. Could you please confirm if you are facing the same error?
Thank you for highlighting the problematic areas. We have logged an investigative ticket with Id CELLSJAVA-41723 in our bug tracking system, requesting the concerned member of the product team to schedule a detailed analysis of this scenario. Please spare us little time to schedule the investigation and get back with updates in this regard.
This is to update you that we have started investigating the matter logged earlier as CELLSJAVA-41723 and we require the Arial Cyr font from your machine. Please note, the cell text horizontal alignment is justify, when rendering to PDF, some words of a line are put to next line therefore the space between the words of line is bigger.
Thank you for sharing the font file. I have forwarded it to the concerned member of the product team for investigation. As soon as we get further updates in this regard, we will post here for your kind reference.
The result looks prettier but still it’s not perfect.
As you can see in attached file (second page), space between text lines differs from paragraph to paragraph. Some text overflows the line, that was designed to be the last line for this text.
Sample places are marked on the screenshot attached.
We have converted your sample while using the recent revision of Aspose.Cells for Java 8.7.0.3 and we are able to observe the same issues as highlighted in your snapshot. We have logged our observations to the ticket CELLSJAVA-41723 for product team’s review. As soon as we get more updates, we will share here for your kind reference.
I believe there is some confusion regarding the notification about the fix. Please note, only the issue logged earlier as CELLSJAVA-41722 (Acrobat Reader shows error while loading Aspose.Cells’ generated PDF) has been resolved with latest revision of the Aspose.Cells for Java 8.7.1. Whereas the main issue about the layout of the resultant PDF (CELLSJAVA-41723) is still unresolved. We are currently working on this issue and we hope to provide a fix very soon.
It is to inform you that we have fixed your issue CELLSJAVA-41723 now. We will soon provide the fix after performing QA and including other enhancements and fixes.
A new version of Aspose produces much prettier PDF than before. But we still can find some problems with a different text density on the same page. Unfortunately it’s inacceptable to be used in our production environment.
“Bad” places are marked by the red line in the attachment.
I have reopened the ticket CELLSJAVA-41723 and have requested the concerned member of the product team to find space for improvements as per your provided snapshots. We will keep you posted with updates in this regard.
Please try our latest version: Aspose.Cells for Java v8.7.2.2, we have fixed
all problems except the problem in the last page as highlighted in
the screenshot (attached with this post). The cell X121 and X123 have a blank line
at the end of the source file.