Variable BuiltInOperatorNamesConst

Type Declaration

• ReadonlyAfter: "after"

  Checks date is after.

• ReadonlyAfterEqualTo: "afterEqualTo"

  Checks date is after or equal to.

• ReadonlyAnd: "and"

  And operator that returns true if all param are met.

  Remarks

  Accepts a readonly ICondition.Input[]

• ReadonlyAverage: "average"

  Checks for values above or below average.

  • Accepts ICondition.AverageOption.

• ReadonlyBefore: "before"

  Checks date is before

• ReadonlyBeforeEqualTo: "beforeEqualTo"

  Checks date is before or equal to.

• ReadonlyBetween: "between"

  Checks for values between two values.

  • Accepts ICondition.BetweenOption.

• ReadonlyBlank: "blank"

  Checks that value is blank.

• ReadonlyColor: "color"

  Checks for color.

  Remarks

  Accepts ICondition.ColorOption

• ReadonlyDisplayEqualTo: "displayEqualTo"

  Checks the text a cell SHOWS equals the operand ("displays as"): under a filter the displayed text, so $1 is a cell holding 1 under $0; elsewhere the value's own text. Excel's filter equal and its values list compare this way (DESIGN-FILTER §3.2).

• ReadonlyEqualTo: "equalTo"

  Checks any value is equal to: value equality, 1 is every cell holding 1 and never the text '1'.

• ReadonlyError: "error"

  Checks that value is an error.

• ReadonlyExpression: "expression"

  Evaluates a formula expression.

  Remarks

  • Accepts formula text or an ICalculation.IFormula; a resolved condition holds an IFormula.

  Backs conditional formatting's expression rule and data validation's type="custom".

• ReadonlyGreaterThan: "greaterThan"

  Checks any value is greater than.

• ReadonlyGreaterThanEqualTo: "greaterThanEqualTo"

  Checks any value is greater than.

• ReadonlyIcon: "icon"

  An operator that filters by icon sets.

  Remarks

  • Accepts ICondition.IconOption

• ReadonlyInSet: "inSet"

  Checks that a value is one of a set: membership. Offered under every selector.

  Remarks

  • Accepts ICondition.InSetOption

• ReadonlyLessThan: "lessThan"

  Checks any value is less than.

• ReadonlyLessThanEqualTo: "lessThanEqualTo"

  Checks any value is less than or equal to.

• ReadonlyNot: "not"

  Negates another condition.

  Remarks

  • Accepts ICondition.Input.

• ReadonlyOr: "or"

  Or operator that returns true if any param are met.

  Remarks

  Accepts a readonly ICondition.Input[]

• ReadonlyTextContains: "textContains"

  Checks any text value is greater than or equal to.

• ReadonlyTextEmail: "textEmail"

  Checks any text matches an email pattern.

• ReadonlyTextEndsWith: "textEndsWith"

  Checks any text value is greater than.

• ReadonlyTextIsUrl: "textUrl"

  Checks any text matches a url pattern.

• ReadonlyTextStartsWith: "textStartsWith"

  Checks any text value starts with.

• ReadonlyTimePeriod: "timePeriod"

  An operator that filters dates for time periods.

  Remarks

  • Accepts ICondition.TimePeriodOption

• ReadonlyTopN: "topN"

  An operator that filters by top N or bottom N values.

  Remarks

  • Accepts ICondition.TopNOption

• ReadonlyUnique: "unique"

  Checks that value is unique.