ConditionalFormatWrapper Class |
Summary description for ConditionalFormatWrapper.
Inheritance Hierarchy
Namespace: Spire.Xls
Assembly: Spire.XLS (in Spire.XLS.dll) Version: 15.4.0.0 (15.4.0.5046)
Syntax
The ConditionalFormatWrapper type exposes the following members.
Constructors
| Name | Description | |
|---|---|---|
|
ConditionalFormatWrapper |
Creates new instance of the wrapper.
|
Properties
| Name | Description | |
|---|---|---|
|
Average |
Get the conditional formatting's "Average" instance.
The default instance's rule highlights cells that are
above the average for all values in the range.
Valid only for type = Average.
|
|
|
BackColor |
Pattern background color.
|
|
|
BackColorObject |
Conditional format background color. Read-only.
|
|
|
BackKnownColor |
Pattern background color.
|
|
BeginCallsCount |
Returns number of begin update calls that have no corresponding end update. Read-only.
(Inherited from
CommonWrapper
.)
|
|
|
BottomBorderColor |
Color of the bottom line
|
|
|
BottomBorderColorObject |
Conditional format bottom border color. Read-only.
|
|
|
BottomBorderKnownColor |
Color of the bottom line.
|
|
|
BottomBorderStyle |
Bottom border line style.
|
|
|
Color |
Pattern foreground color.
|
|
|
ColorScale |
Returns color scale settings. Valid only if FormatType is set to ColorScale. Read-only.
|
|
|
DataBar |
Returns data bar settings. Valid only if FormatType is set to DataBar. Read-only.
|
|
|
DxfId |
Gets or sets the DXF ID associated with the object.
|
|
|
FillPattern |
XlsFill pattern style.
|
|
|
FirstFormula |
First formula.
|
|
|
FirstFormulaR1C1 |
Obsolete.
First formula.
|
|
|
FontColor |
Font color.
|
|
|
FontColorObject |
Conditional format font color. Read-only.
|
|
|
FontKnownColor |
Font color.
|
|
|
FormatType |
Type of the conditional format.
|
|
|
IconSet |
Returns iconset settings. Valid only if FormatType is set to IconSet. Read-only.
|
|
|
IsBackgroundColorPresent |
If true - background color present. otherwise - false.
|
|
|
IsBold |
Indicates whether the font is bold.
|
|
|
IsBorderFormatPresent |
True if contains border formatting.
|
|
|
IsBottomBorderModified |
True if bottom border style and color are modified.
|
|
|
IsFontColorPresent |
If true - format color present. otherwise - false.
|
|
|
IsFontFormatPresent |
True if contains font formatting.
|
|
|
IsItalic |
Indicates whether font is italic.
|
|
|
IsLeftBorderModified |
True if left border style and color are modified.
|
|
|
IsPatternColorPresent |
Indicates whether pattern color .
|
|
|
IsPatternFormatPresent |
True if contains pattern formatting.
|
|
|
IsPatternStyleModified |
Indicates whether pattern style was modified.
|
|
|
IsRightBorderModified |
True if right border style and color modified.
|
|
|
IsStrikeThrough |
Indicates whether font is struck through.
|
|
|
IsSubScript |
Indicates whether font is subscript.
|
|
|
IsSuperScript |
Indicates whether font is superscript.
|
|
|
IsTopBorderModified |
True if top border style and color are modified.
|
|
|
KnownColor |
Pattern foreground color.
|
|
|
LeftBorderColor |
Color of the left line.
|
|
|
LeftBorderColorObject |
Conditional format left border color. Read-only.
|
|
|
LeftBorderKnownColor |
Color of the left line.
|
|
|
LeftBorderStyle |
Left border line style.
|
|
|
NumberFormat |
Gets or sets the number format for the condition.
|
|
|
OColor |
Conditional format color. Read-only.
|
|
|
Operator |
Type of the comparison operator.
|
|
|
Parent |
Parent object for this object.
|
|
|
Priority |
Gets or sets the priority of the condition.
|
|
|
RightBorderColor |
Color of the right line.
|
|
|
RightBorderColorObject |
Conditional format right border color. Read-only.
|
|
|
RightBorderKnownColor |
Color of the right line.
|
|
|
RightBorderStyle |
Right border line style.
|
|
|
SecondFormula |
Second formula.
|
|
|
SecondFormulaR1C1 |
Obsolete.
First formula.
|
|
|
StopIfTrue |
True, no rules with lower priority may be applied over this rule, when this rule evaluates to true.
Only applies for Excel 2007;
|
|
|
TopBorderColor |
Color of the top line
|
|
|
TopBorderColorObject |
Conditional format top border color. Read-only.
|
|
|
TopBorderKnownColor |
Color of the top line.
|
|
|
TopBorderStyle |
Top border line style.
|
|
|
TopBottom |
Get the conditional formatting's "TopBottom" instance.
The default instance's rule highlights cells whose
values fall in the top 10 bracket.
Valid only for type = TopBottom.
|
|
|
Underline |
Underline type.
|
Methods
| Name | Description | |
|---|---|---|
|
|
BeginUpdate |
This method should be called before several updates to the object will take place.
(Overrides
CommonWrapper
BeginUpdate
.)
|
|
|
Clone |
Creates a copy of the current object.
(Inherited from
CommonWrapper
.)
|
|
|
EndUpdate |
This method should be called after several updates to the object took place.
(Overrides
CommonWrapper
EndUpdate
.)
|
|
|
Equals |
Determines whether the specified object is equal to the current object.
(Inherited from
Object
.)
|
|
Finalize |
Allows an object to try to free resources and perform other cleanup operations before it is reclaimed by garbage collection.
(Inherited from
Object
.)
|
|
|
GetHashCode |
Serves as the default hash function.
(Inherited from
Object
.)
|
|
|
GetType |
Gets the
Type
of the current instance.
(Inherited from
Object
.)
|
|
|
MakeFormula |
Not implemented
|
|
|
MakeFormula(String) |
Not implemented
|
|
|
MemberwiseClone |
Creates a shallow copy of the current
Object
.
(Inherited from
Object
.)
|
|
|
SetTimePeriod |
Sets the time period for the conditional formatting rule.
|
|
|
ToString |
Returns a string that represents the current object.
(Inherited from
Object
.)
|
See Also
