|
»Spread for ASP.NET
» Product Tour
» Conditional Formatting
|
|
jump to:
|
|
Conditional Formatting |
|
You can set up conditional formats within cells that determine the formatting
of the cell based on the outcome of a conditional statement. You can use a
named style to specify various formatting options such as borders and colors to
apply if the condition statement is valid, that is, if the operation is
satisfied.
For example, you may want to change the background color of a cell based on the
value of the cell. If the value is below 100 then the background color would be
changed to red. The condition statement is “less than 100” and consists of a
comparison operator “less than” and a condition, in this case a single constant
“100”. The condition can be a constant (expressed as a string) or an
expression. Some condition statements have two conditions and an operator: for
instance, if the cell value is between 0 and 100, then change the background
color. In this case, the comparison operator is “between” and the first
condition is 0 and the last condition is 100. For a complete list of
operations, refer to the ComparisonOperator enumeration.
Type a number in the highlighted box below.
The appearance of the cell will changed based on values greater or less than 20.
'Define Conditions
'row, column, NamedStyle, condition, value
FpSpread1.Sheets(0).SetConditionalFormat(1, 1, ns,
FarPoint.Web.Spread.ComparisonOperator.LessThan, "20")
FpSpread1.Sheets(0).SetConditionalFormat(1, 1, ns2,
FarPoint.Web.Spread.ComparisonOperator.GreaterThan, "40")