Fit All Columns on One Page

How to set "Page Setup" scaling property to "Fit All Columns on One Page" in code?
It`s possible set same property to "Fit Sheet on One Page".. ("currentSheet.PageSetup.IsFitToPage = true;")

I`m using Excel 2010




2 Replies

MM Manikandan M Syncfusion Team April 13, 2012 01:05 PM UTC

Hi,

Thanks for using Syncfusion products.

We currently does not provide the support for setting "Fit All Columns on Page" in XlsIO. Please use the property "FitToPagesWide" of PageSetup to fit sheet on one page.

Code Snippet:
sheet.PageSetup.FitToPagesWide= 1;

Thanks,
Manikandan.M



MM Manikandan M Syncfusion Team April 13, 2012 01:10 PM UTC

Hi Janis,

Please ignore our previous update.

Thanks for using Syncfusion products.

We currently does not provide the support for setting "Fit All Columns on Page" in XlsIO. Please use the property "FitToPagesWide" of PageSetup to fit sheet on one page.

Code Snippet:
sheet.PageSetup.FitToPagesWide= 1;

Thanks,
Manikandan.M



Loader.
Up arrow icon