类: ConditionalFormatHighlightRuleBuilder

继承

• ConditionalFormatRuleBaseBuilder

方法

copy()

copy(): ConditionalFormatHighlightRuleBuilder

Deep clone a current builder.

返回

ConditionalFormatHighlightRuleBuilder

Memberof

ConditionalFormatRuleBuilder

重写了

ConditionalFormatRuleBaseBuilder.copy

setAverage()

setAverage(operator): this

Set average rule

参数

返回

this

Memberof

ConditionalFormatHighlightRuleBuilder

setBackground()

setBackground(color?): this

Sets the background color

参数

返回

this

Memberof

ConditionalFormatRuleBuilder

setBold()

setBold(isBold): this

Set Bold

参数

返回

this

Memberof

ConditionalFormatRuleBuilder

setDuplicateValues()

setDuplicateValues(): this

Set duplicateValues rule

返回

this

Memberof

ConditionalFormatHighlightRuleBuilder

setFontColor()

setFontColor(color?): this

Sets the font color

参数

返回

this

Memberof

ConditionalFormatRuleBuilder

setItalic()

setItalic(isItalic): this

Set the text to italic

参数

返回

this

Memberof

ConditionalFormatRuleBuilder

setRank()

setRank(config): this

Set rank rule

参数

返回

this

Memberof

ConditionalFormatHighlightRuleBuilder

setStrikethrough()

setStrikethrough(isStrikethrough): this

Set the strikethrough

参数

返回

this

Memberof

ConditionalFormatRuleBuilder

setUnderline()

setUnderline(isUnderline): this

Set the underscore

参数

返回

this

Memberof

ConditionalFormatRuleBuilder

setUniqueValues()

setUniqueValues(): this

Set uniqueValues rule

返回

this

Memberof

ConditionalFormatHighlightRuleBuilder

whenCellEmpty()

whenCellEmpty(): this

Sets the conditional formatting rule to fire when the cell is empty.

返回

this

whenCellNotEmpty()

whenCellNotEmpty(): this

Sets the conditional formatting rule to fire when the cell is not empty

返回

this

Memberof

ConditionalFormatRuleBuilder

whenDate()

whenDate(date): this

Highlight when the date is in a time period, custom time is not supported.

参数

返回

this

Memberof

ConditionalFormatRuleBuilder

whenFormulaSatisfied()

whenFormulaSatisfied(formulaString): this

Sets a conditional formatting rule to fire when a given formula evaluates to true.

参数

返回

this

Memberof

ConditionalFormatRuleBuilder

whenNumberBetween()

whenNumberBetween(start, end): this

Sets the conditional formatting rule to fire when a number is between two specified values or equal to one of them.

参数

返回

this

Memberof

ConditionalFormatRuleBuilder

whenNumberEqualTo()

whenNumberEqualTo(value): this

Sets the conditional formatting rule to fire when the number equals the given value

参数

返回

this

Memberof

ConditionalFormatRuleBuilder

whenNumberGreaterThan()

whenNumberGreaterThan(value): this

Sets the conditional formatting rule to fire when the number is greater than the given value

参数

返回

this

Memberof

ConditionalFormatRuleBuilder

whenNumberGreaterThanOrEqualTo()

whenNumberGreaterThanOrEqualTo(value): this

Sets a conditional formatting rule to fire when a number is greater than or equal to a given value.

参数

返回

this

Memberof

ConditionalFormatRuleBuilder

whenNumberLessThan()

whenNumberLessThan(value): this

Sets a conditional formatting rule to fire when the number is less than the given value.

参数

返回

this

Memberof

ConditionalFormatRuleBuilder

whenNumberLessThanOrEqualTo()

whenNumberLessThanOrEqualTo(value): this

Sets the conditional formatting rule to fire when the value is less than or equal to the given value.

参数

返回

this

Memberof

ConditionalFormatRuleBuilder

whenNumberNotBetween()

whenNumberNotBetween(start, end): this

Sets a conditional formatting rule to fire when a number is not between two specified values and is not equal to them.

参数

返回

this

Memberof

ConditionalFormatRuleBuilder

whenNumberNotEqualTo()

whenNumberNotEqualTo(value): this

Sets the conditional formatting rule to fire when a number does not equal a given value.

参数

返回

this

Memberof

ConditionalFormatRuleBuilder

whenTextContains()

whenTextContains(text): this

Sets the conditional formatting rule to fire when the input contains the given value.

参数

返回

this

Memberof

ConditionalFormatRuleBuilder

whenTextDoesNotContain()

whenTextDoesNotContain(text): this

Sets a conditional formatting rule to fire when the input does not contain the given value.

参数

返回

this

Memberof

ConditionalFormatRuleBuilder

whenTextEndsWith()

whenTextEndsWith(text): this

Sets a conditional formatting rule to fire when input ends with a specified value.

参数

返回

this

Memberof

ConditionalFormatRuleBuilder

whenTextEqualTo()

whenTextEqualTo(text): this

Sets the conditional formatting rule to fire when the input equals the given value.

参数

返回

this

Memberof

ConditionalFormatRuleBuilder

whenTextStartsWith()

whenTextStartsWith(text): this

Sets the conditional formatting rule to fire when the input value begins with the given value.

参数

返回

this

Memberof

ConditionalFormatRuleBuilder