PURPOSE

Returns a range of cell locations (i.e. B2:C2) that contains all calls using this reference. To return the location of the last cell, use \s-1BACKREF\s0.

NODE NAME

\s-1RANGE\s0

INHERITANCE

Excel::Template::Element

ATTRIBUTES

  • \s-1REF\s0 This is the name of the reference to look up.

CHILDREN

None

EFFECTS

None

DEPENDENCIES

This will only be used within \s-1CELL\s0 tags.

USAGE

In the example...

  <row>
    <cell ref="this_cell"/><cell ref="that_cell"><cell ref="that_cell">
  </row>
  <row>
    <formula>=SUM(<range ref="that_cell">)</formula>
  </row>

The formula in row 2 would be =SUM(B1:C1).

AUTHOR

Rob Kinyon ([email protected])

RELATED TO Excel::Template::Element::Range…

\s-1CELL\s0, \s-1BACKREF\s0