The different ways to identify a range within a sheet, supporting both relative and absolute (fixed) addressing.
Accepts:
ICellRange
string
IRange.Coords
$fixed
ICellRange.Address
const address1: Address = "A1:B2"; // Relative addressing (A1 notation)const address2: Address = "$A$1:$B$2"; // Absolute addressing (A1 notation) Copy
const address1: Address = "A1:B2"; // Relative addressing (A1 notation)const address2: Address = "$A$1:$B$2"; // Absolute addressing (A1 notation)
The different ways to identify a range within a sheet, supporting both relative and absolute (fixed) addressing.
Accepts:
ICellRangestringrepresenting a range address (e.g., A1 or $A$1 notation).IRange.Coordsobject (specifying at least some of the range boundaries), optionally with a$fixedflag to indicate absolute addressing.ICellRange.Address(representing a single cell within the sheet), optionally with a$fixedflag to indicate absolute addressing.