PowerTools SPREAD for Windows Forms 10.0J
ColumnFooterEnhanced フィールド


列フッタセルの拡張スタイルを表します。
構文
'Declaration
 
Public Shared ReadOnly ColumnFooterEnhanced As NamedStyle
'使用法
 
Dim value As NamedStyle
 
value = DefaultStyleCollection.ColumnFooterEnhanced
public static readonly NamedStyle ColumnFooterEnhanced
次のサンプルコードは、列フッタスタイルを設定します。
fpSpread1.Sheets[0].ColumnCount = 15;
// Show the column footer.
fpSpread1.Sheets[0].ColumnFooter.Visible = true;
fpSpread1.Sheets[0].ColumnFooter.RowCount = 2;
fpSpread1.Sheets[0].ColumnFooter.DefaultStyle.ForeColor = Color.Purple;
fpSpread1.Sheets[0].ColumnFooter.Columns[12].HorizontalAlignment = FarPoint.Win.Spread.CellHorizontalAlignment.Left;
fpSpread1.Sheets[0].ColumnFooter.Cells[0, 12].RowSpan = 2;
fpSpread1.Sheets[0].ColumnFooter.Cells[0, 0].Value = "test";
FarPoint.Win.Spread.NamedStyle backstyle = new FarPoint.Win.Spread.NamedStyle("NewStyle", "ColumnFooterEnhanced");
fpSpread1.NamedStyles.Add(backstyle);
FarPoint.Win.Spread.SheetView sheetView = fpSpread1.ActiveSheet;
FarPoint.Win.Spread.SpreadSkin skin = new FarPoint.Win.Spread.SpreadSkin();
skin.ColumnFooterDefaultStyle = backstyle;
fpSpread1.Skin = skin;
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.ForeColor = Color.Purple
FpSpread1.Sheets(0).ColumnFooter.Columns(12).HorizontalAlignment = FarPoint.Win.Spread.CellHorizontalAlignment.Left
FpSpread1.Sheets(0).ColumnFooter.Cells(0, 12).RowSpan = 2
FpSpread1.Sheets(0).ColumnFooter.Cells(0, 0).Value = "test
Dim backstyle As New FarPoint.Win.Spread.NamedStyle("NewStyle", "ColumnFooterEnhanced")
FpSpread1.NamedStyles.Add(backstyle)
Dim sheetview As FarPoint.Win.Spread.SheetView = FpSpread1.ActiveSheet
Dim skin As New FarPoint.Win.Spread.SpreadSkin()
skin.ColumnFooterDefaultStyle = backstyle
FpSpread1.Skin = skin
参照

DefaultStyleCollection クラス
DefaultStyleCollection メンバ

 

 


© 2004-2017, GrapeCity inc. All rights reserved.