TableSection object, ResultsSection object
Represents a column within a Table or Results section.
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))
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" }
CreateDateGroup(), GetCell(nRow as Number), Remove(), ResizeTo BestFit()
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