TdxSpreadSheetTableView.OptionsPrint Property

Provides access to all Table View worksheet’s print settings.

Declaration

property OptionsPrint: TdxSpreadSheetTableViewOptionsPrint read; write;

Property Value

Type
TdxSpreadSheetTableViewOptionsPrint

Remarks

You can use this property to customize all print-related settings for each individual worksheet in the opened spreadsheet document. For instance, you can set custom horizontal and vertical page breaks via the OptionsPrint.Pagination property and select the required paper format via the OptionsPrint.Page.Paper property. Refer to the TdxSpreadSheetTableViewOptionsPrint class description for detailed information on each group of available worksheet print settings.

You can allow end-users to customize most of these worksheet print settings via the dedicated “Page Setup” dialog by linking the MorePageMargins, MorePaperSizes, and/or PrintTitles command to elements of your UI.

The Spreadsheet and Report Designer controls can save and restore individual worksheet print settings to/from a spreadsheet document file. To be able to print a document using these settings via the ExpressPrinting System, you need to create a document-based (TdxSpreadSheetDocumentBasedReportLink) instead of a basic (TdxSpreadSheetReportLnk) report link in the component printer.

Note

All settings accessible via the OptionsPrint property can persist only in an XLSX or XLTX file. Other supported spreadsheet document formats are unable to store specific print-related worksheet settings. Refer to the individual print setting descriptions for more information.