HorizontalGridLine プロパティ (ColumnFooter)

列ヘッダの水平方向のグリッド線を取得または設定します。

構文

Visual Basic
C#

'宣言
 
Public Property HorizontalGridLine As GridLine

public GridLine HorizontalGridLine {get; set;}

使用例

次のサンプルコードは、列フッタを作成します。

C#
Visual Basic

fpSpread1.VisualStyles = FarPoint.Win.VisualStyles.Off;
fpSpread1.Sheets[0].RowCount = 10;
fpSpread1.Sheets[0].ColumnCount = 15;
// Show the footer.
fpSpread1.Sheets[0].ColumnFooter.Visible = true;
fpSpread1.Sheets[0].ColumnFooter.RowCount = 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].ColumnFooter.HorizontalGridLine = gl; 
//new FarPoint.Win.Spread.GridLine(FarPoint.Win.Spread.GridLineType.Flat, Color.Crimson);
fpSpread1.Sheets[0].ColumnFooter.VerticalGridLine = 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).ColumnFooter.Visible = True
fpSpread1.Sheets(0).ColumnFooter.RowCount = 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).ColumnFooter.HorizontalGridLine = gl 
'New FarPoint.Win.Spread.GridLine(FarPoint.Win.Spread.GridLineType.Flat, Color.Crimson)
fpSpread1.Sheets(0).ColumnFooter.VerticalGridLine = 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)

参照

ColumnFooter クラス
 ColumnFooter メンバ