Log In
Home
Support
Demos
Documentation
Blogs
Training
Webinars
[Expand]General Information
[Collapse]WinForms Controls
  Prerequisites
 [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]Pivot Grid
  [Expand]Tree List
  [Expand]Chart Control
  [Expand]Diagrams
  [Expand]Gauges
  [Expand]Map Control
  [Expand]Scheduler
  [Collapse]Spreadsheet
   [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]Charting Overview
    Printing
    Events
   [Expand]Mail Merge Overview
    Protection
    Find and Replace
   [Expand]Visual Elements
    Services
   [Expand]Shortcuts
   [Collapse]Examples
    [Expand]Files
    [Expand]Workbooks
    [Expand]Worksheets
    [Expand]Rows and Columns
    [Expand]Cells
    [Expand]Formulas
    [Expand]Import and Export Data
    [Expand]Data Binding
    [Expand]Mail Merge
    [Expand]Formatting Cells
    [Expand]Conditional Formatting
    [Expand]Group Data
    [Expand]Filter Data
    [Expand]Tables
    [Expand]Pivot Tables
    [Collapse]Printing
      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: Print Titles on a Worksheet
    [Expand]Pictures
    [Expand]Charts
    [Expand]Protection
    [Expand]Customization
  [Expand]Rich Text Editor
  [Expand]Spell Checker
  [Expand]Form Layout Managers
  [Expand]Navigation Controls
  [Expand]Printing-Exporting
  [Expand]PDF Viewer
   Reporting
  [Expand]Snap
  [Expand]TreeMap 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]Document Server
[Expand]Reporting
[Expand]Report Server
[Expand]Dashboard
[Expand]eXpressApp Framework
[Expand]CodeRush
[Expand]CodeRush Classic
[Expand]Cross-Platform Core Libraries
[Expand]Tools and Utilities
 End-User Documentation

How to: Specify Print Settings

Show Me

A complete sample project is available in the DevExpress Code Examples database at http://www.devexpress.com/example=E4655.

This example demonstrates how set print options to create the printout as required.

To set general page options, specify the WorksheetView properties. The Active view for the worksheet is accessible via the Worksheet.ActiveView property. Worksheet View enables you to set orientation, margins and paper size settings, among others. View settings are used when a worksheet is being printed.

Worksheet printing options is a set of more print-specific options accessible via the Worksheet.PrintOptions property.

To scale the content to fit in pages, set the WorksheetPrintOptions.FitToPage property to true and specify the desired number of pages by width (WorksheetPrintOptions.FitToWidth property) or by height (the WorksheetPrintOptions.FitToHeight property). You can scale the content arbitrarily by specifying the scale percentage using the WorksheetPrintOptions.Scale property, the WorksheetPrintOptions.FitToPage property is false in this case.

Other options include printing gridlines (the WorksheetPrintOptions.PrintGridlines property), printing in color or black-and-white (the WorksheetPrintOptions.BlackAndWhite property), and more.

Note

Not all worksheet printing options are supported when printing a SpreadsheetControl document using a PrintableComponentLink.

View settings and worksheet printing options are stored in a worksheet file, so you can use Microsoft Excel or other spreadsheet application to load a document from a file and print it without the need to additionally specify print options.

How would you rate this topic?​​​​​​​