Spread Windows Forms 9.0 Product Documentation
VerticalPosition Enumeration
Example Example 


Specifies the vertical position of the cell or row in the component.
Syntax
'Declaration
 
Public Enum VerticalPosition 
   Inherits System.Enum
'Usage
 
Dim instance As VerticalPosition
public enum VerticalPosition : System.Enum 
Members
MemberDescription
BottomPositions the cell or row to the bottom
CenterPositions the cell or row in the center
NearestPositions the cell or row to the nearest edge
TopPositions the cell or row to the top
Remarks

For horizontal position of the cell or column, refer to the HorizontalPosition enumeration.

When using methods in FpSpread or SheetView class to move the cell into the display, if the specified cell is already visible, then the Nearest parameter does nothing If the specified cell is not visible then the sheet is scrolled just enough to make the specified cell visible. For example, setting the ActiveRowIndex and ActiveColumnIndex properties scrolls the sheet. Setting the active cell to a cell that is outside the displayed area scrolls the cell into view. Setting the active cell to a cell already in the view does nothing since the cell is already visible. The Nearest parameter only changes or moves the cells in the display if the specified cell is not displayed.

Example
FarPoint.Win.Spread.FpSpread fpSpread1 = new FarPoint.Win.Spread.FpSpread();
FarPoint.Win.Spread.SheetView shv = new FarPoint.Win.Spread.SheetView();
fpSpread1.Location = new Point(10, 10);
fpSpread1.Height = 200;
fpSpread1.Width = 400;
Controls.Add(fpSpread1);
fpSpread1.Sheets.Add(shv);
fpSpread1.ActiveSheet.SetActiveCell(15, 15);
fpSpread1.ShowActiveCell(FarPoint.Win.Spread.VerticalPosition.Center, FarPoint.Win.Spread.HorizontalPosition.Center);
Dim fpSpread1 As New FarPoint.Win.Spread.FpSpread()
Dim shv As New FarPoint.Win.Spread.SheetView()
fpSpread1.Location = New Point(10, 10)
fpSpread1.Height = 200
fpSpread1.Width = 400
Controls.Add(fpSpread1)
fpSpread1.Sheets.Add(shv)
fpSpread1.ActiveSheet.SetActiveCell(15, 15)
fpSpread1.ShowActiveCell(FarPoint.Win.Spread.VerticalPosition.Center, FarPoint.Win.Spread.HorizontalPosition.Center)
Inheritance Hierarchy

System.Object
   System.ValueType
      System.Enum
         FarPoint.Win.Spread.VerticalPosition

Requirements

Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows Server 2012 R2, Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8, Windows 8.1, Windows 10

See Also

Reference

FarPoint.Win.Spread Namespace
ShowActiveCell Method (FpSpread Class)
ShowCell Method (FpSpread Class)
ShowRow Method (FpSpread Class)

User-Task Documentation

Customizing the Position in the Display

 

 


Copyright © GrapeCity, inc. All rights reserved.