# AbsoluteCellRange Class
# Constructors
# constructor
+ new AbsoluteCellRange(start: SimpleCellAddress, end: SimpleCellAddress): AbsoluteCellRange
Defined in src/AbsoluteCellRange.ts:47 (opens new window)
Parameters:
| Name | Type |
|---|---|
start | SimpleCellAddress |
end | SimpleCellAddress |
Returns: AbsoluteCellRange
# Properties
# end Readonly
• end: SimpleCellAddress
Defined in src/AbsoluteCellRange.ts:47 (opens new window)
# start Readonly
• start: SimpleCellAddress
Defined in src/AbsoluteCellRange.ts:46 (opens new window)
# Accessors
# sheet
• get sheet(): number
Defined in src/AbsoluteCellRange.ts:60 (opens new window)
Returns: number
# Methods
# addressInRange
▸ addressInRange(address: SimpleCellAddress): boolean
Defined in src/AbsoluteCellRange.ts:157 (opens new window)
Parameters:
| Name | Type |
|---|---|
address | SimpleCellAddress |
Returns: boolean
# addresses
▸ addresses(dependencyGraph: DependencyGraph): SimpleCellAddress[]
Defined in src/AbsoluteCellRange.ts:315 (opens new window)
Parameters:
| Name | Type |
|---|---|
dependencyGraph | DependencyGraph |
Returns: SimpleCellAddress[]
# addressesArrayMap
▸ addressesArrayMap‹T›(dependencyGraph: DependencyGraph, op: function): T[][]
Defined in src/AbsoluteCellRange.ts:299 (opens new window)
Type parameters:
▪ T
Parameters:
▪ dependencyGraph: DependencyGraph
▪ op: function
▸ (arg: SimpleCellAddress): T
Parameters:
| Name | Type |
|---|---|
arg | SimpleCellAddress |
Returns: T[][]
# addressesWithDirection
▸ addressesWithDirection(right: number, bottom: number, dependencyGraph: DependencyGraph): IterableIterator‹SimpleCellAddress›
Defined in src/AbsoluteCellRange.ts:331 (opens new window)
Parameters:
| Name | Type |
|---|---|
right | number |
bottom | number |
dependencyGraph | DependencyGraph |
Returns: IterableIterator‹SimpleCellAddress›
# arrayOfAddressesInRange
▸ arrayOfAddressesInRange(): SimpleCellAddress[][]
Defined in src/AbsoluteCellRange.ts:275 (opens new window)
Returns: SimpleCellAddress[][]
# columnInRange
▸ columnInRange(address: SimpleColumnAddress): boolean
Defined in src/AbsoluteCellRange.ts:168 (opens new window)
Parameters:
| Name | Type |
|---|---|
address | SimpleColumnAddress |
Returns: boolean
# containsRange
▸ containsRange(range: AbsoluteCellRange): boolean
Defined in src/AbsoluteCellRange.ts:182 (opens new window)
Parameters:
| Name | Type |
|---|---|
range | AbsoluteCellRange |
Returns: boolean
# doesOverlap
▸ doesOverlap(other: AbsoluteCellRange): boolean
Defined in src/AbsoluteCellRange.ts:144 (opens new window)
Parameters:
| Name | Type |
|---|---|
other | AbsoluteCellRange |
Returns: boolean
# effectiveEndColumn
▸ effectiveEndColumn(_dependencyGraph: DependencyGraph): number
Defined in src/AbsoluteCellRange.ts:390 (opens new window)
Parameters:
| Name | Type |
|---|---|
_dependencyGraph | DependencyGraph |
Returns: number
# effectiveEndRow
▸ effectiveEndRow(_dependencyGraph: DependencyGraph): number
Defined in src/AbsoluteCellRange.ts:394 (opens new window)
Parameters:
| Name | Type |
|---|---|
_dependencyGraph | DependencyGraph |
Returns: number
# effectiveHeight
▸ effectiveHeight(_dependencyGraph: DependencyGraph): number
Defined in src/AbsoluteCellRange.ts:402 (opens new window)
Parameters:
| Name | Type |
|---|---|
_dependencyGraph | DependencyGraph |
Returns: number
# effectiveWidth
▸ effectiveWidth(_dependencyGraph: DependencyGraph): number
Defined in src/AbsoluteCellRange.ts:398 (opens new window)
Parameters:
| Name | Type |
|---|---|
_dependencyGraph | DependencyGraph |
Returns: number
# exceedsSheetSizeLimits
▸ exceedsSheetSizeLimits(maxColumns: number, maxRows: number): boolean
Defined in src/AbsoluteCellRange.ts:386 (opens new window)
Parameters:
| Name | Type |
|---|---|
maxColumns | number |
maxRows | number |
Returns: boolean
# expandByColumns
▸ expandByColumns(numberOfColumns: number): void
Defined in src/AbsoluteCellRange.ts:230 (opens new window)
Parameters:
| Name | Type |
|---|---|
numberOfColumns | number |
Returns: void
# expandByRows
▸ expandByRows(numberOfRows: number): void
Defined in src/AbsoluteCellRange.ts:217 (opens new window)
Parameters:
| Name | Type |
|---|---|
numberOfRows | number |
Returns: void
# getAddress
▸ getAddress(col: number, row: number): SimpleCellAddress
Defined in src/AbsoluteCellRange.ts:379 (opens new window)
Parameters:
| Name | Type |
|---|---|
col | number |
row | number |
Returns: SimpleCellAddress
# height
▸ height(): number
Defined in src/AbsoluteCellRange.ts:267 (opens new window)
Returns: number
# includesColumn
▸ includesColumn(column: number): boolean
Defined in src/AbsoluteCellRange.ts:208 (opens new window)
Parameters:
| Name | Type |
|---|---|
column | number |
Returns: boolean
# includesRow
▸ includesRow(row: number): boolean
Defined in src/AbsoluteCellRange.ts:204 (opens new window)
Parameters:
| Name | Type |
|---|---|
row | number |
Returns: boolean
# intersectionWith
▸ intersectionWith(other: AbsoluteCellRange): Maybe‹AbsoluteCellRange›
Defined in src/AbsoluteCellRange.ts:186 (opens new window)
Parameters:
| Name | Type |
|---|---|
other | AbsoluteCellRange |
Returns: Maybe‹AbsoluteCellRange›
# isFinite
▸ isFinite(): boolean
Defined in src/AbsoluteCellRange.ts:140 (opens new window)
Returns: boolean
# moveToSheet
▸ moveToSheet(toSheet: number): void
Defined in src/AbsoluteCellRange.ts:234 (opens new window)
Parameters:
| Name | Type |
|---|---|
toSheet | number |
Returns: void
# rangeWithSameHeight
▸ rangeWithSameHeight(startColumn: number, numberOfColumns: number): AbsoluteCellRange
Defined in src/AbsoluteCellRange.ts:255 (opens new window)
Parameters:
| Name | Type |
|---|---|
startColumn | number |
numberOfColumns | number |
Returns: AbsoluteCellRange
# rangeWithSameWidth
▸ rangeWithSameWidth(startRow: number, numberOfRows: number): AbsoluteCellRange
Defined in src/AbsoluteCellRange.ts:251 (opens new window)
Parameters:
| Name | Type |
|---|---|
startRow | number |
numberOfRows | number |
Returns: AbsoluteCellRange
# removeSpan
▸ removeSpan(span: Span): void
Defined in src/AbsoluteCellRange.ts:239 (opens new window)
Parameters:
| Name | Type |
|---|---|
span | Span |
Returns: void
# rowInRange
▸ rowInRange(address: SimpleRowAddress): boolean
Defined in src/AbsoluteCellRange.ts:175 (opens new window)
Parameters:
| Name | Type |
|---|---|
address | SimpleRowAddress |
Returns: boolean
# sameAs
▸ sameAs(other: AbsoluteCellRange): boolean
Defined in src/AbsoluteCellRange.ts:295 (opens new window)
Parameters:
| Name | Type |
|---|---|
other | AbsoluteCellRange |
Returns: boolean
# sameDimensionsAs
▸ sameDimensionsAs(other: AbsoluteCellRange): boolean
Defined in src/AbsoluteCellRange.ts:291 (opens new window)
Parameters:
| Name | Type |
|---|---|
other | AbsoluteCellRange |
Returns: boolean
# shiftByColumns
▸ shiftByColumns(numberOfColumns: number): void
Defined in src/AbsoluteCellRange.ts:221 (opens new window)
Parameters:
| Name | Type |
|---|---|
numberOfColumns | number |
Returns: void
# shiftByRows
▸ shiftByRows(numberOfRows: number): void
Defined in src/AbsoluteCellRange.ts:212 (opens new window)
Parameters:
| Name | Type |
|---|---|
numberOfRows | number |
Returns: void
# shifted
▸ shifted(byCols: number, byRows: number): AbsoluteCellRange
Defined in src/AbsoluteCellRange.ts:226 (opens new window)
Parameters:
| Name | Type |
|---|---|
byCols | number |
byRows | number |
Returns: AbsoluteCellRange
# shouldBeRemoved
▸ shouldBeRemoved(): boolean
Defined in src/AbsoluteCellRange.ts:247 (opens new window)
Returns: boolean
# size
▸ size(): number
Defined in src/AbsoluteCellRange.ts:271 (opens new window)
Returns: number
# toString
▸ toString(): string
Defined in src/AbsoluteCellRange.ts:259 (opens new window)
Returns: string
# width
▸ width(): number
Defined in src/AbsoluteCellRange.ts:263 (opens new window)
Returns: number
# withStart
▸ withStart(newStart: SimpleCellAddress): AbsoluteCellRange
Defined in src/AbsoluteCellRange.ts:287 (opens new window)
Parameters:
| Name | Type |
|---|---|
newStart | SimpleCellAddress |
Returns: AbsoluteCellRange
# fromAst Static
▸ fromAst(ast: CellRangeAst | ColumnRangeAst | RowRangeAst, baseAddress: SimpleCellAddress): AbsoluteCellRange
Defined in src/AbsoluteCellRange.ts:83 (opens new window)
Parameters:
| Name | Type |
|---|---|
ast | CellRangeAst | ColumnRangeAst | RowRangeAst |
baseAddress | SimpleCellAddress |
Returns: AbsoluteCellRange
# fromAstOrUndef Static
▸ fromAstOrUndef(ast: CellRangeAst | ColumnRangeAst | RowRangeAst, baseAddress: SimpleCellAddress): Maybe‹AbsoluteCellRange›
Defined in src/AbsoluteCellRange.ts:93 (opens new window)
Parameters:
| Name | Type |
|---|---|
ast | CellRangeAst | ColumnRangeAst | RowRangeAst |
baseAddress | SimpleCellAddress |
Returns: Maybe‹AbsoluteCellRange›
# fromCellRange Static
▸ fromCellRange(x: CellRange, baseAddress: SimpleCellAddress): AbsoluteCellRange
Defined in src/AbsoluteCellRange.ts:101 (opens new window)
Parameters:
| Name | Type |
|---|---|
x | CellRange |
baseAddress | SimpleCellAddress |
Returns: AbsoluteCellRange
# fromCoordinates Static
▸ fromCoordinates(sheet: number, x1: number, y1: number, x2: number, y2: number): AbsoluteCellRange
Defined in src/AbsoluteCellRange.ts:136 (opens new window)
Parameters:
| Name | Type |
|---|---|
sheet | number |
x1 | number |
y1 | number |
x2 | number |
y2 | number |
Returns: AbsoluteCellRange
# fromSimpleCellAddresses Static
▸ fromSimpleCellAddresses(start: SimpleCellAddress, end: SimpleCellAddress): AbsoluteCellRange
Defined in src/AbsoluteCellRange.ts:64 (opens new window)
Parameters:
| Name | Type |
|---|---|
start | SimpleCellAddress |
end | SimpleCellAddress |
Returns: AbsoluteCellRange
# spanFrom Static
▸ spanFrom(topLeftCorner: SimpleCellAddress, width: number, height: number): AbsoluteCellRange
Defined in src/AbsoluteCellRange.ts:108 (opens new window)
Parameters:
| Name | Type |
|---|---|
topLeftCorner | SimpleCellAddress |
width | number |
height | number |
Returns: AbsoluteCellRange
# spanFromOrUndef Static
▸ spanFromOrUndef(topLeftCorner: SimpleCellAddress, width: number, height: number): Maybe‹AbsoluteCellRange›
Defined in src/AbsoluteCellRange.ts:116 (opens new window)
Parameters:
| Name | Type |
|---|---|
topLeftCorner | SimpleCellAddress |
width | number |
height | number |
Returns: Maybe‹AbsoluteCellRange›