# ColumnBinarySearch Class
# Constructors
# constructor
+ new ColumnBinarySearch(dependencyGraph: DependencyGraph): ColumnBinarySearch
Defined in src/Lookup/ColumnBinarySearch.ts:15 (opens new window)
Parameters:
| Name | Type |
|---|---|
dependencyGraph | DependencyGraph |
Returns: ColumnBinarySearch
# Methods
# add
▸ add(value: RawScalarValue, address: SimpleCellAddress): void
Defined in src/Lookup/ColumnBinarySearch.ts:21 (opens new window)
Parameters:
| Name | Type |
|---|---|
value | RawScalarValue |
address | SimpleCellAddress |
Returns: void
# addColumns
▸ addColumns(columnsSpan: ColumnsSpan): void
Defined in src/Lookup/ColumnBinarySearch.ts:37 (opens new window)
Parameters:
| Name | Type |
|---|---|
columnsSpan | ColumnsSpan |
Returns: void
# advancedFind
▸ advancedFind(keyMatcher: function, rangeValue: SimpleRangeValue, __namedParameters: object): number
Defined in src/Lookup/AdvancedFind.ts:26 (opens new window)
Parameters:
▪ keyMatcher: function
▸ (arg: RawInterpreterValue): boolean
Parameters:
| Name | Type |
|---|---|
arg | RawInterpreterValue |
▪ rangeValue: SimpleRangeValue
▪Default value __namedParameters: object= { returnOccurrence: 'first' }
| Name | Type |
|---|---|
returnOccurrence | undefined | "first" | "last" |
Returns: number
# applyChanges
▸ applyChanges(contentChanges: CellValueChange[]): void
Defined in src/Lookup/ColumnBinarySearch.ts:33 (opens new window)
Parameters:
| Name | Type |
|---|---|
contentChanges | CellValueChange[] |
Returns: void
# change
▸ change(oldValue: RawScalarValue | undefined, newValue: RawScalarValue, address: SimpleCellAddress): void
Defined in src/Lookup/ColumnBinarySearch.ts:29 (opens new window)
Parameters:
| Name | Type |
|---|---|
oldValue | RawScalarValue | undefined |
newValue | RawScalarValue |
address | SimpleCellAddress |
Returns: void
# find
▸ find(searchKey: RawNoErrorScalarValue, rangeValue: SimpleRangeValue, searchOptions: SearchOptions): number
Defined in src/Lookup/ColumnBinarySearch.ts:59 (opens new window)
Parameters:
| Name | Type |
|---|---|
searchKey | RawNoErrorScalarValue |
rangeValue | SimpleRangeValue |
searchOptions | SearchOptions |
Returns: number
# moveValues
▸ moveValues(sourceRange: IterableIterator‹[RawScalarValue, SimpleCellAddress]›, toRight: number, toBottom: number, toSheet: number): void
Defined in src/Lookup/ColumnBinarySearch.ts:49 (opens new window)
Parameters:
| Name | Type |
|---|---|
sourceRange | IterableIterator‹[RawScalarValue, SimpleCellAddress]› |
toRight | number |
toBottom | number |
toSheet | number |
Returns: void
# remove
▸ remove(value: RawScalarValue | undefined, address: SimpleCellAddress): void
Defined in src/Lookup/ColumnBinarySearch.ts:25 (opens new window)
Parameters:
| Name | Type |
|---|---|
value | RawScalarValue | undefined |
address | SimpleCellAddress |
Returns: void
# removeColumns
▸ removeColumns(columnsSpan: ColumnsSpan): void
Defined in src/Lookup/ColumnBinarySearch.ts:41 (opens new window)
Parameters:
| Name | Type |
|---|---|
columnsSpan | ColumnsSpan |
Returns: void
# removeSheet
▸ removeSheet(sheetId: number): void
Defined in src/Lookup/ColumnBinarySearch.ts:45 (opens new window)
Parameters:
| Name | Type |
|---|---|
sheetId | number |
Returns: void
# removeValues
▸ removeValues(range: IterableIterator‹[RawScalarValue, SimpleCellAddress]›): void
Defined in src/Lookup/ColumnBinarySearch.ts:53 (opens new window)
Parameters:
| Name | Type |
|---|---|
range | IterableIterator‹[RawScalarValue, SimpleCellAddress]› |
Returns: void