MESCIUS SPREAD for Windows Forms 17.0J
ColumnFooterRowCount プロパティ

シートの列フッタ内の行数を取得または設定します。
構文
'Declaration
 
Public Property ColumnFooterRowCount As Integer
public int ColumnFooterRowCount {get; set;}
例外
例外説明
System.ArgumentOutOfRangeException 指定された行数が範囲外です。有効な値は0〜256です。
次のサンプルコードは、列フッタを作成します。
fpSpread1.VisualStyles = FarPoint.Win.VisualStyles.Off;
fpSpread1.Sheets[0].RowCount = 10;
fpSpread1.Sheets[0].ColumnCount = 15;
// Show the footer.
fpSpread1.Sheets[0].ColumnFooterVisible = true;
fpSpread1.Sheets[0].ColumnFooterRowCount = 2;
fpSpread1.Sheets[0].ColumnFooter.DefaultStyle.Renderer = new FarPoint.Win.Spread.CellType.ColumnHeaderRenderer();

FarPoint.Win.Spread.GridLine gl = new FarPoint.Win.Spread.GridLine(FarPoint.Win.Spread.GridLineType.Raised, Color.Crimson, Color.Goldenrod, Color.BurlyWood);
fpSpread1.Sheets[0].ColumnFooterHorizontalGridLine = gl; 
//new FarPoint.Win.Spread.GridLine(FarPoint.Win.Spread.GridLineType.Flat, Color.Crimson);
fpSpread1.Sheets[0].ColumnFooterVerticalGridLine = gl; 
//new FarPoint.Win.Spread.GridLine(FarPoint.Win.Spread.GridLineType.Flat, Color.BurlyWood);
fpSpread1.Sheets[0].ColumnFooterSheetCornerHorizontalGridLine = gl; 
//new FarPoint.Win.Spread.GridLine(FarPoint.Win.Spread.GridLineType.Flat, Color.Crimson);
fpSpread1.Sheets[0].ColumnFooterSheetCornerVerticalGridLine = gl; 
//new FarPoint.Win.Spread.GridLine(FarPoint.Win.Spread.GridLineType.Flat, Color.BurlyWood);  
fpSpread1.VisualStyles = FarPoint.Win.VisualStyles.Off
fpSpread1.Sheets(0).RowCount = 10
fpSpread1.Sheets(0).ColumnCount = 15

fpSpread1.Sheets(0).ColumnFooterVisible = True
fpSpread1.Sheets(0).ColumnFooterRowCount = 2
fpSpread1.Sheets(0).ColumnFooter.DefaultStyle.Renderer = New FarPoint.Win.Spread.CellType.ColumnHeaderRenderer()

Dim gl As New FarPoint.Win.Spread.GridLine(FarPoint.Win.Spread.GridLineType.Raised, Color.Crimson, Color.Goldenrod, Color.BurlyWood)
fpSpread1.Sheets(0).ColumnFooterHorizontalGridLine = gl 
'New FarPoint.Win.Spread.GridLine(FarPoint.Win.Spread.GridLineType.Flat, Color.Crimson)
fpSpread1.Sheets(0).ColumnFooterVerticalGridLine = gl 
'New FarPoint.Win.Spread.GridLine(FarPoint.Win.Spread.GridLineType.Flat, Color.BurlyWood)
fpSpread1.Sheets(0).ColumnFooterSheetCornerHorizontalGridLine = gl 
'New FarPoint.Win.Spread.GridLine(FarPoint.Win.Spread.GridLineType.Flat, Color.Crimson)
fpSpread1.Sheets(0).ColumnFooterSheetCornerVerticalGridLine = gl 
'New FarPoint.Win.Spread.GridLine(FarPoint.Win.Spread.GridLineType.Flat, Color.BurlyWood)
参照

SheetView クラス
SheetView メンバ

 

 


© MESCIUS inc. All rights reserved.