# Operations Class
# Constructors
# constructor
+ new Operations(config: Config, dependencyGraph: DependencyGraph, columnSearch: ColumnSearchStrategy, cellContentParser: CellContentParser, parser: ParserWithCaching, stats: Statistics, lazilyTransformingAstService: LazilyTransformingAstService, namedExpressions: NamedExpressions, arraySizePredictor: ArraySizePredictor): Operations
Defined in src/Operations.ts:160 (opens new window)
Parameters:
| Name | Type |
|---|---|
config | Config |
dependencyGraph | DependencyGraph |
columnSearch | ColumnSearchStrategy |
cellContentParser | CellContentParser |
parser | ParserWithCaching |
stats | Statistics |
lazilyTransformingAstService | LazilyTransformingAstService |
namedExpressions | NamedExpressions |
arraySizePredictor | ArraySizePredictor |
Returns: Operations
# Methods
# addColumns
▸ addColumns(cmd: AddColumnsCommand): void
Defined in src/Operations.ts:203 (opens new window)
Parameters:
| Name | Type |
|---|---|
cmd | AddColumnsCommand |
Returns: void
# addNamedExpression
▸ addNamedExpression(expressionName: string, expression: RawCellContent, sheetId?: Maybe‹number›, options?: NamedExpressionOptions): void
Defined in src/Operations.ts:374 (opens new window)
Parameters:
| Name | Type |
|---|---|
expressionName | string |
expression | RawCellContent |
sheetId? | Maybe‹number› |
options? | NamedExpressionOptions |
Returns: void
# addRows
▸ addRows(cmd: AddRowsCommand): void
Defined in src/Operations.ts:197 (opens new window)
Parameters:
| Name | Type |
|---|---|
cmd | AddRowsCommand |
Returns: void
# addSheet
▸ addSheet(name?: undefined | string): string
Defined in src/Operations.ts:248 (opens new window)
Parameters:
| Name | Type |
|---|---|
name? | undefined | string |
Returns: string
# changeNamedExpressionExpression
▸ changeNamedExpressionExpression(expressionName: string, newExpression: RawCellContent, sheetId?: Maybe‹number›, options?: NamedExpressionOptions): [InternalNamedExpression, ClipboardCell]
Defined in src/Operations.ts:387 (opens new window)
Parameters:
| Name | Type |
|---|---|
expressionName | string |
newExpression | RawCellContent |
sheetId? | Maybe‹number› |
options? | NamedExpressionOptions |
Returns: [InternalNamedExpression, ClipboardCell]
# clearSheet
▸ clearSheet(sheetId: number): void
Defined in src/Operations.ts:243 (opens new window)
Parameters:
| Name | Type |
|---|---|
sheetId | number |
Returns: void
# ensureItIsPossibleToMoveCells
▸ ensureItIsPossibleToMoveCells(sourceLeftCorner: SimpleCellAddress, width: number, height: number, destinationLeftCorner: SimpleCellAddress): void
Defined in src/Operations.ts:420 (opens new window)
Parameters:
| Name | Type |
|---|---|
sourceLeftCorner | SimpleCellAddress |
width | number |
height | number |
destinationLeftCorner | SimpleCellAddress |
Returns: void
# forceApplyPostponedTransformations
▸ forceApplyPostponedTransformations(): void
Defined in src/Operations.ts:676 (opens new window)
Returns: void
# getAndClearContentChanges
▸ getAndClearContentChanges(): ContentChanges
Defined in src/Operations.ts:670 (opens new window)
Returns: ContentChanges
# getClipboardCell
▸ getClipboardCell(address: SimpleCellAddress): ClipboardCell
Defined in src/Operations.ts:505 (opens new window)
Parameters:
| Name | Type |
|---|---|
address | SimpleCellAddress |
Returns: ClipboardCell
# getOldContent
▸ getOldContent(address: SimpleCellAddress): [SimpleCellAddress, ClipboardCell]
Defined in src/Operations.ts:486 (opens new window)
Parameters:
| Name | Type |
|---|---|
address | SimpleCellAddress |
Returns: [SimpleCellAddress, ClipboardCell]
# getRangeClipboardCells
▸ getRangeClipboardCells(range: AbsoluteCellRange): [SimpleCellAddress, ClipboardCell][]
Defined in src/Operations.ts:546 (opens new window)
Parameters:
| Name | Type |
|---|---|
range | AbsoluteCellRange |
Returns: [SimpleCellAddress, ClipboardCell][]
# getSheetClipboardCells
▸ getSheetClipboardCells(sheet: number): ClipboardCell[][]
Defined in src/Operations.ts:530 (opens new window)
Parameters:
| Name | Type |
|---|---|
sheet | number |
Returns: ClipboardCell[][]
# moveCells
▸ moveCells(sourceLeftCorner: SimpleCellAddress, width: number, height: number, destinationLeftCorner: SimpleCellAddress): MoveCellsResult
Defined in src/Operations.ts:297 (opens new window)
Parameters:
| Name | Type |
|---|---|
sourceLeftCorner | SimpleCellAddress |
width | number |
height | number |
destinationLeftCorner | SimpleCellAddress |
Returns: MoveCellsResult
# moveColumns
▸ moveColumns(sheet: number, startColumn: number, numberOfColumns: number, targetColumn: number): number
Defined in src/Operations.ts:278 (opens new window)
Parameters:
| Name | Type |
|---|---|
sheet | number |
startColumn | number |
numberOfColumns | number |
targetColumn | number |
Returns: number
# moveRows
▸ moveRows(sheet: number, startRow: number, numberOfRows: number, targetRow: number): number
Defined in src/Operations.ts:259 (opens new window)
Parameters:
| Name | Type |
|---|---|
sheet | number |
startRow | number |
numberOfRows | number |
targetRow | number |
Returns: number
# removeColumns
▸ removeColumns(cmd: RemoveColumnsCommand): ColumnsRemoval[]
Defined in src/Operations.ts:209 (opens new window)
Parameters:
| Name | Type |
|---|---|
cmd | RemoveColumnsCommand |
Returns: ColumnsRemoval[]
# removeNamedExpression
▸ removeNamedExpression(expressionName: string, sheetId?: Maybe‹number›): [InternalNamedExpression, ClipboardCell]
Defined in src/Operations.ts:401 (opens new window)
Parameters:
| Name | Type |
|---|---|
expressionName | string |
sheetId? | Maybe‹number› |
Returns: [InternalNamedExpression, ClipboardCell]
# removeRows
▸ removeRows(cmd: RemoveRowsCommand): RowsRemoval[]
Defined in src/Operations.ts:186 (opens new window)
Parameters:
| Name | Type |
|---|---|
cmd | RemoveRowsCommand |
Returns: RowsRemoval[]
# removeSheet
▸ removeSheet(sheetId: number): object
Defined in src/Operations.ts:220 (opens new window)
Parameters:
| Name | Type |
|---|---|
sheetId | number |
Returns: object
scopedNamedExpressions: [InternalNamedExpression‹›, ClipboardCell][]
version: number = version
# removeSheetByName
▸ removeSheetByName(sheetName: string): object
Defined in src/Operations.ts:238 (opens new window)
Parameters:
| Name | Type |
|---|---|
sheetName | string |
Returns: object
scopedNamedExpressions: [InternalNamedExpression‹›, ClipboardCell][]
version: number = version
# renameSheet
▸ renameSheet(sheetId: number, newName: string): undefined | string
Defined in src/Operations.ts:255 (opens new window)
Parameters:
| Name | Type |
|---|---|
sheetId | number |
newName | string |
Returns: undefined | string
# restoreCell
▸ restoreCell(address: SimpleCellAddress, clipboardCell: ClipboardCell): void
Defined in src/Operations.ts:465 (opens new window)
Restores a single cell.
Parameters:
| Name | Type | Description |
|---|---|---|
address | SimpleCellAddress | - |
clipboardCell | ClipboardCell |
Returns: void
# restoreClipboardCells
▸ restoreClipboardCells(sourceSheetId: number, cells: IterableIterator‹[SimpleCellAddress, ClipboardCell]›): string[]
Defined in src/Operations.ts:447 (opens new window)
Parameters:
| Name | Type |
|---|---|
sourceSheetId | number |
cells | IterableIterator‹[SimpleCellAddress, ClipboardCell]› |
Returns: string[]
# restoreNamedExpression
▸ restoreNamedExpression(namedExpression: InternalNamedExpression, content: ClipboardCell, sheetId?: Maybe‹number›): void
Defined in src/Operations.ts:380 (opens new window)
Parameters:
| Name | Type |
|---|---|
namedExpression | InternalNamedExpression |
content | ClipboardCell |
sheetId? | Maybe‹number› |
Returns: void
# rowEffectivelyNotInSheet
▸ rowEffectivelyNotInSheet(row: number, sheet: number): boolean
Defined in src/Operations.ts:665 (opens new window)
Returns true if row number is outside of given sheet.
Parameters:
| Name | Type | Description |
|---|---|---|
row | number | row number |
sheet | number | sheet ID number |
Returns: boolean
# setCellContent
▸ setCellContent(address: SimpleCellAddress, newCellContent: RawCellContent): [SimpleCellAddress, ClipboardCell]
Defined in src/Operations.ts:554 (opens new window)
Parameters:
| Name | Type |
|---|---|
address | SimpleCellAddress |
newCellContent | RawCellContent |
Returns: [SimpleCellAddress, ClipboardCell]
# setCellEmpty
▸ setCellEmpty(address: SimpleCellAddress): void
Defined in src/Operations.ts:633 (opens new window)
Parameters:
| Name | Type |
|---|---|
address | SimpleCellAddress |
Returns: void
# setColumnOrder
▸ setColumnOrder(sheetId: number, columnMapping: [number, number][]): [SimpleCellAddress, ClipboardCell][]
Defined in src/Operations.ts:353 (opens new window)
Parameters:
| Name | Type |
|---|---|
sheetId | number |
columnMapping | [number, number][] |
Returns: [SimpleCellAddress, ClipboardCell][]
# setFormulaToCell
▸ setFormulaToCell(address: SimpleCellAddress, size: ArraySize, __namedParameters: object): void
Defined in src/Operations.ts:611 (opens new window)
Parameters:
▪ address: SimpleCellAddress
▪ size: ArraySize
▪ __namedParameters: object
| Name | Type |
|---|---|
ast | Ast |
dependencies | RelativeDependency[] |
hasStructuralChangeFunction | boolean |
hasVolatileFunction | boolean |
Returns: void
# setFormulaToCellFromCache
▸ setFormulaToCellFromCache(formulaHash: string, address: SimpleCellAddress): void
Defined in src/Operations.ts:645 (opens new window)
Parameters:
| Name | Type |
|---|---|
formulaHash | string |
address | SimpleCellAddress |
Returns: void
# setParsingErrorToCell
▸ setParsingErrorToCell(rawInput: string, errors: ParsingError[], address: SimpleCellAddress): void
Defined in src/Operations.ts:601 (opens new window)
Parameters:
| Name | Type |
|---|---|
rawInput | string |
errors | ParsingError[] |
address | SimpleCellAddress |
Returns: void
# setRowOrder
▸ setRowOrder(sheetId: number, rowMapping: [number, number][]): [SimpleCellAddress, ClipboardCell][]
Defined in src/Operations.ts:332 (opens new window)
Parameters:
| Name | Type |
|---|---|
sheetId | number |
rowMapping | [number, number][] |
Returns: [SimpleCellAddress, ClipboardCell][]
# setSheetContent
▸ setSheetContent(sheetId: number, newSheetContent: RawCellContent[][]): void
Defined in src/Operations.ts:591 (opens new window)
Parameters:
| Name | Type |
|---|---|
sheetId | number |
newSheetContent | RawCellContent[][] |
Returns: void
# setValueToCell
▸ setValueToCell(value: RawAndParsedValue, address: SimpleCellAddress): void
Defined in src/Operations.ts:624 (opens new window)
Parameters:
| Name | Type |
|---|---|
value | RawAndParsedValue |
address | SimpleCellAddress |
Returns: void