Class LookupCachingMode

Specifies options for caching look up tables in HLookUp and VLookUp functions.

Inheritance
System.Object
LookupCachingMode
Namespace: Syncfusion.Calculate
Assembly: Syncfusion.XlsIO.UWP.dll
Syntax
public sealed class LookupCachingMode : Enum

Fields

Both

Tables will be cached for both VLookUp and HLookUp.

Declaration
public const LookupCachingMode Both
Field Value
Type
LookupCachingMode

HLOOKUP

Tables will be cached only for HLookUp.

Declaration
public const LookupCachingMode HLOOKUP
Field Value
Type
LookupCachingMode

None

No caching is done.

Declaration
public const LookupCachingMode None
Field Value
Type
LookupCachingMode

OptimizeForMatches

Tables will be optimized for searching for exact matches. Set this flag if you expect your searches to find exact matches.

Declaration
public const LookupCachingMode OptimizeForMatches
Field Value
Type
LookupCachingMode

VLOOKUP

Tables will be cached only for VLookUp.

Declaration
public const LookupCachingMode VLOOKUP
Field Value
Type
LookupCachingMode

Extension Methods