Class ValueMatcher

Compares and matches values

Inheritance

System.Object

ValueMatcher

LookupValueMatcher

WildCardValueMatcher

Inherited Members

System.Object.Equals(System.Object)

System.Object.Equals(System.Object, System.Object)

System.Object.GetHashCode()

System.Object.GetType()

System.Object.MemberwiseClone()

System.Object.ReferenceEquals(System.Object, System.Object)

System.Object.ToString()

Namespace: OfficeOpenXml.FormulaParsing.ExcelUtilities

Assembly: EPPlus.dll

Syntax

public class ValueMatcher

Fields

IncompatibleOperands

Value to represent incompatible operands

Declaration

public const int IncompatibleOperands = -2

Field Value

Type	Description
System.Int32

Methods

CompareObjectToString(Object, String)

Compares object to string candidate.

Declaration

protected virtual int CompareObjectToString(object searchedValue, string candidate)

Parameters

Type	Name	Description
System.Object	searchedValue
System.String	candidate

Returns

Type	Description
System.Int32

CompareStringToObject(String, Object, Boolean)

Compares string to object candidate

Declaration

protected virtual int CompareStringToObject(string searchedValue, object candidate, bool convertNumericString = true)

Parameters

Type	Name	Description
System.String	searchedValue
System.Object	candidate
System.Boolean	convertNumericString

Returns

Type	Description
System.Int32

CompareStringToString(String, String)

Compares strings

Declaration

protected virtual int CompareStringToString(string searchedValue, string candidate)

Parameters

Type	Name	Description
System.String	searchedValue
System.String	candidate

Returns

Type	Description
System.Int32

IsMatch(Object, Object, Boolean)

Compares objects of different types using appropriate CompareTo methods

Declaration

public virtual int IsMatch(object searchedValue, object candidate, bool convertNumericString = true)

Parameters

Type	Name	Description
System.Object	searchedValue	original value
System.Object	candidate	potential match
System.Boolean	convertNumericString	If true a numeric string will be convered to a number in the comparison. Default value is true.

Returns

Type	Description
System.Int32