Enum LookupCachingMode
Specifies options for caching look up tables in HLookUp and VLookUp functions.
Namespace: Syncfusion.Windows.Forms.CellGrid
Assembly: Syncfusion.Spreadsheet.Windows.dll
Syntax
[Flags]
public enum LookupCachingModeFields
| Name | Description |
|---|---|
| Both | Tables will be cached for both VLookUp and HLookUp. |
| HLOOKUP | Tables will be cached only for HLookUp. |
| None | No caching is done. |
| OptimizeForMatches | Tables will be optimized for searching for exact matches. Set this flag if you expect your searches to find exact matches. |
| VLOOKUP | Tables will be cached only for VLookUp. |