A1 class

Implemented types

Constructors

A1.fromVector(int column, int row, {bool columnAbsolute = false, bool rowAbsolute = false})
Create an A1 from column and row

Properties

column → int
Return the column as a zero based int
no setter
columnAbsolute → bool
Whether the column reference is absolute ($)
final
digits ↔ int
Digits for the 1 in the A1 notation
latefinal
down → A1
Returns the A1 below the current A1
no setter
hashCode → int
Returns a hash code for a numerical value.
no setteroverride
left → A1
Returns the A1 to the left of the current A1 if already in column 0 will return a copy of the current cell
no setter
letters ↔ String
Uppercase letters for the A part of A1 notation
latefinal
Returns the A1 to the right of the current A1
no setter
row → int
Return the row as a zero based int
no setter
rowAbsolute → bool
Whether the row reference is absolute ($)
final
runtimeType → Type
A representation of the runtime type of the object.
no setterinherited
self → A1
Utility for self reference in new pattern matching
no setter
up → A1
Returns the A1 above the current A1 if already in row 0 will return a copy of the current cell
no setter
vector → (int, int)
Returns a (column, row) vector representing the A1
no setter

Methods

area(A1? other) → double
compareTo(A1 other) → int
Compares this to other A1.
override
copyWith({bool? columnAbsolute, bool? rowAbsolute}) → A1
Copy with different absolute flags
noSuchMethod(Invocation invocation) → dynamic
Invoked when a nonexistent method or property is accessed.
inherited
pageDown(int page) → A1
Returns the A1 pageDown page relative to the current A1
pageUp(int page) → A1
Returns the A1 pageDown page relative to the current A1
rangeTo(A1 to) → List<A1>
Create a list of A1's between this A1 and to
toString() → String
Return a String of the A1
override

Operators

operator +(A1 other) → A1
Sum operator for two A1s
operator <(A1 other) → bool
operator <=(A1 other) → bool
operator ==(Object other) → bool
Test whether this A1 is equal to other.
override
operator >(A1 other) → bool
operator >=(A1 other) → bool

Static Properties

maxColumns → int
final
maxRows → int
Total number of rows and columns on a worksheet 1,048,576 rows by 16,384 columns
final

Static Methods

parse(String input) → A1
Parses a string containing an A1 literal into an A1.
tryParse(String input) → A1?
Parses a string containing an A1 literal into an A1.