We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. (Last updated on : Nov 16th 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

Excel Printing

Thread ID:

Created:

Updated:

Platform:

Replies:

37806 Nov 30,2005 04:10 PM UTC Dec 1,2005 07:15 AM UTC WinForms 1
loading
Tags: XlsIO
Eddie Mijares
Asked On November 30, 2005 04:10 PM UTC

I am using the following code and it is not printing on 1 page wide. Is this implememented? Thanks, Eddie sheet.PageSetup.Orientation = ExcelPageOrientation.Landscape; sheet.PageSetup.PrintArea="$A$1:$N$11"; sheet.PageSetup.CenterHorizontally=true; sheet.PageSetup.CenterVertically=true; sheet.PageSetup.FitToPagesWide = 1;

Administrator [Syncfusion]
Replied On December 1, 2005 07:15 AM UTC

Hi Eddie, Your code is correct but it does not work since there is a bug with setting FitToPagesWide = 1. A workaround for this issues is to set the FitToPagesWide = 2 and then set FitToPagesWide = 1. Please use this workaround till this issue is fixed. Workaround code //Insert Sample Data for(int i=1;i<=30;i++) { for(int j=1;j<30;j++) { sheet.Range[i,j].Text = sheet.Range[i,j].AddressLocal; } } //Set Print Properties sheet.PageSetup.Orientation = ExcelPageOrientation.Landscape; sheet.PageSetup.PrintArea="$A$1:$N$11"; sheet.PageSetup.CenterHorizontally=true; sheet.PageSetup.CenterVertically=true; //Workaround for Bug with setting FitToPagesWide = 1 sheet.PageSetup.FitToPagesWide = 2; sheet.PageSetup.FitToPagesWide = 1; Workaround sample F37806FitPagesWide.zip I have also filed a bug report with the development team http://www.syncfusion.com/support/issues/xlsio/Default.aspx?ToDo=view&questId=1131 Thanks, Stephen.

CONFIRMATION

This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon

;