Function offsetReferences

  • All references moved, also absolute ones – e.g. for an export whose cells start elsewhere (a header row above).

    Parameters

    • source: string

      the formula (without =)

    • dRow: number

      rows

    • dCol: number

      columns

    Returns string

    the formula

    Example

    offsetReferences("$F$1*B2", 1, 0);   // "$F$2*B3"

    Since

    1.1.99

Settings

Member Visibility

Theme