FarPoint.Win.SpreadJ アセンブリ > FarPoint.Win.Spread 名前空間 > DefaultStyleCollection クラス : ColumnFooterFlat フィールド |
'Declaration Public Shared ReadOnly ColumnFooterFlat As NamedStyle
'使用法 Dim value As NamedStyle value = DefaultStyleCollection.ColumnFooterFlat
public static readonly NamedStyle ColumnFooterFlat
fpSpread1.Sheets[0].RowCount = 10; 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", "ColumnFooterFlat"); 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", "ColumnFooterFlat") 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