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 Mar 01, 2017 9:53 pm

Hello,
How can I set "Ignore Print Area" checkbox, using your library ?
Excel 2013

Ignore print area.png
Ignore print area.png (696.39 KiB) Viewed 1324 times

alex2015
 
Posts: 2
Joined: Wed Mar 01, 2017 9:34 pm

Thu Mar 02, 2017 2:14 am

Dear alex2015,

Thanks for your inquiry.
Please use following code to ignore the print area.
Code: Select all
workbook.Worksheets[0].PageSetup.PrintArea = "";

If there is any question, please let me know.

Sincerely,
Betsy
E-iceblue support team
User avatar

Betsy.jiang
 
Posts: 3099
Joined: Tue Sep 06, 2016 8:30 am

Thu Mar 02, 2017 6:42 am

Dear Betsy.jiang

This method does not work in Free Spire.XLS for .NET 7.9.1

Method work only paid version library ?

alex2015
 
Posts: 2
Joined: Wed Mar 01, 2017 9:34 pm

Thu Mar 02, 2017 9:27 am

Dear alex2015,

Thanks for your information.
Yes, the method only works in paid version. So please use Spire.PDF Pack(Hot Fix) Version:3.8.193.
If there is still issue with the version, please provide us the sample file for testing.

Thanks,
Betsy
E-iceblue support team
User avatar

Betsy.jiang
 
Posts: 3099
Joined: Tue Sep 06, 2016 8:30 am

Return to Spire.XLS