Posted 21 November 2017, 3:24 pm EST
We have used FP Spread container for our application and have created excel look alike sheets for our requirements.
We have used “Microsoft.Office.Interop.Excel.Application” to export to excel and then convert to PDF using “ExportAsFixedFormat” method.
We are facing issue when we export it to PDF, images which we load programmatically get distorted and hence border of image cells is not displayed and neat look of excel is destroyed.
Export to excel is working fine. Please check attached images.
We have tried:
- Cell padding before export
- Cell padding while exporting to PDF
Both of these options are not working.
Please help us to resolve the issue.
We are using Visual studio 2013 and OS: Windows 7 Enterprise
Please help.
Thank you in advance.