How to: Show a Print Preview Form for a Workbook

  • 2 minutes to read

This example demonstrates how to use the DevExpress Printing Library to show a Print Preview for a document loaded into a Workbook instance (workbook, in this example). To do this, follow the steps below:

using DevExpress.Spreadsheet;
using DevExpress.XtraPrinting;
            // Invoke the Print Preview dialog for the workbook.
            using (PrintingSystem printingSystem = new PrintingSystem()) {
                using (PrintableComponentLink link = new PrintableComponentLink(printingSystem)) {
                    link.Component = workbook;

Calculate Formulas Before Print Operation

The default calculation mode for a Workbook is Manual. This mode implies that the Spreadsheet does not calculate formulas before it generates a printout. Call the Workbook.Calculate or Workbook.CalculateFull method to calculate all formulas in the workbook.

See Also