Parses a range like "A1:B5", "$A$1:B5", "A:A", "B:D", "3:3" or a single cell "C7". The corners are sorted ("B5:A1" = "A1:B5").
"A1:B5"
"$A$1:B5"
"A:A"
"B:D"
"3:3"
"C7"
"B5:A1"
the range
the range; undefined if invalid
undefined
parseRangeAddress("A:A")?.to.row; // 1048575 Copy
parseRangeAddress("A:A")?.to.row; // 1048575
1.1.99
Parses a range like
"A1:B5","$A$1:B5","A:A","B:D","3:3"or a single cell"C7". The corners are sorted ("B5:A1"="A1:B5").