test/t2000-names-insdel.pl

   1 #!/usr/bin/perl -w
   2 # -----------------------------------------------------------------------------
   3
   4 use strict;
   5 use lib ($0 =~ m|^(.*/)| ? $1 : ".");
   6 use GnumericTest;
   7
   8 my $expected;
   9 { local $/; $expected = <DATA>; }
  10
  11 &message ("Check insert/delete col/row's effect on names.");
  12 &sstest ("test_insdel_rowcol_names", $expected);
  13
  14 __DATA__
  15 -----------------------------------------------------------------------------
  16 Start: test_insdel_rowcol_names
  17 -----------------------------------------------------------------------------
  18
  19 Dumping names...
  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
  30 Dumping names... Done
  31 About to insert before column D on Sheet1
  32 Dumping names...
  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
  43 Dumping names... Done
  44 Undoing.
  45 Done.
  46 About to insert before column C on Sheet1
  47 Dumping names...
  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
  58 Dumping names... Done
  59 Undoing.
  60 Done.
  61 About to insert before column B on Sheet1
  62 Dumping names...
  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
  73 Dumping names... Done
  74 Undoing.
  75 Done.
  76 About to insert before column A on Sheet1
  77 Dumping names...
  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
  88 Dumping names... Done
  89 Undoing.
  90 Done.
  91 About to insert before column D on Sheet2
  92 Dumping names...
  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
 104 Undoing.
 105 Done.
 106 About to insert before column C on Sheet2
 107 Dumping names...
 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
 119 Undoing.
 120 Done.
 121 About to insert before column B on Sheet2
 122 Dumping names...
 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
 134 Undoing.
 135 Done.
 136 About to insert before column A on Sheet2
 137 Dumping names...
 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
 149 Undoing.
 150 Done.
 151 About to delete column D on Sheet1
 152 Dumping names...
 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
 164 Undoing.
 165 Done.
 166 About to delete column C on Sheet1
 167 Dumping names...
 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
 179 Undoing.
 180 Done.
 181 About to delete column B on Sheet1
 182 Dumping names...
 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
 194 Undoing.
 195 Done.
 196 About to delete column A on Sheet1
 197 Dumping names...
 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
 209 Undoing.
 210 Done.
 211 End: test_insdel_rowcol_names