Log In
Home
Support
Demos
Documentation
Blogs
Training
Webinars
[Expand]General Information
[Expand]WinForms Controls
[Collapse]ASP.NET Controls and MVC Extensions
 [Expand]Prerequisites
 [Expand]What's Installed
 [Expand]Common Concepts
 [Collapse]ASP.NET WebForms Controls
  [Expand]Reporting
  [Expand]Chart Control
  [Expand]Grid View
  [Expand]Card View
  [Expand]Vertical Grid
  [Collapse]Spreadsheet
   [Expand]Product Information
   [Collapse]Concepts
    [Expand]Spreadsheet Document
     Supported Formats
     Import and Export
    [Expand]Cell Basics
    [Expand]Spreadsheet Formulas
     Defined Names
     Data Validation
    [Expand]Data Presentation
    [Expand]Charting
     Printing
    [Expand]Mail Merge
     Protection
     Keyboard Shortcuts
   [Expand]Visual Elements
  [Expand]Rich Text Editor
  [Expand]Image and Data Browsing
  [Expand]Docking and Popups
  [Expand]Site Navigation and Layout
  [Expand]File Management
  [Expand]Multi-Use Site Controls
  [Expand]Scheduler
  [Expand]HTML Editor
  [Expand]Pivot Grid
  [Expand]Tree List
  [Expand]Gauges
  [Expand]Data Editors
  [Expand]Spell Checker
  [Expand]Query Builder
 [Expand]ASP.NET MVC Extensions
 [Expand]Localization
 [Expand]Redistribution and Deployment
  Get More Help
 [Expand]API Reference
[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

Printing

The ASPxSpreadsheet control provides two basic approaches to printing: you can print a document from code using the appropriate API methods and properties, or using the spreadsheet Ribbon UI. Note that the printing command is located in the Common Ribbon page group of the File tab.

The document includes the following sections.

Expanded Print a Workbook using the Print Dialog

  • Invoke the Print dialog using the Ribbon UI

    To print a document and set print options, click the Print button in the Common group, or press CTRL+P.

    In the invoked Print dialog box, specify the required settings such as printer name, the number of document copies and the number of pages you wish to print, and click Print.

Expanded Specify Print Options

  • Via the Ribbon UI

    Before printing a workbook, an end-user can specify print settings for each worksheet separately using the Page Layout ribbon tab of the ASPxSpreadsheet control. Use buttons located in the Page Setup group to specify page margins, document orientation, and paper size. To set more specific printout settings (such as print scaling, page order, header and footer options, etc.), click the Margings - Custom Margins... command to invoke the Page Setup dialog.

  • In code

    To specify print options, use properties of the WorksheetView object, accessible using the Worksheet.ActiveView property. The WorksheetView enables you to specify general page options such as orientation, margins and paper size settings. More print-specific options can be specified using the properties of the WorksheetPrintOptions object.

Expanded See Also

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