Skip to content
v3.4.0

AbsoluteRowRange

+ new AbsoluteRowRange(sheet: number, rowStart: number, rowEnd: number): AbsoluteRowRange

Defined in src/AbsoluteCellRange.ts:495

Parameters:

NameType
sheetnumber
rowStartnumber
rowEndnumber

Returns: AbsoluteRowRange

• end: SimpleCellAddress

Defined in src/AbsoluteCellRange.ts:47


• start: SimpleCellAddress

Defined in src/AbsoluteCellRange.ts:46

• get sheet(): number

Defined in src/AbsoluteCellRange.ts:60

Returns: number

▸ addressInRange(address: SimpleCellAddress): boolean

Defined in src/AbsoluteCellRange.ts:157

Parameters:

NameType
addressSimpleCellAddress

Returns: boolean


▸ addresses(dependencyGraph: DependencyGraph): SimpleCellAddress[]

Defined in src/AbsoluteCellRange.ts:315

Parameters:

NameType
dependencyGraphDependencyGraph

Returns: SimpleCellAddress[]


▸ addressesArrayMap‹T›(dependencyGraph: DependencyGraph, op: function): T[][]

Defined in src/AbsoluteCellRange.ts:299

Type parameters:

▪ T

Parameters:

▪ dependencyGraph: DependencyGraph

▪ op: function

▸ (arg: SimpleCellAddress): T

Parameters:

NameType
argSimpleCellAddress

Returns: T[][]


▸ addressesWithDirection(right: number, bottom: number, dependencyGraph: DependencyGraph): IterableIterator‹SimpleCellAddress›

Defined in src/AbsoluteCellRange.ts:331

Parameters:

NameType
rightnumber
bottomnumber
dependencyGraphDependencyGraph

Returns: IterableIterator‹SimpleCellAddress›


▸ arrayOfAddressesInRange(): SimpleCellAddress[][]

Defined in src/AbsoluteCellRange.ts:275

Returns: SimpleCellAddress[][]


▸ columnInRange(address: SimpleColumnAddress): boolean

Defined in src/AbsoluteCellRange.ts:168

Parameters:

NameType
addressSimpleColumnAddress

Returns: boolean


▸ containsRange(range: AbsoluteCellRange): boolean

Defined in src/AbsoluteCellRange.ts:182

Parameters:

NameType
rangeAbsoluteCellRange

Returns: boolean


▸ doesOverlap(other: AbsoluteCellRange): boolean

Defined in src/AbsoluteCellRange.ts:144

Parameters:

NameType
otherAbsoluteCellRange

Returns: boolean


▸ effectiveEndColumn(dependencyGraph: DependencyGraph): number

Defined in src/AbsoluteCellRange.ts:536

Parameters:

NameType
dependencyGraphDependencyGraph

Returns: number


▸ effectiveEndRow(_dependencyGraph: DependencyGraph): number

Defined in src/AbsoluteCellRange.ts:394

Parameters:

NameType
_dependencyGraphDependencyGraph

Returns: number


▸ effectiveHeight(_dependencyGraph: DependencyGraph): number

Defined in src/AbsoluteCellRange.ts:402

Parameters:

NameType
_dependencyGraphDependencyGraph

Returns: number


▸ effectiveWidth(dependencyGraph: DependencyGraph): number

Defined in src/AbsoluteCellRange.ts:540

Parameters:

NameType
dependencyGraphDependencyGraph

Returns: number


▸ exceedsSheetSizeLimits(_maxColumns: number, maxRows: number): boolean

Defined in src/AbsoluteCellRange.ts:532

Parameters:

NameType
_maxColumnsnumber
maxRowsnumber

Returns: boolean


▸ expandByColumns(_numberOfColumns: number): void

Defined in src/AbsoluteCellRange.ts:520

Parameters:

NameType
_numberOfColumnsnumber

Returns: void


▸ expandByRows(numberOfRows: number): void

Defined in src/AbsoluteCellRange.ts:217

Parameters:

NameType
numberOfRowsnumber

Returns: void


▸ getAddress(col: number, row: number): SimpleCellAddress

Defined in src/AbsoluteCellRange.ts:379

Parameters:

NameType
colnumber
rownumber

Returns: SimpleCellAddress


▸ height(): number

Defined in src/AbsoluteCellRange.ts:267

Returns: number


▸ includesColumn(column: number): boolean

Defined in src/AbsoluteCellRange.ts:208

Parameters:

NameType
columnnumber

Returns: boolean


▸ includesRow(row: number): boolean

Defined in src/AbsoluteCellRange.ts:204

Parameters:

NameType
rownumber

Returns: boolean


▸ intersectionWith(other: AbsoluteCellRange): Maybe‹AbsoluteCellRange›

Defined in src/AbsoluteCellRange.ts:186

Parameters:

NameType
otherAbsoluteCellRange

Returns: Maybe‹AbsoluteCellRange›


▸ isFinite(): boolean

Defined in src/AbsoluteCellRange.ts:140

Returns: boolean


▸ moveToSheet(toSheet: number): void

Defined in src/AbsoluteCellRange.ts:234

Parameters:

NameType
toSheetnumber

Returns: void


▸ rangeWithSameHeight(startColumn: number, numberOfColumns: number): AbsoluteCellRange

Defined in src/AbsoluteCellRange.ts:255

Parameters:

NameType
startColumnnumber
numberOfColumnsnumber

Returns: AbsoluteCellRange


▸ rangeWithSameWidth(startRow: number, numberOfRows: number): AbsoluteCellRange

Defined in src/AbsoluteCellRange.ts:528

Parameters:

NameType
startRownumber
numberOfRowsnumber

Returns: AbsoluteCellRange


▸ removeSpan(span: Span): void

Defined in src/AbsoluteCellRange.ts:239

Parameters:

NameType
spanSpan

Returns: void


▸ rowInRange(address: SimpleRowAddress): boolean

Defined in src/AbsoluteCellRange.ts:175

Parameters:

NameType
addressSimpleRowAddress

Returns: boolean


▸ sameAs(other: AbsoluteCellRange): boolean

Defined in src/AbsoluteCellRange.ts:295

Parameters:

NameType
otherAbsoluteCellRange

Returns: boolean


▸ sameDimensionsAs(other: AbsoluteCellRange): boolean

Defined in src/AbsoluteCellRange.ts:291

Parameters:

NameType
otherAbsoluteCellRange

Returns: boolean


▸ shiftByColumns(_numberOfColumns: number): void

Defined in src/AbsoluteCellRange.ts:516

Parameters:

NameType
_numberOfColumnsnumber

Returns: void


▸ shiftByRows(numberOfRows: number): void

Defined in src/AbsoluteCellRange.ts:212

Parameters:

NameType
numberOfRowsnumber

Returns: void


▸ shifted(byCols: number, byRows: number): AbsoluteCellRange

Defined in src/AbsoluteCellRange.ts:524

Parameters:

NameType
byColsnumber
byRowsnumber

Returns: AbsoluteCellRange


▸ shouldBeRemoved(): boolean

Defined in src/AbsoluteCellRange.ts:512

Returns: boolean


▸ size(): number

Defined in src/AbsoluteCellRange.ts:271

Returns: number


▸ toString(): string

Defined in src/AbsoluteCellRange.ts:259

Returns: string


▸ width(): number

Defined in src/AbsoluteCellRange.ts:263

Returns: number


▸ withStart(newStart: SimpleCellAddress): AbsoluteCellRange

Defined in src/AbsoluteCellRange.ts:287

Parameters:

NameType
newStartSimpleCellAddress

Returns: AbsoluteCellRange


▸ fromAst(ast: CellRangeAst | ColumnRangeAst | RowRangeAst, baseAddress: SimpleCellAddress): AbsoluteCellRange

Defined in src/AbsoluteCellRange.ts:83

Parameters:

NameType
astCellRangeAst | ColumnRangeAst | RowRangeAst
baseAddressSimpleCellAddress

Returns: AbsoluteCellRange


▸ fromAstOrUndef(ast: CellRangeAst | ColumnRangeAst | RowRangeAst, baseAddress: SimpleCellAddress): Maybe‹AbsoluteCellRange›

Defined in src/AbsoluteCellRange.ts:93

Parameters:

NameType
astCellRangeAst | ColumnRangeAst | RowRangeAst
baseAddressSimpleCellAddress

Returns: Maybe‹AbsoluteCellRange›


▸ fromCellRange(x: CellRange, baseAddress: SimpleCellAddress): AbsoluteCellRange

Defined in src/AbsoluteCellRange.ts:101

Parameters:

NameType
xCellRange
baseAddressSimpleCellAddress

Returns: AbsoluteCellRange


▸ fromCoordinates(sheet: number, x1: number, y1: number, x2: number, y2: number): AbsoluteCellRange

Defined in src/AbsoluteCellRange.ts:136

Parameters:

NameType
sheetnumber
x1number
y1number
x2number
y2number

Returns: AbsoluteCellRange


▸ fromRowRangeAst(x: RowRangeAst, baseAddress: SimpleCellAddress): AbsoluteRowRange

Defined in src/AbsoluteCellRange.ts:503

Parameters:

NameType
xRowRangeAst
baseAddressSimpleCellAddress

Returns: AbsoluteRowRange


▸ fromSimpleCellAddresses(start: SimpleCellAddress, end: SimpleCellAddress): AbsoluteCellRange

Defined in src/AbsoluteCellRange.ts:64

Parameters:

NameType
startSimpleCellAddress
endSimpleCellAddress

Returns: AbsoluteCellRange


▸ spanFrom(topLeftCorner: SimpleCellAddress, width: number, height: number): AbsoluteCellRange

Defined in src/AbsoluteCellRange.ts:108

Parameters:

NameType
topLeftCornerSimpleCellAddress
widthnumber
heightnumber

Returns: AbsoluteCellRange


▸ spanFromOrUndef(topLeftCorner: SimpleCellAddress, width: number, height: number): Maybe‹AbsoluteCellRange›

Defined in src/AbsoluteCellRange.ts:116

Parameters:

NameType
topLeftCornerSimpleCellAddress
widthnumber
heightnumber

Returns: Maybe‹AbsoluteCellRange›