PageMaxAlign Property

Gets or sets whether to show the maximum number of rows on the last page.

Syntax

Visual Basic
C#

'Declaration
 
Public Property PageMaxAlign As Boolean

'Usage
 
Dim instance As SheetView
Dim value As Boolean
 
instance.PageMaxAlign = value
 
value = instance.PageMaxAlign

public bool PageMaxAlign {get; set;}

Property Value

Boolean: true to display the maximum number; false otherwise

Remarks

When this property is set to true, the last page displays the PageSize of rows, even though some of these rows already might have been displayed in the previous page. When this property is set to false, the last page displays only the rows that were not displayed in the previous page.

Example

This example only displays the rows on the last page that were not displayed on the previous page.

FpSpread1.ActiveSheetView.RowCount = 54;
FpSpread1.ActiveSheetView.PageMaxAlign = false;

Visual Basic

FpSpread1.ActiveSheetView.RowCount = 54
FpSpread1.ActiveSheetView.PageMaxAlign = False

Reference

SheetView Class
SheetView Members

User-Task Documentation

Customizing the Page Size (Rows to Display)