Spire.XLS is a professional Excel API that enables developers to create, manage, manipulate, convert and print Excel worksheets. Get free and professional technical support for Spire.XLS for .NET, Java, Android, C++, Python.

Thu Oct 13, 2022 5:41 pm

Hello Experts,

Im converting XLSX file into PDF file using spire.xls-12.9.1 API.

Sample code, sample source file and the image of exact error highlighted are attached for your reference.

All the attached xlsx files have a same image right aligned on the page. But after conversion, this image is not displayed fully in all the converted pdf files. Attached image file (ImageIssue.png) for your reference.

I really appreciate your help on this.

Xlsx2Pdf-ImgIssue.zip
(344.05 KiB) Downloaded 84 times

UshaThavasiappan
 
Posts: 109
Joined: Sat Oct 08, 2022 9:23 am

Mon Oct 17, 2022 11:09 am

Hello,

Thanks for your feedback.
After further investigation. If you set “auto fit row height” and “auto fit column width” for worksheet in MS Excel then save file to Pdf file, the result pdf file is the same as the result pdf document generated by our products when setting “auto fit row height” and “auto fit column width”. Our product follows the Microsoft specification, so it isn’t a product bug.

Sincerely
Abel
E-iceblue support team
User avatar

Abel.He
 
Posts: 980
Joined: Tue Mar 08, 2022 2:02 am

Mon Oct 17, 2022 12:07 pm

Hello,
Thanks for your response. I will follow that discussion for solution.

UshaThavasiappan
 
Posts: 109
Joined: Sat Oct 08, 2022 9:23 am

Tue Oct 18, 2022 1:58 am

Hello,

Thanks for your feedback.
If you have any issue, just feel free to contact us.

Sincerely
Abel
E-iceblue support team
User avatar

Abel.He
 
Posts: 980
Joined: Tue Mar 08, 2022 2:02 am

Tue Oct 25, 2022 2:02 am

Hello,

Hope you are doing well.
Could you give me some feedback about your issue? Looking forward to your reply.

Sincerely
Abel
E-iceblue support team
User avatar

Abel.He
 
Posts: 980
Joined: Tue Mar 08, 2022 2:02 am

Tue Oct 25, 2022 5:03 am

Hello,
I'm partially accepting the response for my issue. Because, I'm not working for a particular source file to convert.

I have a directory full of files to convert from excel to pdf format. I do not know which file comes under autoFitColumns or autoFitRows functions.

Do you have any solution to my business need ? Please do suggest

UshaThavasiappan
 
Posts: 109
Joined: Sat Oct 08, 2022 9:23 am

Tue Oct 25, 2022 10:36 am

Hello,

Thanks for your feedback.
My colleague lisa has already responded to this question.


Sincerely
Abel
E-iceblue support team
User avatar

Abel.He
 
Posts: 980
Joined: Tue Mar 08, 2022 2:02 am

Wed Oct 26, 2022 6:08 am

Hello,
Yes, I got her reply.

Thanks

UshaThavasiappan
 
Posts: 109
Joined: Sat Oct 08, 2022 9:23 am

Thu Oct 27, 2022 7:08 am

Ok, thanks for your feedback.

Sincerely
Abel
E-iceblue support team
User avatar

Abel.He
 
Posts: 980
Joined: Tue Mar 08, 2022 2:02 am

Return to Spire.XLS