跳到主要内容

TableStyleOverrideType

This simple type specifies possible values for the table sections to which the current conditional formatting properties will be applied when this selected table style is used.
-"topLeftCell" - specifies that the table formatting is applied to the top left cell.
-"topRightCell" - specifies that the table formatting is applied to the top right cell.
-"bottomLeftCell" - specifies that the table formatting is applied to the bottom left cell.
-"bottomRightCell" - specifies that the table formatting is applied to the bottom right cell.
-"firstRow" - specifies that the table formatting is applied to the first row.
-"lastRow" - specifies that the table formatting is applied to the last row.
-"firstColumn" - specifies that the table formatting is applied to the first column. Any subsequent row which is in table header (ApiTableRowPr#SetTableHeader) will also use this conditional format.
-"lastColumn" - specifies that the table formatting is applied to the last column.
-"bandedColumn" - specifies that the table formatting is applied to odd numbered groupings of rows.
-"bandedColumnEven" - specifies that the table formatting is applied to even numbered groupings of rows.
-"bandedRow" - specifies that the table formatting is applied to odd numbered groupings of columns.
-"bandedRowEven" - specifies that the table formatting is applied to even numbered groupings of columns.
-"wholeTable" - specifies that the conditional formatting is applied to the whole table.

Type

Enumeration

Values

  • "topLeftCell"
  • "topRightCell"
  • "bottomLeftCell"
  • "bottomRightCell"
  • "firstRow"
  • "lastRow"
  • "firstColumn"
  • "lastColumn"
  • "bandedColumn"
  • "bandedColumnEven"
  • "bandedRow"
  • "bandedRowEven"
  • "wholeTable"

Example

This example applys the created style (set shadow) to the top left cell of the table.

tableStyle.GetConditionalTableStyle("topLeftCell").GetTableCellPr().SetShd("clear", 255, 0, 0);