ASP.NET MVC Controls | ComponentOne
In This Topic
    Column Class
    In This Topic
    File
    wijmo.grid.js
    Module
    wijmo.grid
    Base Class
    RowCol
    Derived Classes
    ColumnGroup, TransposedGridRow, MultiRowCell

    Represents a column on the grid.

    Constructor

    Properties

    Methods

    Events

    Constructor

    constructor

    constructor(options?: any): Column
    

    Initializes a new instance of the Column class.

    Parameters
    • options: any
    Optional

    Initialization options for the column.

    Returns
    Column

    Properties

    aggregate

    Gets or sets the Aggregate to display in the group header rows for the column.

    The default value for this property is **Aggregate.None**, which causes the grid to show no aggregate values for this column.

    Type
    Aggregate

    align

    Gets or sets the horizontal alignment of cells in the column or row.

    The default value for this property is **null**, which causes the grid to select the alignment automatically based on the column's dataType (numbers are right-aligned, Boolean values are centered, and other types are left-aligned).

    If you want to override the default alignment, set this property to 'left', 'right', 'center', or 'justify'.

    Inherited From
    RowCol
    Type
    string

    allowDragging

    Gets or sets a value that indicates whether the user can move the column or row to a new position with the mouse.

    The default value for this property is **true**.

    Inherited From
    RowCol
    Type
    boolean

    allowMerging

    Gets or sets a value that indicates whether cells in the column or row can be merged.

    The default value for this property is **false**.

    Inherited From
    RowCol
    Type
    boolean

    allowResizing

    Gets or sets a value that indicates whether the user can resize the column or row with the mouse.

    The default value for this property is **true**.

    Inherited From
    RowCol
    Type
    boolean

    allowSorting

    Gets or sets a value that indicates whether the user can sort the column by clicking its header.

    The default value for this property is **true**.

    Type
    boolean

    binding

    Gets or sets the name of the property the column is bound to.

    The default value for this property is **null**, which means the column is not bound to any data fields.

    This property is set automatically for auto-generated columns (see autoGenerateColumns).

    Inherited From
    RowCol
    Type
    string

    cellTemplate

    Gets or sets an ICellTemplateFunction or a template string to be used for generating the HTML content of data cells in this Column.

    Cell template strings use template literal syntax. The content string is generated using a scope of type ICellTemplateContext.

    ICellTemplateFunction functions take an argument of type ICellTemplateContext and return the HTML content to be displayed in the cell.

    For example:

    ``` typescript // simple/default rendering with a cellTemplate string col.cellTemplate = '${value}:${col.format}';

    // simple/default rendering with a cellTemplate function col.cellTemplate = (ctx: ICellTemplateContext) => glbz`${ctx.value}:${ctx.col.format}`;

    // conditional formatting with cellTemplate string col.cellTemplate = '

    40000 ? "big-val" : "small-val"}>${text}';

    // conditional formatting with a cellTemplate function col.cellTemplate = (ctx: ICellTemplateContext) => `

    ${ctx.text} `; ``` Notice that string-based cell templates are regular strings, not actual JavaScript template literals. Therefore, they are defined using regular quotes (single or double) as oppsed to the back-quotes used by JavaScript template strings.

    **Function-based cell templates** are usually a better choice than string-based templates because:

    1) They provide design-time error checking and command completion, 2) They run faster, and 3) They do not have any issues with content-security policy (CSP).

    **String-based cell templates** also have advantages that may be important in some scenarios:

    1) They are slightly more concise, and 2) They can be stored as data and easily changed at run-time.

    The cellTemplate property provides a simpler alternative to the formatItem event or the cell templates available in the Wijmo interop modules.

    When using cell templates, you should still set the column's binding and format properties. They will be used in edit mode and to support copy/paste/export operations.

    Cell templates are used only to render cell data, and have no effect on editing. If you want to customize the cell editors, use the editor property.

    Cell templates can also be used to render row header cells. The most common scenario for this would be to add numbers to the row header cells. The example below shows how you can do this:

    // get row header column
    let col = theGrid.rowHeaders.columns[0];

    // assign template that adds the row index to the header // (but preserves glyphs such as edit and new row template) col.cellTemplate = ctx => ctx.text || (ctx.row.index + 1).toString();

    The default value for this property is **null**, which means the column has no template.

    Type
    string

    collectionView

    Gets the ICollectionView bound to this column or row.

    Inherited From
    RowCol
    Type
    ICollectionView

    cssClass

    Gets or sets a CSS class name to use when rendering data (non-header) cells in the column or row.

    This property can also be used to get or set a CSS class name for group column header cells.

    The default value for this property is **null**.

    Inherited From
    RowCol
    Type
    string

    cssClassAll

    Gets or sets a CSS class name to use when rendering all cells (data and headers) in the column or row.

    The default value for this property is **null**.

    Inherited From
    RowCol
    Type
    string

    currentSort

    Gets a string that describes the current sorting applied to the column. Possible values are '+' for ascending order, '-' for descending order, or null for unsorted columns.

    Type
    string

    currentSortIndex

    Gets the index of this column in the sort descriptions array for the grid's collection view.

    Type
    number

    dataMap

    Gets or sets the DataMap used to convert raw values into display values for the column or row.

    By default, data-mapped cells have drop-down lists that can be used for quick editing. You can change the type of editor by setting the column's dataMapEditor property.

    The default value for this property is **null**.

    Inherited From
    RowCol
    Type
    DataMap

    dataMapEditor

    Gets or sets a value that indicates the type of editor to use when editing data-mapped cells in this column or row.

    The default value for this property is DropDownList, which adds drop-down buttons to cells to columns that have a dataMap and are not read-only.

    Clicking on the drop-down buttons causes the grid to show a list where users can select the value for the cell.

    The RadioButtons setting causes the grid to show radio buttons for each option. The buttons can be clicked with the mouse or keyboard (by pressing each option's initial letter or the space key to cycle through the options.)

    Note that drop-down lists are available only if the **wijmo.input.ListBox** class is loaded/imported by the application.

    Inherited From
    RowCol
    Type
    DataMapEditor

    dataType

    Gets or sets the type of value stored in the column or row.

    Values are coerced into the proper type when editing the grid.

    The default value for this property is **null**, which causes the grid not to perform any data type coercion.

    This property is set automatically for auto-generated columns (see autoGenerateColumns).

    Inherited From
    RowCol
    Type
    DataType

    describedById

    Gets or sets the ID of an element that contains a description of the column.

    The ID is used as the value of the **aria-describedby** attribute for the column header element.

    THe default value for this property is **null**.

    Type
    string

    editor

    Gets or sets a reference to an input control to be used as a custom cell editor for this Column.

    The input control is typically one of the Wijmo input controls. It should be compatible with the column's data type.

    For example, this code replaces the built-in editor for all date columns on a grid with a single **InputDate** control:

    import { InputDate } from '@mescius/wijmo.input';
    let inputDate = new InputDate(document.createElement('div'));
    theGrid.columns.forEach(col => {
        if (col.DataType == DateType.Date) {
            col.editor = inputDate;
        }
    })
    
    And this code replaces the built-in editor for all data-mapped columns on a grid with **AutoComplete** controls:

    import { AutoComplete } from '@mescius/wijmo.input';
    theGrid.columns.forEach(col => {
        let map = col.dataMap;
        if (map) {
            col.editor = new AutoComplete(document.createElement('div'), {
                itemsSource: map.collectionView,
                displayMemberPath: map.displayMemberPath,
                selectedValuePath: map.selectedValuePath
            });
        }
    });
    
    Notice how the example above uses the column's dataMap property to initialize the **AutoComplete**.

    In many cases you may also want to use column properties such as format and isRequired to initialize the custom editors. This is important since the custom editors do not inherit **any** properties from the column being edited.

    The example below shows how you can use the editor property to edit grid items with various Wijmo input controls:

    {@sample Grid/Editing/CustomEditors Example}

    The default value for this property is **null**, which causes the grid to use the grid's own built-in editors.

    Type
    Control

    format

    Gets or sets the format string used to convert raw values into display values for the column or row (see Globalize).

    The default value for this property is **null**, which causes the grid to use default formats that depend on the data type.

    Inherited From
    RowCol
    Type
    string

    grid

    Gets the FlexGrid that owns this column or row.

    Inherited From
    RowCol
    Type
    FlexGrid

    index

    Gets the index of the column or row in the parent collection.

    Inherited From
    RowCol
    Type
    number

    inputType

    Gets or sets the "type" attribute of the HTML input element used to edit values in this column or row.

    The default value for this property is **null**, which causes the grid to use the type "tel" for numeric columns, and "text" for all other non-boolean column types.

    The "tel" input type causes mobile devices to show a numeric keyboard that includes a negative sign and a decimal separator.

    Use this property to change the default setting if the default does not work well for the current culture, device, or application. In these cases, try setting the property to "number" or simply "text."

    Inherited From
    RowCol
    Type
    string

    isContentHtml

    Gets or sets a value that indicates whether cells in this column or row contain HTML content rather than plain text.

    This property only applies to regular cells. Row and column header cells contain plain text by default. If you want to display HTML in column or row headers, you must use the formatItem event and set the cell's innerHTML content in code.

    Unless the column's isReadOnly property is set to true, cells that show HTML can be edited. By default, the editor will show HTML markup and users will be able to change it. If the column has a dataMap, however, the drop-down list will show formatted items and the editor will show plain text instead of HTML markup.

    The default value for this property is **false**.

    Inherited From
    RowCol
    Type
    boolean

    isReadOnly

    Gets or sets a value that indicates whether cells in the column or row can be edited.

    The default value for this property is **false**.

    Inherited From
    RowCol
    Type
    boolean

    isRequired

    Gets or sets a value that determines whether values in this column or row are required.

    The default value for this property is to **null**, which means dates, booleans, and numeric values are required, but non-masked string columns may contain empty strings.

    When set to true, values are required and empty strings are not allowed.

    When set to false, null values and empty strings are allowed.

    Inherited From
    RowCol
    Type
    boolean

    isSelected

    Gets or sets a value that indicates whether the column or row is selected.

    The default value for this property is **false**.

    Inherited From
    RowCol
    Type
    boolean

    isVisible

    Gets a value that indicates whether the column or row is visible and not collapsed.

    This property is read-only. To change the visibility of a column or row, use the visible property instead.

    Inherited From
    RowCol
    Type
    boolean

    mask

    Gets or sets a mask to use while editing values in this column or row.

    The format used to define the mask is the same used by the InputMask control.

    If specified, the mask must be compatible with the value of the format property. For example, the mask '99/99/9999' can be used for entering dates formatted as 'MM/dd/yyyy'.

    The default value for this property is **null**, which means any character is accepted at any position.

    Inherited From
    RowCol
    Type
    string

    maxLength

    Gets or sets the maximum number of characters that the can be entered into cells in this column or row.

    The default value for this property is **null**, which allows entries with any number of characters.

    Inherited From
    RowCol
    Type
    number

    maxWidth

    Gets or sets the maximum width (in pixels) of the column.

    The default value for this property is **null**, which means there is no upper limit to the column width.

    Type
    number

    minWidth

    Gets or sets the minimum width of the column.

    The default value for this property is **null**, which means there is no lower limit to the column width.

    Type
    number

    multiLine

    Gets or sets a value that indicates whether the content of cells in this column or row should wrap at new line characters (\n).

    The default value for this property is **false**.

    Inherited From
    RowCol
    Type
    boolean

    name

    Gets or sets the name of the column.

    The column name can be used to retrieve the column using the getColumn method.

    This property is especially useful when dealing with unbound columns or multiple columns with the same binding value.

    The default value for this property is **null**.

    Type
    string

    pos

    Gets the position of the column or row in pixels.

    Inherited From
    RowCol
    Type
    number

    quickAutoSize

    Gets or sets a value that determines whether the grid should optimize performance over precision when auto-sizing this column.

    Setting this property to false disables quick auto-sizing for this column.

    Setting it to true enables the feature, subject to the value of the grid's quickAutoSize property.

    The default value for this property is **null**, which enables the feature for columns that display plain text and don't have templates.

    Type
    boolean

    renderSize

    Gets the render size of the column or row.

    This property accounts for visibility, default size, and min and max sizes.

    Inherited From
    RowCol
    Type
    number

    renderWidth

    Gets the render width of the column.

    The value returned takes into account the column's visibility, default size, and min and max sizes.

    Type
    number

    size

    Gets or sets the size of the column or row.

    Setting this property to null or negative values causes the element to use the parent collection's default size.

    Inherited From
    RowCol
    Type
    number

    sortMemberPath

    Gets or sets the name of the property to use when sorting this column.

    Use this property in cases where you want the sorting to be performed based on values other than the ones specified by the binding property.

    The default value for this property is **null**, which causes the grid to use the value of the binding property to sort the column.

    Inherited From
    RowCol
    Type
    string

    visible

    Gets or sets a value that indicates whether the column or row is visible.

    The default value for this property is **true**.

    Inherited From
    RowCol
    Type
    boolean

    visibleIndex

    Gets the index of the column or row in the parent collection ignoring invisible elements (isVisible).

    Inherited From
    RowCol
    Type
    number

    width

    Gets or sets the width of the column.

    Column widths may be positive numbers (sets the column width in pixels), null or negative numbers (uses the collection's default column width), or strings in the format '{number}*' (star sizing).

    The star-sizing option performs a XAML-style dynamic sizing where column widths are proportional to the number before the star. For example, if a grid has three columns with widths "100", "*", and "3*", the first column will be 100 pixels wide, the second will take up 1/4th of the remaining space, and the last will take up the remaining 3/4ths of the remaining space.

    Star-sizing allows you to define columns that automatically stretch to fill the width available. For example, set the width of the last column to "*" and it will automatically extend to fill the entire grid width so there's no empty space. You may also want to set the column's minWidth property to prevent the column from getting too narrow.

    You can use the renderWidth property to retrieve the actual width of the column, taking into account visibility, star sizing, min/max limits, and default width settings.

    The default value for this property is **null**, which causes the grid to use the default column width defined by the grid's columns collection.

    Type
    any

    wordWrap

    Gets or sets a value that indicates whether the content of cells in this column or row should wrap to fit the available column width.

    The default value for this property is **false**.

    Inherited From
    RowCol
    Type
    boolean

    Methods

    getAlignment

    getAlignment(row?: Row): string
    

    Gets the actual alignment if items in the column or row.

    Returns the value of the align property if it is not null, or selects the alignment based on the column's dataType.

    Parameters
    • row: Row Optional

      Row that contains the cell being checked.

    Returns
    string

    getIsRequired

    getIsRequired(row?: Row): boolean
    

    Gets a value that determines whether values in the column/row are required.

    Returns the value of the isRequired property if it is not null, or determines the required status based on the column's dataType.

    By default, string columns are not required unless they have an associated dataMap or mask; all other data types are required.

    Parameters
    • row: Row Optional

      Row that contains the cell being checked.

    Returns
    boolean

    onGridChanged

    onGridChanged(e?: EventArgs): void
    

    Raises the gridChanged event.

    Parameters
    Inherited From
    RowCol
    Returns
    void

    onPropertyChanged

    onPropertyChanged(): void
    

    Marks the owner list as dirty and refreshes the owner grid.

    Inherited From
    RowCol
    Returns
    void

    Events

    gridChanged

    Occurs when the value of the grid property changes.

    Inherited From
    RowCol
    Arguments
    EventArgs