View Source

Sets or returns a Pattern applied to cells.

public Pattern Pattern{ get; set; }

Public Property Pattern() As Pattern

By default, an unformatted cell will have a pattern of type Pattern.None. Setting the pattern to a different value will cause the cell's fill to have a pattern applied.

If there is no pattern, the Style.BackgroundColor determines the color of the cell. If there is a pattern, then the Style.BackgroundColor will specify the cell's background color, and Style.ForegroundColor will specify the cell's pattern color.

          //--- Get Pattern
          Pattern ptn = c.Style.Pattern;

          //--- Set Pattern
          styl.Pattern = Pattern.DiagonalCrosshatch;

          '--- Get Pattern
          Dim ptn As Pattern = c.Style.Pattern

          '--- Set Pattern
          styl.Pattern = Patter.DiagonalCrosshatch