ColumnBinarySearch
Constructors
Section titled “Constructors”constructor
Section titled “constructor”+ new ColumnBinarySearch(dependencyGraph: DependencyGraph): ColumnBinarySearch
Defined in src/Lookup/ColumnBinarySearch.ts:15
Parameters:
| Name | Type |
|---|---|
dependencyGraph | DependencyGraph |
Returns: ColumnBinarySearch
Methods
Section titled “Methods”▸ add(value: RawScalarValue, address: SimpleCellAddress): void
Defined in src/Lookup/ColumnBinarySearch.ts:21
Parameters:
| Name | Type |
|---|---|
value | RawScalarValue |
address | SimpleCellAddress |
Returns: void
addColumns
Section titled “addColumns”▸ addColumns(columnsSpan: ColumnsSpan): void
Defined in src/Lookup/ColumnBinarySearch.ts:37
Parameters:
| Name | Type |
|---|---|
columnsSpan | ColumnsSpan |
Returns: void
advancedFind
Section titled “advancedFind”▸ advancedFind(keyMatcher: function, rangeValue: SimpleRangeValue, __namedParameters: object): number
Defined in src/Lookup/AdvancedFind.ts:26
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
Section titled “applyChanges”▸ applyChanges(contentChanges: CellValueChange[]): void
Defined in src/Lookup/ColumnBinarySearch.ts:33
Parameters:
| Name | Type |
|---|---|
contentChanges | CellValueChange[] |
Returns: void
change
Section titled “change”▸ change(oldValue: RawScalarValue | undefined, newValue: RawScalarValue, address: SimpleCellAddress): void
Defined in src/Lookup/ColumnBinarySearch.ts:29
Parameters:
| Name | Type |
|---|---|
oldValue | RawScalarValue | undefined |
newValue | RawScalarValue |
address | SimpleCellAddress |
Returns: void
▸ find(searchKey: RawNoErrorScalarValue, rangeValue: SimpleRangeValue, searchOptions: SearchOptions): number
Defined in src/Lookup/ColumnBinarySearch.ts:69
Parameters:
| Name | Type |
|---|---|
searchKey | RawNoErrorScalarValue |
rangeValue | SimpleRangeValue |
searchOptions | SearchOptions |
Returns: number
forceApplyPostponedTransformations
Section titled “forceApplyPostponedTransformations”▸ forceApplyPostponedTransformations(): void
Defined in src/Lookup/ColumnBinarySearch.ts:63
No-op: ColumnBinarySearch reads cell values directly from the dependency graph on every lookup, so it has no cached data that could become stale. Unlike ColumnIndex, which maintains a separate value-to-address index that must be kept in sync with lazy transformations, binary search always operates on the current graph state.
Returns: void
moveValues
Section titled “moveValues”▸ moveValues(sourceRange: IterableIterator‹[RawScalarValue, SimpleCellAddress]›, toRight: number, toBottom: number, toSheet: number): void
Defined in src/Lookup/ColumnBinarySearch.ts:49
Parameters:
| Name | Type |
|---|---|
sourceRange | IterableIterator‹[RawScalarValue, SimpleCellAddress]› |
toRight | number |
toBottom | number |
toSheet | number |
Returns: void
remove
Section titled “remove”▸ remove(value: RawScalarValue | undefined, address: SimpleCellAddress): void
Defined in src/Lookup/ColumnBinarySearch.ts:25
Parameters:
| Name | Type |
|---|---|
value | RawScalarValue | undefined |
address | SimpleCellAddress |
Returns: void
removeColumns
Section titled “removeColumns”▸ removeColumns(columnsSpan: ColumnsSpan): void
Defined in src/Lookup/ColumnBinarySearch.ts:41
Parameters:
| Name | Type |
|---|---|
columnsSpan | ColumnsSpan |
Returns: void
removeSheet
Section titled “removeSheet”▸ removeSheet(sheetId: number): void
Defined in src/Lookup/ColumnBinarySearch.ts:45
Parameters:
| Name | Type |
|---|---|
sheetId | number |
Returns: void
removeValues
Section titled “removeValues”▸ removeValues(range: IterableIterator‹[RawScalarValue, SimpleCellAddress]›): void
Defined in src/Lookup/ColumnBinarySearch.ts:53
Parameters:
| Name | Type |
|---|---|
range | IterableIterator‹[RawScalarValue, SimpleCellAddress]› |
Returns: void