Function toCellAddress

  • The address of a cell: toCellAddress(2, 1) → "B3", with $ for absolute parts.

    Parameters

    • row: number

      0-based row

    • col: number

      0-based column

    • Optional abs: {
          absCol?: boolean;
          absRow?: boolean;
      } = {}

      $ before the row / column

      • Optional absCol?: boolean
      • Optional absRow?: boolean

    Returns string

    the address, "#REF!" outside the sheet

    Example

    toCellAddress(0, 5, { absRow: true, absCol: true });   // "$F$1"

    Since

    1.1.99

Settings

Member Visibility

Theme