1Excel::Template::ElemenUts:e:rRaCnognet(r3i)buted Perl DEoxccuemle:n:tTaetmipolnate::Element::Range(3)
2
3
4

NAME

6       Excel::Template::Element::Range - Excel::Template::Element::Range
7

PURPOSE

9       Returns a range of cell locations (i.e. B2:C2) that contains all calls
10       using this reference. To return the location of the last cell, use
11       BACKREF.
12

NODE NAME

14       RANGE
15

INHERITANCE

17       Excel::Template::Element
18

ATTRIBUTES

20       ยท   REF
21
22           This is the name of the reference to look up.
23

CHILDREN

25       None
26

EFFECTS

28       None
29

DEPENDENCIES

31       This will only be used within CELL tags.
32

USAGE

34       In the example...
35
36         <row>
37           <cell ref="this_cell"/><cell ref="that_cell"><cell ref="that_cell">
38         </row>
39         <row>
40           <formula>=SUM(<range ref="that_cell">)</formula>
41         </row>
42
43       The formula in row 2 would be =SUM(B1:C1).
44

AUTHOR

46       Rob Kinyon (rkinyon@columbus.rr.com)
47

SEE ALSO

49       CELL, BACKREF
50
51
52
53perl v5.32.0                      2020-07-28Excel::Template::Element::Range(3)
Impressum