The requested page is not available for the requested platform. You are viewing the content for .NET Framework 4.5.2+ platform.
.NET Framework 4.5.2+
.NET Framework 4.5.2+
.NET Standard 2.0+
.NET Core 3.0+
Row

WorksheetPrintTitleOptions.Columns Property

Gets or sets specific columns to be repeated on every printed page.

Namespace: DevExpress.Spreadsheet

Assembly: DevExpress.Spreadsheet.v19.2.Core.dll

Declaration

CellRange Columns { get; set; }
Property Columns As CellRange
CellRange Columns { get; set; }
Property Columns As CellRange
CellRange Columns { get; set; }
Property Columns As CellRange

Property Value

Type Description
CellRange

A CellRange object that specifies worksheet columns repeated on every printed page.

If the specified cell range is not a continuous interval of entire columns, an exception is raised.

Property Value

Type Description
CellRange

A CellRange object that specifies worksheet columns repeated on every printed page.

If the specified cell range is not a continuous interval of entire columns, an exception is raised.

Property Value

Type Description
CellRange

A CellRange object that specifies worksheet columns repeated on every printed page.

If the specified cell range is not a continuous interval of entire columns, an exception is raised.

Remarks

Use the Columns and WorksheetPrintTitleOptions.Rows properties to set or obtain rows and columns that should appear on every printed page. Note that you can also use the WorksheetPrintTitleOptions.SetRows and WorksheetPrintTitleOptions.SetColumns methods to repeat specific rows and columns on every page when printing. For an example, refer to the How to: Print Titles on a Worksheet document.

If you don't want column headings to appear on every printed page of your worksheet, set the Columns property to null (Nothing in Visual Basic), or use the WorksheetPrintTitleOptions.Clear method to remove all print titles specified in the worksheet.

See Also