New to Telerik Document ProcessingStart a free 30-day trial

Defines the standard set of operators used in spreadsheet formulas, each with metadata for parsing and evaluation.

Definition

Namespace:Telerik.Windows.Documents.Spreadsheet.Expressions

Assembly:Telerik.Windows.Documents.Spreadsheet.dll

Syntax:

C#
public static class OperatorInfos

Inheritance: objectOperatorInfos

Fields

Operator info for the text concatenation operator ("&") that joins string values.

C#
public static readonly OperatorInfo Ampersand

Operator info for the division operator ("/").

C#
public static readonly OperatorInfo Divide

Operator info for the equality comparison operator ("=").

C#
public static readonly OperatorInfo Equal

Operator info for the greater-than comparison operator (">").

C#
public static readonly OperatorInfo GreaterThan

Operator info for the greater-than-or-equal-to comparison operator (">=").

C#
public static readonly OperatorInfo GreaterThanOrEqualTo

Operator info for the intersection operator (" ") that finds common cells between ranges.

C#
public static readonly OperatorInfo Intersection

Operator info for the less-than comparison operator ("<").

C#
public static readonly OperatorInfo LessThan

Operator info for the less-than-or-equal-to comparison operator ("<=").

C#
public static readonly OperatorInfo LessThanOrEqualTo

Operator info for the subtraction operator ("-").

C#
public static readonly OperatorInfo Minus

Operator info for the multiplication operator ("*").

C#
public static readonly OperatorInfo Multiply

Operator info for the inequality comparison operator ("<>").

C#
public static readonly OperatorInfo NotEqual

Operator info for the percent operator ("%") that divides a value by 100.

C#
public static readonly OperatorInfo Percent

Operator info for the addition operator ("+").

C#
public static readonly OperatorInfo Plus

Operator info for the exponentiation operator ("^") that raises a number to a power.

C#
public static readonly OperatorInfo Power

Operator info for the range operator (":") that creates a cell range between two references.

C#
public static readonly OperatorInfo Range

Operator info for the unary minus operator ("-") that negates a numeric value.

C#
public static readonly OperatorInfo UnaryMinus

Operator info for the unary plus operator ("+") that preserves the sign of a numeric value.

C#
public static readonly OperatorInfo UnaryPlus

Operator info for the union operator (",") that combines multiple cell ranges or references.

C#
public static readonly OperatorInfo Union