2 # -----------------------------------------------------------------------------
5 use lib
($0 =~ m
|^(.*/)| ?
$1 : ".");
9 { local $/; $expected = <DATA
>; }
11 &message
("Check insert/delete col/row's effect on names.");
12 &sstest
("test_insdel_rowcol_names", $expected);
15 -----------------------------------------------------------------------------
16 Start
: test_insdel_rowcol_names
17 -----------------------------------------------------------------------------
20 Scope
=Sheet1 Name
="NAMEA1" Expr
=A1
21 Scope
=Sheet1 Name
="NAMEA1ABS" Expr
=$A$1
22 Scope
=Sheet1 Name
="NAMEA2" Expr
=A2
23 Scope
=Sheet1 Name
="NAMEA2ABS" Expr
=$A$2
24 Scope
=Sheet1 Name
="Print_Area" Expr
=Sheet1
!$1:$65536
25 Scope
=Sheet1 Name
="Sheet_Title" Expr
="Sheet1"
26 Scope
=Sheet2 Name
="Print_Area" Expr
=Sheet2
!$1:$65536
27 Scope
=Sheet2 Name
="Sheet_Title" Expr
="Sheet2"
28 Scope
=Global Name
="NAMEG2" Expr
=$A$14+Sheet1
!$A$14+Sheet2
!$A$14
29 Scope
=Global Name
="NAMEGA1" Expr
=A1
31 About to insert before column D on Sheet1
33 Scope
=Sheet1 Name
="NAMEA1" Expr
=A1
34 Scope
=Sheet1 Name
="NAMEA1ABS" Expr
=$A$1
35 Scope
=Sheet1 Name
="NAMEA2" Expr
=A2
36 Scope
=Sheet1 Name
="NAMEA2ABS" Expr
=$A$2
37 Scope
=Sheet1 Name
="Print_Area" Expr
=Sheet1
!$1:$65536
38 Scope
=Sheet1 Name
="Sheet_Title" Expr
="Sheet1"
39 Scope
=Sheet2 Name
="Print_Area" Expr
=Sheet2
!$1:$65536
40 Scope
=Sheet2 Name
="Sheet_Title" Expr
="Sheet2"
41 Scope
=Global Name
="NAMEG2" Expr
=$A$14+Sheet1
!$A$14+Sheet2
!$A$14
42 Scope
=Global Name
="NAMEGA1" Expr
=A1
46 About to insert before column C on Sheet1
48 Scope
=Sheet1 Name
="NAMEA1" Expr
=A1
49 Scope
=Sheet1 Name
="NAMEA1ABS" Expr
=$A$1
50 Scope
=Sheet1 Name
="NAMEA2" Expr
=A2
51 Scope
=Sheet1 Name
="NAMEA2ABS" Expr
=$A$2
52 Scope
=Sheet1 Name
="Print_Area" Expr
=Sheet1
!$1:$65536
53 Scope
=Sheet1 Name
="Sheet_Title" Expr
="Sheet1"
54 Scope
=Sheet2 Name
="Print_Area" Expr
=Sheet2
!$1:$65536
55 Scope
=Sheet2 Name
="Sheet_Title" Expr
="Sheet2"
56 Scope
=Global Name
="NAMEG2" Expr
=$A$14+Sheet1
!$A$14+Sheet2
!$A$14
57 Scope
=Global Name
="NAMEGA1" Expr
=A1
61 About to insert before column B on Sheet1
63 Scope
=Sheet1 Name
="NAMEA1" Expr
=A1
64 Scope
=Sheet1 Name
="NAMEA1ABS" Expr
=$A$1
65 Scope
=Sheet1 Name
="NAMEA2" Expr
=A2
66 Scope
=Sheet1 Name
="NAMEA2ABS" Expr
=$A$2
67 Scope
=Sheet1 Name
="Print_Area" Expr
=Sheet1
!$1:$65536
68 Scope
=Sheet1 Name
="Sheet_Title" Expr
="Sheet1"
69 Scope
=Sheet2 Name
="Print_Area" Expr
=Sheet2
!$1:$65536
70 Scope
=Sheet2 Name
="Sheet_Title" Expr
="Sheet2"
71 Scope
=Global Name
="NAMEG2" Expr
=$A$14+Sheet1
!$A$14+Sheet2
!$A$14
72 Scope
=Global Name
="NAMEGA1" Expr
=A1
76 About to insert before column A on Sheet1
78 Scope
=Sheet1 Name
="NAMEA1" Expr
=A1
79 Scope
=Sheet1 Name
="NAMEA1ABS" Expr
=$M$1
80 Scope
=Sheet1 Name
="NAMEA2" Expr
=A2
81 Scope
=Sheet1 Name
="NAMEA2ABS" Expr
=$M$2
82 Scope
=Sheet1 Name
="Print_Area" Expr
=Sheet1
!$1:$65536
83 Scope
=Sheet1 Name
="Sheet_Title" Expr
="Sheet1"
84 Scope
=Sheet2 Name
="Print_Area" Expr
=Sheet2
!$1:$65536
85 Scope
=Sheet2 Name
="Sheet_Title" Expr
="Sheet2"
86 Scope
=Global Name
="NAMEG2" Expr
=$A$14+Sheet1
!$M$14+Sheet2
!$A$14
87 Scope
=Global Name
="NAMEGA1" Expr
=A1
91 About to insert before column D on Sheet2
93 Scope
=Sheet1 Name
="NAMEA1" Expr
=A1
94 Scope
=Sheet1 Name
="NAMEA1ABS" Expr
=$A$1
95 Scope
=Sheet1 Name
="NAMEA2" Expr
=A2
96 Scope
=Sheet1 Name
="NAMEA2ABS" Expr
=$A$2
97 Scope
=Sheet1 Name
="Print_Area" Expr
=Sheet1
!$1:$65536
98 Scope
=Sheet1 Name
="Sheet_Title" Expr
="Sheet1"
99 Scope
=Sheet2 Name
="Print_Area" Expr
=Sheet2
!$1:$65536
100 Scope
=Sheet2 Name
="Sheet_Title" Expr
="Sheet2"
101 Scope
=Global Name
="NAMEG2" Expr
=$A$14+Sheet1
!$A$14+Sheet2
!$A$14
102 Scope
=Global Name
="NAMEGA1" Expr
=A1
103 Dumping names
... Done
106 About to insert before column C on Sheet2
108 Scope
=Sheet1 Name
="NAMEA1" Expr
=A1
109 Scope
=Sheet1 Name
="NAMEA1ABS" Expr
=$A$1
110 Scope
=Sheet1 Name
="NAMEA2" Expr
=A2
111 Scope
=Sheet1 Name
="NAMEA2ABS" Expr
=$A$2
112 Scope
=Sheet1 Name
="Print_Area" Expr
=Sheet1
!$1:$65536
113 Scope
=Sheet1 Name
="Sheet_Title" Expr
="Sheet1"
114 Scope
=Sheet2 Name
="Print_Area" Expr
=Sheet2
!$1:$65536
115 Scope
=Sheet2 Name
="Sheet_Title" Expr
="Sheet2"
116 Scope
=Global Name
="NAMEG2" Expr
=$A$14+Sheet1
!$A$14+Sheet2
!$A$14
117 Scope
=Global Name
="NAMEGA1" Expr
=A1
118 Dumping names
... Done
121 About to insert before column B on Sheet2
123 Scope
=Sheet1 Name
="NAMEA1" Expr
=A1
124 Scope
=Sheet1 Name
="NAMEA1ABS" Expr
=$A$1
125 Scope
=Sheet1 Name
="NAMEA2" Expr
=A2
126 Scope
=Sheet1 Name
="NAMEA2ABS" Expr
=$A$2
127 Scope
=Sheet1 Name
="Print_Area" Expr
=Sheet1
!$1:$65536
128 Scope
=Sheet1 Name
="Sheet_Title" Expr
="Sheet1"
129 Scope
=Sheet2 Name
="Print_Area" Expr
=Sheet2
!$1:$65536
130 Scope
=Sheet2 Name
="Sheet_Title" Expr
="Sheet2"
131 Scope
=Global Name
="NAMEG2" Expr
=$A$14+Sheet1
!$A$14+Sheet2
!$A$14
132 Scope
=Global Name
="NAMEGA1" Expr
=A1
133 Dumping names
... Done
136 About to insert before column A on Sheet2
138 Scope
=Sheet1 Name
="NAMEA1" Expr
=A1
139 Scope
=Sheet1 Name
="NAMEA1ABS" Expr
=$A$1
140 Scope
=Sheet1 Name
="NAMEA2" Expr
=A2
141 Scope
=Sheet1 Name
="NAMEA2ABS" Expr
=$A$2
142 Scope
=Sheet1 Name
="Print_Area" Expr
=Sheet1
!$1:$65536
143 Scope
=Sheet1 Name
="Sheet_Title" Expr
="Sheet1"
144 Scope
=Sheet2 Name
="Print_Area" Expr
=Sheet2
!$1:$65536
145 Scope
=Sheet2 Name
="Sheet_Title" Expr
="Sheet2"
146 Scope
=Global Name
="NAMEG2" Expr
=$A$14+Sheet1
!$A$14+Sheet2
!$M$14
147 Scope
=Global Name
="NAMEGA1" Expr
=A1
148 Dumping names
... Done
151 About to
delete column D on Sheet1
153 Scope
=Sheet1 Name
="NAMEA1" Expr
=A1
154 Scope
=Sheet1 Name
="NAMEA1ABS" Expr
=$A$1
155 Scope
=Sheet1 Name
="NAMEA2" Expr
=A2
156 Scope
=Sheet1 Name
="NAMEA2ABS" Expr
=$A$2
157 Scope
=Sheet1 Name
="Print_Area" Expr
=Sheet1
!$1:$65536
158 Scope
=Sheet1 Name
="Sheet_Title" Expr
="Sheet1"
159 Scope
=Sheet2 Name
="Print_Area" Expr
=Sheet2
!$1:$65536
160 Scope
=Sheet2 Name
="Sheet_Title" Expr
="Sheet2"
161 Scope
=Global Name
="NAMEG2" Expr
=$A$14+Sheet1
!$A$14+Sheet2
!$A$14
162 Scope
=Global Name
="NAMEGA1" Expr
=A1
163 Dumping names
... Done
166 About to
delete column C on Sheet1
168 Scope
=Sheet1 Name
="NAMEA1" Expr
=A1
169 Scope
=Sheet1 Name
="NAMEA1ABS" Expr
=$A$1
170 Scope
=Sheet1 Name
="NAMEA2" Expr
=A2
171 Scope
=Sheet1 Name
="NAMEA2ABS" Expr
=$A$2
172 Scope
=Sheet1 Name
="Print_Area" Expr
=Sheet1
!$1:$65536
173 Scope
=Sheet1 Name
="Sheet_Title" Expr
="Sheet1"
174 Scope
=Sheet2 Name
="Print_Area" Expr
=Sheet2
!$1:$65536
175 Scope
=Sheet2 Name
="Sheet_Title" Expr
="Sheet2"
176 Scope
=Global Name
="NAMEG2" Expr
=$A$14+Sheet1
!$A$14+Sheet2
!$A$14
177 Scope
=Global Name
="NAMEGA1" Expr
=A1
178 Dumping names
... Done
181 About to
delete column B on Sheet1
183 Scope
=Sheet1 Name
="NAMEA1" Expr
=A1
184 Scope
=Sheet1 Name
="NAMEA1ABS" Expr
=$A$1
185 Scope
=Sheet1 Name
="NAMEA2" Expr
=A2
186 Scope
=Sheet1 Name
="NAMEA2ABS" Expr
=$A$2
187 Scope
=Sheet1 Name
="Print_Area" Expr
=Sheet1
!$1:$65536
188 Scope
=Sheet1 Name
="Sheet_Title" Expr
="Sheet1"
189 Scope
=Sheet2 Name
="Print_Area" Expr
=Sheet2
!$1:$65536
190 Scope
=Sheet2 Name
="Sheet_Title" Expr
="Sheet2"
191 Scope
=Global Name
="NAMEG2" Expr
=$A$14+Sheet1
!$A$14+Sheet2
!$A$14
192 Scope
=Global Name
="NAMEGA1" Expr
=A1
193 Dumping names
... Done
196 About to
delete column A on Sheet1
198 Scope
=Sheet1 Name
="NAMEA1" Expr
=A1
199 Scope
=Sheet1 Name
="NAMEA1ABS" Expr
=#REF!
200 Scope
=Sheet1 Name
="NAMEA2" Expr
=A2
201 Scope
=Sheet1 Name
="NAMEA2ABS" Expr
=#REF!
202 Scope
=Sheet1 Name
="Print_Area" Expr
=Sheet1
!$1:$65536
203 Scope
=Sheet1 Name
="Sheet_Title" Expr
="Sheet1"
204 Scope
=Sheet2 Name
="Print_Area" Expr
=Sheet2
!$1:$65536
205 Scope
=Sheet2 Name
="Sheet_Title" Expr
="Sheet2"
206 Scope
=Global Name
="NAMEG2" Expr
=$A$14+#REF!+Sheet2!$A$14
207 Scope
=Global Name
="NAMEGA1" Expr
=A1
208 Dumping names
... Done
211 End
: test_insdel_rowcol_names