FarPoint.Win.SpreadJ アセンブリ > FarPoint.Win.Spread 名前空間 > FpSpread クラス : ShowActiveCell メソッド |
'Declaration Public Sub ShowActiveCell( _ ByVal verticalPosition As VerticalPosition, _ ByVal horizontalPosition As HorizontalPosition _ )
'使用法 Dim instance As FpSpread Dim verticalPosition As VerticalPosition Dim horizontalPosition As HorizontalPosition instance.ShowActiveCell(verticalPosition, horizontalPosition)
public void ShowActiveCell( VerticalPosition verticalPosition, HorizontalPosition horizontalPosition )
このメソッドは、アクティブセルが指定した表示位置に来るようにスプレッドシートをスクロールします。たとえば、アクティブセルをコンポーネント表示の中央に移動できます。
アクティブセルを設定するには、SetActiveCellメソッドを参照してください。
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)