[Expand]General Information
[Collapse]WinForms Controls
 [Expand]What's Installed
 [Expand]Build an Application
 [Collapse]Controls and Libraries
  [Expand]Forms and User Controls
  [Expand]Messages, Notifications and Dialogs
  [Expand]Editors and Simple Controls
  [Expand]Ribbon, Bars and Menu
  [Expand]Application UI Manager
  [Expand]Docking Library
  [Expand]Data Grid
  [Expand]Vertical Grid
  [Expand]Property Grid
  [Expand]Pivot Grid
  [Expand]Tree List
  [Expand]Chart Control
  [Expand]Map Control
   [Expand]Product Information
    Product Structure
    Getting Started
   [Expand]Spreadsheet Document
    Supported Formats
   [Expand]Cell Basics
   [Expand]Spreadsheet Formulas
    Defined Names
    Data Binding
    Data Validation
   [Expand]Data Presentation
    Data Grouping
   [Expand]Pivot Table Overview
   [Expand]Shapes, Pictures, Charts
   [Expand]Mail Merge Overview
    Find and Replace
   [Expand]Visual Elements
    [Expand]Rows and Columns
    [Expand]Import and Export Data
    [Expand]Data Binding
    [Expand]Mail Merge
    [Expand]Formatting Cells
    [Expand]Conditional Formatting
    [Expand]Group Data
    [Expand]Filter Data
    [Expand]Pivot Tables
      How to: Print a Workbook
      How to: Specify Print Settings
      How to: Show a Print Preview Form for a Document
      How to: Add Headers and Footers to a Worksheet Printout
      How to: Define a Print Area
      How to: Print Titles on a Worksheet
  [Expand]Rich Text Editor
  [Expand]Spell Checker
  [Expand]Form Layout Managers
  [Expand]Navigation Controls
  [Expand]PDF Viewer
  [Expand]TreeMap Control
  [Expand]Sunburst Control
 [Expand]Common Features
  Get More Help
 [Expand]API Reference
[Expand]ASP.NET Controls and MVC Extensions
[Expand]ASP.NET Bootstrap Controls
[Expand]ASP.NET Core Bootstrap Controls
[Expand]WPF Controls
[Expand]Xamarin Controls
[Expand]Windows 10 App Controls
[Expand]Office File API
[Expand]Report and Dashboard Server
[Expand]eXpressApp Framework
[Expand]eXpress Persistent Objects
[Expand]CodeRush Classic
[Expand]Cross-Platform Core Libraries
[Expand]Tools and Utilities
 End-User Documentation
View this topic on docs.devexpress.com (Learn more)

How to: Specify Print Settings

This topic demonstrates how to fine-tune print settings for a worksheet to create a desired page layout.

A WorksheetView object's properties allow you to specify general page options. Use the Worksheet.ActiveView property to access a worksheet's active view.

Property Description
WorksheetView.Margins Defines page margins.
WorksheetView.Orientation Specifies page orientation.
WorksheetView.PaperKind Specifies paper size.

More print-specific options are available from the WorksheetPrintOptions object. To access this object, use the Worksheet.PrintOptions property.

Property Description
WorksheetPrintOptions.FitToPage Determines whether worksheet content should be scaled to fit on a specific number of pages.
WorksheetPrintOptions.FitToWidth Specifies the number of pages that a worksheet should fit on horizontally.
WorksheetPrintOptions.FitToHeight Specifies the number of pages that a worksheet should fit on vertically.
WorksheetPrintOptions.Scale Specifies the percentage by which to scale worksheet content.
WorksheetPrintOptions.PrintGridlines Specifies whether to print worksheet gridlines.
WorksheetPrintOptions.PrintHeadings Specifies whether to print row and column headings.
WorksheetPrintOptions.PrintTitles Allows you to repeat specific rows and columns on every printed page.
WorksheetPrintOptions.PageOrder Specifies the order in which worksheet pages are numbered and printed.
WorksheetPrintOptions.PageNumbering Contains page numbering options for a worksheet.
WorksheetPrintOptions.CenterHorizontally Specifies whether worksheet data should be centered horizontally on a printed page.
WorksheetPrintOptions.CenterVertically Specifies whether worksheet data should be centered vertically on a printed page.
WorksheetPrintOptions.ErrorsPrintMode Specifies how cell errors are printed.

The WorksheetPrintOptions.Draft, WorksheetPrintOptions.BlackAndWhite, WorksheetPrintOptions.NumberOfCopies and WorksheetPrintOptions.CommentsPrintMode options are not supported when printing a document from the SpreadsheetControl. They are, however, saved to a file, allowing you to use Microsoft® Excel® or another spreadsheet application to load and print a document.

Is this topic helpful?​​​​​​​