跳到主要内容

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);