Gets a Columns object for the columns in the column footer.
Syntax
| Visual Basic (Declaration) | |
|---|
Public ReadOnly Property Columns As Columns |
| Visual Basic (Usage) |  Copy Code |
|---|
Dim instance As ColumnFooter
Dim value As Columns
value = instance.Columns |
Property Value
Columns object containing the columns
Example
This example sets up the column footer for the Spread to display different aggregate types.
| C# | Copy Code |
|---|
FpSpread1.ActiveSheetView.ColumnFooter.Visible = true;
FpSpread1.ActiveSheetView.ColumnFooter.RowCount = 2;
FpSpread1.ActiveSheetView.ColumnFooter.AlternatingRows.Item[0].BackColor = Drawing.Color.Bisque;
FpSpread1.ActiveSheetView.ColumnFooter.Cells[0, 0].BackColor = Drawing.Color.Yellow;
FpSpread1.ActiveSheetView.ColumnFooter.Columns[0].Border = new FarPoint.Web.Spread.Border(BorderStyle.Dotted, Drawing.Color.Blue);
FpSpread1.ActiveSheetView.ColumnFooter.DefaultStyle.Font.Bold = true;
FpSpread1.ActiveSheetView.ColumnFooter.Height = 30;
FpSpread1.ActiveSheetView.ColumnFooter.Rows[0].Font.Italic = true;
int i;
int j;
for (i = 0; (i <= FpSpread1.ActiveSheetView.RowCount); i++) {
for (j = 0; (j <= FpSpread1.ActiveSheetView.ColumnCount); j++) {
FpSpread1.ActiveSheetView.DataModel.SetValue(i, j, (j
+ (i * FpSpread1.ActiveSheetView.ColumnCount)));
}
}
int a = 0;
FpSpread1.ActiveSheetView.Columns[a].AggregationType = FarPoint.Web.Spread.Model.AggregationType.Avg;
FpSpread1.ActiveSheetView.ColumnFooter.Cells[0, a].Value = "Avg";
a++;
FpSpread1.ActiveSheetView.Columns[a].AggregationType = FarPoint.Web.Spread.Model.AggregationType.Count;
FpSpread1.ActiveSheetView.ColumnFooter.Cells[0, a].Value = "Count";
a++;
FpSpread1.ActiveSheetView.Columns[a].AggregationType = FarPoint.Web.Spread.Model.AggregationType.Sum;
FpSpread1.ActiveSheetView.ColumnFooter.Cells[0, a].Value = "Sum";
a++;
FpSpread1.ActiveSheetView.Columns[a].AggregationType = FarPoint.Web.Spread.Model.AggregationType.Product;
FpSpread1.ActiveSheetView.ColumnFooter.Cells[0, a].Value = "Product";
a++;
|
| Visual Basic | Copy Code |
|---|
FpSpread1.ActiveSheetView.ColumnFooter.Visible = True
FpSpread1.ActiveSheetView.ColumnFooter.RowCount = 2
FpSpread1.ActiveSheetView.ColumnFooter.AlternatingRows.Item(0).BackColor = Drawing.Color.Bisque
FpSpread1.ActiveSheetView.ColumnFooter.Cells(0, 0).BackColor = Drawing.Color.Yellow
FpSpread1.ActiveSheetView.ColumnFooter.Columns(0).Border = New FarPoint.Web.Spread.Border(BorderStyle.Dotted, Drawing.Color.Blue)
FpSpread1.ActiveSheetView.ColumnFooter.DefaultStyle.Font.Bold = True
FpSpread1.ActiveSheetView.ColumnFooter.Height = 30
FpSpread1.ActiveSheetView.ColumnFooter.Rows(0).Font.Italic = True
Dim i As Integer
Dim j As Integer
For i = 0 To FpSpread1.ActiveSheetView.RowCount
For j = 0 To FpSpread1.ActiveSheetView.ColumnCount
FpSpread1.ActiveSheetView.DataModel.SetValue(i, j, j + i * FpSpread1.ActiveSheetView.ColumnCount)
Next
Next
Dim a As Integer = 0
FpSpread1.ActiveSheetView.Columns(a).AggregationType = FarPoint.Web.Spread.Model.AggregationType.Avg
FpSpread1.ActiveSheetView.ColumnFooter.Cells(0, a).Value = "Avg"
a += 1
FpSpread1.ActiveSheetView.Columns(a).AggregationType = FarPoint.Web.Spread.Model.AggregationType.Count
FpSpread1.ActiveSheetView.ColumnFooter.Cells(0, a).Value = "Count"
a += 1
FpSpread1.ActiveSheetView.Columns(a).AggregationType = FarPoint.Web.Spread.Model.AggregationType.Sum
FpSpread1.ActiveSheetView.ColumnFooter.Cells(0, a).Value = "Sum"
a += 1
FpSpread1.ActiveSheetView.Columns(a).AggregationType = FarPoint.Web.Spread.Model.AggregationType.Product
FpSpread1.ActiveSheetView.ColumnFooter.Cells(0, a).Value = "Product"
a += 1 |
Requirements
Target Platforms: Windows 98, Windows NT 4.0, Windows Millennium Edition, Windows 2000, Windows XP Home Edition, Windows XP Professional, Windows Server 2003 family, Windows Vista, Windows Server 2008 family
See Also
