Static
$tStatic
nextGets the [[WorkbookColorInfo]] which describes the background color of the cell, which will only be seen if the [[patternStyle]] is not None.
Gets the [[WorkbookColorInfo]] which describes the pattern color of the cell, which will only be seen if the [[patternStyle]] is not None or Solid.
Gets the fill pattern for the cell.
Static
noStatic
compareStatic
compareStatic
createCreates a linear gradient that can be applied to a cell's fill.
[[ArgumentException]] 'stops' contains less than two gradient stops. There must be at least two stops to define the gradient.
[[CellFillLinearGradient]]
The angle, in degrees, of the direction of the linear gradient, going clockwise from the left-to-right direction.
Two or more gradient stops which describe the color transitions and their positions within the gradient.
Creates a linear gradient that can be applied to a cell's fill.
[[ArgumentException]] 'colorInfo1' or 'colorInfo2' is an automatic or a system color.
[[CellFillLinearGradient]]
The angle, in degrees, of the direction of the linear gradient, going clockwise from the left-to-right direction.
A [[WorkbookColorInfo]] which describes the color at the start of the gradient.
A [[WorkbookColorInfo]] which describes the color at the end of the gradient.
Creates a linear gradient that can be applied to a cell's fill.
[[ArgumentException]] 'color1' or 'color2' are the empty or system colors or have a non-opaque alpha channel.
[[CellFillLinearGradient]]
The angle, in degrees, of the direction of the linear gradient, going clockwise from the left-to-right direction.
The color at the start of the gradient.
The color at the end of the gradient.
Static
createCreates a solid color or pattern fill that can be applied to a cell.
'backgroundColorInfo' and 'patternColorInfo' can be specified as null to use the default colors.
[[InvalidEnumArgumentException]] 'patternStyle' is Default or not defined in the [[FillPatternStyle]] enumeration.
[[CellFillPattern]]
A [[WorkbookColorInfo]] which describes the background color of the cell, which will only be seen if the 'patternStyle' is not None.
A [[WorkbookColorInfo]] which describes the pattern color of the cell, which will only be seen if the 'patternStyle' is not None or Solid.
The fill pattern for the cell.
Creates a solid color or pattern fill that can be applied to a cell.
[[ArgumentException]] 'backgroundColor' or 'patternColor' are the empty color or have a non-opaque alpha channel.
[[InvalidEnumArgumentException]] 'patternStyle' is Default or not defined in the [[FillPatternStyle]] enumeration.
[[CellFillPattern]]
The background color of the cell, which will only be seen if the 'patternStyle' is not None.
The pattern color of the cell, which will only be seen if the 'patternStyle' is not None or Solid.
The fill pattern for the cell.
Static
createCreates a rectangular gradient that can be applied to a cell's fill.
[[ArgumentException]] 'colorInfo1' or 'colorInfo2' is an automatic or a system color.
[[CellFillRectangularGradient]]
A [[WorkbookColorInfo]] which describes the color at the inner rectangle (cell center) of the gradient.
A [[WorkbookColorInfo]] which describes the color at the outer rectangle (cell edges) of the gradient.
Creates a rectangular gradient that can be applied to a cell's fill.
The rectangular gradient is defined by specifying an inner rectangle and a set of gradient stops. The gradient goes from the edges of the inner rectangle to the edges of the cell. If the inner rectangle does not have a height or width of 0, the color of the first gradient stop will be filled in the center of the inner rectangle.
The inner rectangle is defined by the 'left', 'top', 'right', and 'bottom' parameters. They are relative values ranging from 0.0 to 1.0 and they go from the top/left to the bottom/right. So, for example, to specify a gradient that goes out from the center, all values would be 0.5. Or to specify a gradient which goes out from the bottom-left corner of the cell, the following values would be used: left = 0.0, top = 1.0, right = 0.0, bottom = 1.0.
[[ArgumentOutOfRangeException]] 'left', 'top', 'right', or 'bottom' are less than 0.0 or greater than 1.0.
[[ArgumentException]] 'stops' contains less than two gradient stops. There must be at least two stops to define the gradient.
[[CellFillRectangularGradient]]
The left edge of the inner rectangle of the gradient, ranging from 0.0 (the left of the cell) to 1.0 (the right of the cell).
The top edge of the inner rectangle of the gradient, ranging from 0.0 (the top of the cell) to 1.0 (the bottom of the cell).
The right edge of the inner rectangle of the gradient, ranging from 0.0 (the left of the cell) to 1.0 (the right of the cell).
The bottom edge of the inner rectangle of the gradient, ranging from 0.0 (the top of the cell) to 1.0 (the bottom of the cell).
Two or more gradient stops which describe the color transitions and their positions within the gradient.
Creates a rectangular gradient that can be applied to a cell's fill.
The rectangular gradient is defined by specifying an inner rectangle and a set of gradient stops. The gradient goes from the edges of the inner rectangle to the edges of the cell. If the inner rectangle does not have a height or width of 0, the color of the first gradient stop will be filled in the center of the inner rectangle.
The inner rectangle is defined by the 'left', 'top', 'right', and 'bottom' parameters. They are relative values ranging from 0.0 to 1.0 and they go from the top/left to the bottom/right. So, for example, to specify a gradient that goes out from the center, all values would be 0.5. Or to specify a gradient which goes out from the bottom-left corner of the cell, the following values would be used: left = 0.0, top = 1.0, right = 0.0, bottom = 1.0.
[[ArgumentException]] 'colorInfo1' or 'colorInfo2' is an automatic or a system color.
[[ArgumentOutOfRangeException]] 'left', 'top', 'right', or 'bottom' are less than 0.0 or greater than 1.0.
[[CellFillRectangularGradient]]
The left edge of the inner rectangle of the gradient, ranging from 0.0 (the left of the cell) to 1.0 (the right of the cell).
The top edge of the inner rectangle of the gradient, ranging from 0.0 (the top of the cell) to 1.0 (the bottom of the cell).
The right edge of the inner rectangle of the gradient, ranging from 0.0 (the left of the cell) to 1.0 (the right of the cell).
The bottom edge of the inner rectangle of the gradient, ranging from 0.0 (the top of the cell) to 1.0 (the bottom of the cell).
A [[WorkbookColorInfo]] which describes the color at the inner rectangle of the gradient.
A [[WorkbookColorInfo]] which describes the color at the outer rectangle (cell edges) of the gradient.
Creates a rectangular gradient that can be applied to a cell's fill.
The rectangular gradient is defined by specifying an inner rectangle and a set of gradient stops. The gradient goes from the edges of the inner rectangle to the edges of the cell. If the inner rectangle does not have a height or width of 0, the color of the first gradient stop will be filled in the center of the inner rectangle.
The inner rectangle is defined by the 'left', 'top', 'right', and 'bottom' parameters. They are relative values ranging from 0.0 to 1.0 and they go from the top/left to the bottom/right. So, for example, to specify a gradient that goes out from the center, all values would be 0.5. Or to specify a gradient which goes out from the bottom-left corner of the cell, the following values would be used: left = 0.0, top = 1.0, right = 0.0, bottom = 1.0.
[[ArgumentOutOfRangeException]] 'left', 'top', 'right', or 'bottom' are less than 0.0 or greater than 1.0.
[[ArgumentException]] 'color1' or 'color2' are empty or system colors or have a non-opaque alpha channel.
[[CellFillRectangularGradient]]
The left edge of the inner rectangle of the gradient, ranging from 0.0 (the left of the cell) to 1.0 (the right of the cell).
The top edge of the inner rectangle of the gradient, ranging from 0.0 (the top of the cell) to 1.0 (the bottom of the cell).
The right edge of the inner rectangle of the gradient, ranging from 0.0 (the left of the cell) to 1.0 (the right of the cell).
The bottom edge of the inner rectangle of the gradient, ranging from 0.0 (the top of the cell) to 1.0 (the bottom of the cell).
The color at the inner rectangle of the gradient.
The color at the outer rectangle (cell edges) of the gradient.
Creates a rectangular gradient that can be applied to a cell's fill.
[[ArgumentException]] 'color1' or 'color2' are empty or system colors or have a non-opaque alpha channel.
[[CellFillRectangularGradient]]
The color at the inner rectangle (cell center) of the gradient.
The color at the outer rectangle (cell edges) of the gradient.
Static
createCreates a solid color fill that can be applied to a cell.
[[CellFillPattern]]
A [[WorkbookColorInfo]] which describes the solid color of the fill.
Creates a solid color fill that can be applied to a cell.
[[ArgumentException]] 'solidColor' is the empty color or has a non-opaque alpha channel.
[[CellFillPattern]]
The solid color of the fill.
Static
equalsStatic
equalsStatic
getStatic
getStatic
getStatic
reference
An immutable object which represents a solid or pattern fill for a cell.
See
[[IWorksheetCellFormat.fill]]