# ColumnSearchStrategy Interface
# Methods
# add
▸ add(value: RawInterpreterValue, address: SimpleCellAddress): void
Defined in src/Lookup/SearchStrategy.ts:37 (opens new window)
Parameters:
| Name | Type |
|---|---|
value | RawInterpreterValue |
address | SimpleCellAddress |
Returns: void
# addColumns
▸ addColumns(columnsSpan: ColumnsSpan): void
Defined in src/Lookup/SearchStrategy.ts:45 (opens new window)
Parameters:
| Name | Type |
|---|---|
columnsSpan | ColumnsSpan |
Returns: void
# advancedFind
▸ advancedFind(keyMatcher: function, range: SimpleRangeValue, options: AdvancedFindOptions): number
Defined in src/Lookup/SearchStrategy.ts:33 (opens new window)
Parameters:
▪ keyMatcher: function
▸ (arg: RawInterpreterValue): boolean
Parameters:
| Name | Type |
|---|---|
arg | RawInterpreterValue |
▪ range: SimpleRangeValue
▪ options: AdvancedFindOptions
Returns: number
# applyChanges
▸ applyChanges(contentChanges: CellValueChange[]): void
Defined in src/Lookup/SearchStrategy.ts:43 (opens new window)
Parameters:
| Name | Type |
|---|---|
contentChanges | CellValueChange[] |
Returns: void
# change
▸ change(oldValue: RawInterpreterValue | undefined, newValue: RawInterpreterValue, address: SimpleCellAddress): void
Defined in src/Lookup/SearchStrategy.ts:41 (opens new window)
Parameters:
| Name | Type |
|---|---|
oldValue | RawInterpreterValue | undefined |
newValue | RawInterpreterValue |
address | SimpleCellAddress |
Returns: void
# find
▸ find(searchKey: RawNoErrorScalarValue, range: SimpleRangeValue, options: SearchOptions): number
Defined in src/Lookup/SearchStrategy.ts:31 (opens new window)
Parameters:
| Name | Type |
|---|---|
searchKey | RawNoErrorScalarValue |
range | SimpleRangeValue |
options | SearchOptions |
Returns: number
# moveValues
▸ moveValues(range: IterableIterator‹[RawScalarValue, SimpleCellAddress]›, toRight: number, toBottom: number, toSheet: number): void
Defined in src/Lookup/SearchStrategy.ts:51 (opens new window)
Parameters:
| Name | Type |
|---|---|
range | IterableIterator‹[RawScalarValue, SimpleCellAddress]› |
toRight | number |
toBottom | number |
toSheet | number |
Returns: void
# remove
▸ remove(value: RawInterpreterValue | undefined, address: SimpleCellAddress): void
Defined in src/Lookup/SearchStrategy.ts:39 (opens new window)
Parameters:
| Name | Type |
|---|---|
value | RawInterpreterValue | undefined |
address | SimpleCellAddress |
Returns: void
# removeColumns
▸ removeColumns(columnsSpan: ColumnsSpan): void
Defined in src/Lookup/SearchStrategy.ts:47 (opens new window)
Parameters:
| Name | Type |
|---|---|
columnsSpan | ColumnsSpan |
Returns: void
# removeSheet
▸ removeSheet(sheetId: number): void
Defined in src/Lookup/SearchStrategy.ts:49 (opens new window)
Parameters:
| Name | Type |
|---|---|
sheetId | number |
Returns: void
# removeValues
▸ removeValues(range: IterableIterator‹[RawScalarValue, SimpleCellAddress]›): void
Defined in src/Lookup/SearchStrategy.ts:53 (opens new window)
Parameters:
| Name | Type |
|---|---|
range | IterableIterator‹[RawScalarValue, SimpleCellAddress]› |
Returns: void