a1 library

A1 Notation

The simplest form refers to a single cell with column letter and a row number. eg. A1.

A typical cell reference in "A1" style consists of one or two case-insensitive letters to identify the column (if there are up to 256 columns: A–Z and AA–IV) followed by a row number (e.g., in the range 1–65536). Either part can be relative (it changes when the formula it is in is moved or copied), or absolute (indicated with $ in front of the part concerned of the cell reference).

The alternative "R1C1" reference style consists of the letter R, the row number, the letter C, and the column number; relative row or column numbers are indicated by enclosing the number in square brackets. Most current spreadsheets use the A1 style, some providing the R1C1 style as a compatibility option.

See also:

• Spreadsheet on Wikipedia
• A1..explained
• Google Sheets

Classes

A1

A1Partial

A1Range

A1Reference

Extensions

A1Tools on int

Utility extension to help the comparison be more expressive

MapA1Extension on Map<String, String>

This extension allows a Map<String,String> to be converted to a [Map<A1,A1> to assist with cell movement tracking

StringA1Extension on String

This extension allows an A1 to be create from a String

StringA1RangeExtension on String

This extension allows an A1Range to be create from a String

StringA1ReferenceExtension on String

This extension allows an A1Reference to be create from a String

StringListA1Extension on List<String>

This extension allows a List of Strings to be converted to a List of A1

StringSetA1Extension on Set<String>

This extension allows a Set of Strings to be converted to a Set of A1