Excel 2 PDF conversion big difference

Hello, dear colleagues!

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.

Can you help us to avoid these strange effects?

Hi,

Thanks for your posting and using Aspose.Cells.

Please download and try the latest version:
Aspose.Cells for Java (Latest Version) and see if it makes any difference and resolves your issue.

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.

See attached screenshots (2nd page of PDF).

One more problem, Acrobat shows an error while opening this file. Can you tell us what’s the problem with this file?

Hi Vladimir,


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?

Hello, dear colleagues.

We’ve installed Arial Cyr in the environment The result is much better but there are still problems with some cells.

We’ve highlighted these cells in yellow so you can see the difference between aspose generated file and the one generated by Excel 2010.

Hi Vladimir,


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.

Hi again,


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.

Hi,


Arial Cyr font from my machine.

Vladimir.

Hi Vladimir,


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.

Hi,

Thanks for using Aspose.Cells.

We have fixed the issue CELLSJAVA-41722.

Please download and try the latest fix: Aspose.Cells for Java (Latest Version) and let us know your feedback.

Hi, thank you for the fix.

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.

Hi Vladimir,


Thank you for sharing your feedback and snapshot.

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.

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


This message was posted using Notification2Forum from Downloads module by Aspose Notifier.
Hi!
We didn't find any changes in the result of conversion.

Can you provide us a sample code that transforms our sample xls to pdf and gives the same result as it would be in genuine Excel 2 PDF "save as"

Hi Vladimir,


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.

Hi,

Thanks for using Aspose.Cells.

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.

Hi,

Thanks for using Aspose.Cells.

Please download and try the latest fix:
Aspose.Cells for Java (Latest Version) and let us know your feedback.

Hi, guys!

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.

Looking forward to new versions :slight_smile:

Hi Vladimir,


Thank you for your valuable feedback.

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.

Hi,

Thanks for using Aspose.Cells.


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.