FarPoint.Win.SpreadJ アセンブリ > FarPoint.Win.Spread 名前空間 > SheetView クラス : AddColumnFooterSpanCell メソッド |
'Declaration Public Sub AddColumnFooterSpanCell( _ ByVal row As Integer, _ ByVal column As Integer, _ ByVal rowCount As Integer, _ ByVal columnCount As Integer _ )
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"; fpSpread1.Sheets[0].AddColumnFooterSpanCell(0, 0, 1, 2); //fpSpread1.Sheets[0].ClearColumnFooterSpanCells();
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 FpSpread1.Sheets(0).AddColumnFooterSpanCell(0, 0, 1, 2) 'FpSpread1.Sheets(0).ClearColumnFooterSpanCells()