Skip to content
v3.3.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[]


addressesArrayMapT›(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): MaybeAbsoluteCellRange

Defined in src/AbsoluteCellRange.ts:186

Parameters:

NameType
otherAbsoluteCellRange

Returns: MaybeAbsoluteCellRange


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): MaybeAbsoluteCellRange

Defined in src/AbsoluteCellRange.ts:93

Parameters:

NameType
astCellRangeAst | ColumnRangeAst | RowRangeAst
baseAddressSimpleCellAddress

Returns: MaybeAbsoluteCellRange


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): MaybeAbsoluteCellRange

Defined in src/AbsoluteCellRange.ts:116

Parameters:

NameType
topLeftCornerSimpleCellAddress
widthnumber
heightnumber

Returns: MaybeAbsoluteCellRange