1Excel::Template::ElemenUts:e:rRaCnognet(r3i)buted Perl DEoxccuemle:n:tTaetmipolnate::Element::Range(3)
2
3
4
6 Excel::Template::Element::Range - Excel::Template::Element::Range
7
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
14 RANGE
15
17 Excel::Template::Element
18
20 • REF
21
22 This is the name of the reference to look up.
23
25 None
26
28 None
29
31 This will only be used within CELL tags.
32
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
46 Rob Kinyon (rkinyon@columbus.rr.com)
47
49 CELL, BACKREF
50
51
52
53perl v5.36.0 2023-01-20Excel::Template::Element::Range(3)