Column (Object)

Member of:

TableSection object, ResultsSection object

Description:

Represents a column within a Table or Results section.

Example 1:

This example illustrates how to populate a Dropdown list in a Dashboard section with Results column data. It assumes that you have CommandButton (button) and Dropdown (drop-down list) in the Dashboard section:

//Code behind the "CommandButton" 
var NumRows = ActiveDocument.Sections["Results"].RowCount
for (I =1 ; I <= NumRows;I++)
DropDown.Add(ActiveDocument.Sections["Results"].Columns[1].GetCell(I))

Example 2:

This example shows how to change the number format of all numeric columns in a Results section:

var NumColumns=ActiveDocument.Sections["SalesResults"].Columns.Count
for (I=1; I<=NumColumns;I++)
{
var MyCol=ActiveDocument.Sections["SalesResults"].Columns.Item(I)
MyCol.ResizeToBestFit()
   if (MyCol.DataType = bqDataTypeNumber)
   MyCol.NumberFormat = "0.00"
}

Methods:

CreateDateGroup(), GetCell(nRow as Number), Remove(), ResizeTo BestFit()

Properties:

Read-only: Property ColumnType As BqColumnType, Property DataType As BqDataType, Property Index As Number, Property Name As String

Read-write: Property Alignment As BqHorizontalAlignment, Property NumberFormat As String, Property SupressDuplicates As Boolean, Property TextWrap As Boolean, Property Visible As Boolean