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.

Wed Jan 27, 2016 9:09 am

Hi

I am using the convert Excel to PDF functionality as described below in how to article.


My Excel file has a print area set which works fine in excel. if I print the excel file it formats perfectly. However, when the file is converted to PDF using above method the print area is no longer correct and the page breaks wherever it wants to.

I am using spire.office_2.12.8

can you help?

Mark

license.manager
 
Posts: 12
Joined: Thu Jul 09, 2015 11:07 am

Thu Jan 28, 2016 1:39 am

Hi Mark,

Thanks for your posting.
To help us work out solution to resolve your issue, please share your excel document for investigation.
Thank you. You can also send it to [email protected].

Best Regards,
Amy
E-iceblue support team
User avatar

amy.zhao
 
Posts: 3051
Joined: Wed Jun 27, 2012 8:50 am

Thu Jan 28, 2016 8:42 am

Hi Amy

I will send you a response with examples via email. it will be from
thanks

Mark
Last edited by license.manager on Mon Feb 01, 2016 11:04 am, edited 1 time in total.

license.manager
 
Posts: 12
Joined: Thu Jul 09, 2015 11:07 am

Thu Jan 28, 2016 9:21 am

Hello,

Thanks, we have received the email you sent, and we will look into it and update to you ASAP.

Sincerely,
Gary
E-iceblue support team
User avatar

Gary.zhang
 
Posts: 1380
Joined: Thu Apr 04, 2013 1:30 am

Fri Jan 29, 2016 2:57 am

Hi Mark,

I have forwarded page break issue and background of checkbox lost issue you mentioned in e-mail to our dev team, sorry for the inconvenience that the issues brought to you. We will inform you when they are resolved.

Best Regards,
Amy
E-iceblue support team
User avatar

amy.zhao
 
Posts: 3051
Joined: Wed Jun 27, 2012 8:50 am

Mon May 02, 2016 9:13 pm

Has there been any update on this issue? I'm experiencing the same issue where page breaks that are defined in Excel are not being retained when saving to PDF.

dkeller216
 
Posts: 3
Joined: Fri Apr 15, 2016 12:29 pm

Tue May 03, 2016 2:26 am

Hello,

Thanks for your feedback.
Please download the version (http://www.e-iceblue.com/downloads/Temp ... 7.9.67.zip) and have a try. If there is still the issue after testing, please share your document with us for investigation. Thanks.

Best Regards,
Caroline
E-iceblue support team
User avatar

caroline.zhang
 
Posts: 291
Joined: Mon Mar 07, 2016 9:22 am

Tue May 03, 2016 12:51 pm

That still didn't work for us. I'll need to share the file with you privately since it contains proprietary info.

dkeller216
 
Posts: 3
Joined: Fri Apr 15, 2016 12:29 pm

Wed May 04, 2016 1:11 am

Hello,

Thanks for your reply.
Please send your file to our email ([email protected]).

Thanks and Best Regards,
Caroline
E-iceblue support team
User avatar

caroline.zhang
 
Posts: 291
Joined: Mon Mar 07, 2016 9:22 am

Wed May 04, 2016 2:11 pm

It turns out my code was inadvertently setting this property:

workbook.ConverterSetting.SheetFitToPage = true;

I totally missed that previously. But when I removed that line my page breaks are working perfectly now when I save to PDF.

dkeller216
 
Posts: 3
Joined: Fri Apr 15, 2016 12:29 pm

Fri May 06, 2016 5:04 am

Hi,

Thanks for your kind reply.
If there is any question, welcome to get it back to us again.

Sincerely,
Caroline
E-iceblue support team
User avatar

caroline.zhang
 
Posts: 291
Joined: Mon Mar 07, 2016 9:22 am

Mon Jul 11, 2016 3:13 pm

Hi, can you advise when this problem will be resolved. I still face this issue even after downloading latest version.

license.manager
 
Posts: 12
Joined: Thu Jul 09, 2015 11:07 am

Tue Jul 12, 2016 3:29 am

Hi,

Our Dev team is investigating your issue, page break issue is related to many issues, we are resolving it step by step. And Spire.XLS doesn't support the background color of checkboxes at present, it is new featrue. So we need more time to resolve it. Anyway, we will try our best to resolve your issue, once there is any progress, we will inform you. Sorry for inconvenience and thanks for your comprehension.

Sincerely,
Betsy
E-iceblue support team
User avatar

Betsy
 
Posts: 802
Joined: Mon Jan 19, 2015 6:14 am

Return to Spire.XLS