We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. (Last updated on: November 16, 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

Cell size is not fitting using the ExcelToPdfConverter

Thread ID:

Created:

Updated:

Platform:

Replies:

120693 Oct 3,2015 01:51 PM UTC Oct 8,2015 11:45 AM UTC WPF 5
loading
Tags: XlsIO
Harald Dobner
Asked On October 3, 2015 01:51 PM UTC

Hi,
i am trying to convert an excel file in a pdf. But it does not look similar. I have tried the option LayoutOptions.FitAllColumnsOnOnePage. The result is a little bit better, but then the cell hight and wordwrap is still the same as without the option LayoutOptions.FitAllColumnsOnOnePage. That does not look good and waste a lot of paper.
Can you help me to make the pdf look more then the pdf which can be generated from Excel itself.
I simply want to print out an excel file as pdf exactly as it is, without doing some configuration or compensating layout differences.
Can you help me with my issue?
Thanks a lot
Harald

Attachment: SyncfusionCellFitting_1e87b5eb.zip

Mathu Mohan Vijayakumar [Syncfusion]
Replied On October 5, 2015 12:17 PM UTC

Hi Harald,

Thank you for using Syncfusion products.

We are unable to reproduce the issue. So we have prepared a simple sample for your reference which can be downloaded in the below link.

Sample Link:

http://www.syncfusion.com/downloads/support/forum/120693/ze/XlsIO_Sample646317453.zip

We request you to check the sample with your input file and if the issue still exists, kindly share us your assembly version and the modified sample file. This will be helpful to investigate further on this and provide a prompt solution at the earliest.

Regards,

Mathu Mohan V A             


Harald Dobner
Replied On October 6, 2015 05:44 AM UTC

Thank you for your answer.

You can see the problem on your converter sample. Please see the example in the attachment. 

http://asp.syncfusion.com/demos/reporting/xlsio/Product%20Showcase/ExcelToPDF/CS/ExcelToPDF.aspx 

Please look in Line A4. The hight in line A4 is not fitting. Where does the optional space come from? 

Thank you for your help.


Attachment: SyncfusionCellFitting_37e5ec3f.zip

Sudha Ramachandran [Syncfusion]
Replied On October 7, 2015 11:17 AM UTC

Hi Harald,

 

Please find the details below.

 

Please look in Line A4. The hight in line A4 is not fitting.

Are you referring the blank cell A4?

Where does the optional space come from? 

We don’t find any noticeable space issue in the output files as shown in the below screenshots. Also the screenshots (shared by you in the previous post) seem to differ from the excel file provided. Please provide the issue reproducing file along with your working working version, so as to provide you a prompt solution.

 

Screenshots:

http://www.syncfusion.com/downloads/support/directtrac/general/CELLSI~1-725419013.ZIP

 

 

Regards,

Sudha R


Harald Dobner
Replied On October 7, 2015 08:27 PM UTC

Hi,

Thank you for your answer. I understand that is difficult to understand without a good example.

Please look in the excelfile cell E73. The font in the pdf is a little bit smaller then in the excel file. So the text in the excel cell fits in 6 lines. The same text in the pdf fits in 4 lines because of the smaller font. But in the pdf cell is still space for 6 lines of text. So the hight is two lines to high and there is a ugly whitespace in the cell. You can see the same effect in Excel cell E78 and E79. Please look in the attachment for more info.

The pdf in the attachment is generated with your converter example under the url http://asp.syncfusion.com/demos/reporting/xlsio/Product%20Showcase/ExcelToPDF/CS/ExcelToPDF.aspx I dont know what version the software on your server is. In my develop environment I’m using the following versions:

Syncfusion.ExcelToPDFConverter.Base 13.1450.0.21

Syncfusion.XlsIO.Base 13.1450.0.21

Same problem.

Thank you for your help.

Regards

 

Harald


Attachment: sync_16c1a2ea.zip

Mathu Mohan Vijayakumar [Syncfusion]
Replied On October 8, 2015 11:45 AM UTC

Hi Harald,

Please find the details below.

The issues in “E78 ” and “E79”

These issues have been already fixed in our latest version 13.3.0.7 where Excel To PDF conversion has been enhanced. So, we strongly recommend you to upgrade to our latest version (13.3.0.7), which has more features and enhancements. This is available for download under the following link.

Latest Version:

http://www.syncfusion.com/downloads/latest-version

Issue in “E73”

We were able to reproduce this issue and the fix for this will be included in our main release 13.4 which will be available by the mid of December 2015. Also we have created an incident internally to have follow-up on this defect.



Regards,
Mathu Mohan V A

CONFIRMATION

This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

Please sign in to access our forum

or the page will be automatically redirected to sign-in page in 10 seconds.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon

;