Skip to content
v3.4.0

ColumnIndex

+ new ColumnIndex(dependencyGraph: DependencyGraph, config: Config, stats: Statistics): ColumnIndex

Defined in src/Lookup/ColumnIndex.ts:43

Parameters:

NameType
dependencyGraphDependencyGraph
configConfig
statsStatistics

Returns: ColumnIndex

▸ add(value: RawInterpreterValue, address: SimpleCellAddress): void

Defined in src/Lookup/ColumnIndex.ts:54

Parameters:

NameType
valueRawInterpreterValue
addressSimpleCellAddress

Returns: void


▸ addColumns(columnsSpan: ColumnsSpan): void

Defined in src/Lookup/ColumnIndex.ts:165

Parameters:

NameType
columnsSpanColumnsSpan

Returns: void


▸ advancedFind(keyMatcher: function, range: SimpleRangeValue, options: AdvancedFindOptions): number

Defined in src/Lookup/ColumnIndex.ts:161

Parameters:

▪ keyMatcher: function

▸ (arg: RawInterpreterValue): boolean

Parameters:

NameType
argRawInterpreterValue

▪ range: SimpleRangeValue

▪Default value options: AdvancedFindOptions= { returnOccurrence: ‘first’ }

Returns: number


▸ applyChanges(contentChanges: CellValueChange[]): void

Defined in src/Lookup/ColumnIndex.ts:88

Parameters:

NameType
contentChangesCellValueChange[]

Returns: void


▸ change(oldValue: RawInterpreterValue | undefined, newValue: RawInterpreterValue, address: SimpleCellAddress): void

Defined in src/Lookup/ColumnIndex.ts:80

Parameters:

NameType
oldValueRawInterpreterValue | undefined
newValueRawInterpreterValue
addressSimpleCellAddress

Returns: void


▸ ensureRecentData(sheet: number, col: number, value: RawInterpreterValue): void

Defined in src/Lookup/ColumnIndex.ts:233

Parameters:

NameType
sheetnumber
colnumber
valueRawInterpreterValue

Returns: void


▸ find(searchKey: RawNoErrorScalarValue, rangeValue: SimpleRangeValue, __namedParameters: object): number

Defined in src/Lookup/ColumnIndex.ts:110

Parameters:

▪ searchKey: RawNoErrorScalarValue

▪ rangeValue: SimpleRangeValue

▪ __namedParameters: object

NameType
ifNoMatch”returnLowerBound” | “returnUpperBound” | “returnNotFound”
ordering”asc” | “desc” | “none”
returnOccurrenceundefined | “first” | “last”

Returns: number


▸ forceApplyPostponedTransformations(): void

Defined in src/Lookup/ColumnIndex.ts:192

Forces all ValueIndex entries to apply any pending lazy transformations, bringing every entry up to the current LazilyTransformingAstService version. Must be called before compacting LazilyTransformingAstService.

Returns: void


▸ getColumnMap(sheet: number, col: number): ColumnMap

Defined in src/Lookup/ColumnIndex.ts:205

Parameters:

NameType
sheetnumber
colnumber

Returns: ColumnMap


▸ getValueIndex(sheet: number, col: number, value: RawInterpreterValue): ValueIndex

Defined in src/Lookup/ColumnIndex.ts:220

Parameters:

NameType
sheetnumber
colnumber
valueRawInterpreterValue

Returns: ValueIndex


▸ moveValues(sourceRange: IterableIterator‹[RawScalarValue, SimpleCellAddress]›, toRight: number, toBottom: number, toSheet: number): void

Defined in src/Lookup/ColumnIndex.ts:96

Parameters:

NameType
sourceRangeIterableIterator‹[RawScalarValue, SimpleCellAddress]›
toRightnumber
toBottomnumber
toSheetnumber

Returns: void


▸ remove(value: RawInterpreterValue | undefined, address: SimpleCellAddress): void

Defined in src/Lookup/ColumnIndex.ts:66

Parameters:

NameType
valueRawInterpreterValue | undefined
addressSimpleCellAddress

Returns: void


▸ removeColumns(columnsSpan: ColumnsSpan): void

Defined in src/Lookup/ColumnIndex.ts:174

Parameters:

NameType
columnsSpanColumnsSpan

Returns: void


▸ removeSheet(sheetId: number): void

Defined in src/Lookup/ColumnIndex.ts:183

Parameters:

NameType
sheetIdnumber

Returns: void


▸ removeValues(range: IterableIterator‹[RawScalarValue, SimpleCellAddress]›): void

Defined in src/Lookup/ColumnIndex.ts:104

Parameters:

NameType
rangeIterableIterator‹[RawScalarValue, SimpleCellAddress]›

Returns: void