ig.excel.WorksheetTableStyleArea

Represents the various areas which can have a format applied at the table style level.

Remarks

Note: Only certain properties can be set on the table style are formats. The are as follows: IWorksheetCellFormat.bottomBorderColorInfo IWorksheetCellFormat.bottomBorderStyle IWorksheetCellFormat.fill IWorksheetCellFormat.leftBorderColorInfo IWorksheetCellFormat.leftBorderStyle IWorksheetCellFormat.rightBorderColorInfo IWorksheetCellFormat.rightBorderStyle IWorksheetCellFormat.topBorderColorInfo IWorksheetCellFormat.topBorderStyle Font.Bold Font.ColorInfo Font.Italic Font.Strikeout Font.UnderlineStyle Setting any other format or font properties on the table style areas will cause an exception.

Dependencies

jquery-1.4.4.js
infragistics.util.js
infragistics.ext_core.js
infragistics.ext_collections.js
infragistics.ext_collectionsExtended.js
infragistics.ext_io.js
infragistics.ext_text.js
infragistics.documents.core_core.js
infragistics.ext_ui.js
  • alternateColumnStripe

    Type:
    ig.excel.WorksheetTableStyleArea
    Default:
    8

    The format is applied to the even numbered column stripes in the table.

  • alternateRowStripe

    Type:
    ig.excel.WorksheetTableStyleArea
    Default:
    6

    The format is applied to the even numbered row stripes in the table.

  • columnStripe

    Type:
    ig.excel.WorksheetTableStyleArea
    Default:
    7

    The format is applied to the odd numbered column stripes in the table.

  • firstColumn

    Type:
    ig.excel.WorksheetTableStyleArea
    Default:
    3

    The format is applied to the first column in the table.

  • firstHeaderCell

    Type:
    ig.excel.WorksheetTableStyleArea
    Default:
    9

    The format is applied to the first header cell in the table.

  • firstTotalCell

    Type:
    ig.excel.WorksheetTableStyleArea
    Default:
    11

    The format is applied to the first total cell in the table.

  • headerRow

    Type:
    ig.excel.WorksheetTableStyleArea
    Default:
    1

    The format is applied to the header row in the table.

  • lastColumn

    Type:
    ig.excel.WorksheetTableStyleArea
    Default:
    4

    The format is applied to the last column in the table.

  • lastHeaderCell

    Type:
    ig.excel.WorksheetTableStyleArea
    Default:
    10

    The format is applied to the last header cell in the table.

  • lastTotalCell

    Type:
    ig.excel.WorksheetTableStyleArea
    Default:
    12

    The format is applied to the last total cell in the table.

  • rowStripe

    Type:
    ig.excel.WorksheetTableStyleArea
    Default:
    5

    The format is applied to the odd numbered row stripes in the table.

  • totalRow

    Type:
    ig.excel.WorksheetTableStyleArea
    Default:
    2

    The format is applied to the totals row in the table.

  • wholeTable

    Type:
    ig.excel.WorksheetTableStyleArea
    Default:
    0

    The format is applied to the entire table.

The current widget has no events.
The current widget has no public methods.

Copyright © 1996 - 2019 Infragistics, Inc. All rights reserved.