/** * Formula Address Utilities — Shared helpers for address parsing and conversion. * * These pure functions are used across the compile, runtime, and materialize * layers. Centralizing them here eliminates duplication and ensures consistent * behavior. * * ## Design Constraint * * This module must NOT import from `@excel/utils/col-cache` or any live * workbook type. All functions are self-contained. */ /** * Convert a column letter string (e.g. "A", "AA", "XFD") to a 1-based number. * * - `"A"` → 1 * - `"Z"` → 26 * - `"AA"` → 27 * - `"XFD"` → 16384 */ export declare function colLetterToNumber(col: string): number; /** * A parsed defined-name range reference. */ export interface ParsedNameRange { readonly sheet: string; readonly startRow: number; readonly startCol: number; readonly endRow: number; readonly endCol: number; } /** * Parse a defined-name range string like `"Sheet1!$A$1:$B$2"` or `"'Sheet Name'!$C$3"` * into a `ParsedNameRange`. Returns `null` if the format is unrecognized. */ export declare function parseDefinedNameRange(rangeStr: string): ParsedNameRange | null; /** * A parsed simple cell address (no sheet name). */ export interface ParsedAddress { readonly row: number; readonly col: number; } /** * Parse a simple cell address like `"A1"`, `"$B$2"`, or `"AA100"`. * Dollar signs are stripped. Returns `null` on parse failure. */ export declare function parseSimpleAddress(addr: string): ParsedAddress | null; /** * A parsed rectangular range (no sheet name). */ export interface ParsedRefRange { readonly top: number; readonly left: number; readonly bottom: number; readonly right: number; } /** * Parse a cell range string like `"A1:B2"` into a `ParsedRefRange`. * Returns `null` if the format is unrecognized. */ export declare function parseRefRange(ref: string): ParsedRefRange | null;