1#!/usr/bin/perl -w 2# ----------------------------------------------------------------------------- 3 4use strict; 5use lib ($0 =~ m|^(.*/)| ? $1 : "."); 6use GnumericTest; 7 8my $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----------------------------------------------------------------------------- 16Start: test_insdel_rowcol_names 17----------------------------------------------------------------------------- 18 19Dumping names... 20Scope=Sheet1 Name="NAMEA1" Expr=A1 21Scope=Sheet1 Name="NAMEA1ABS" Expr=$A$1 22Scope=Sheet1 Name="NAMEA2" Expr=A2 23Scope=Sheet1 Name="NAMEA2ABS" Expr=$A$2 24Scope=Sheet1 Name="Print_Area" Expr=Sheet1!$1:$65536 25Scope=Sheet1 Name="Sheet_Title" Expr="Sheet1" 26Scope=Sheet2 Name="Print_Area" Expr=Sheet2!$1:$65536 27Scope=Sheet2 Name="Sheet_Title" Expr="Sheet2" 28Scope=Global Name="NAMEG2" Expr=$A$14+Sheet1!$A$14+Sheet2!$A$14 29Scope=Global Name="NAMEGA1" Expr=A1 30Dumping names... Done 31About to insert before column D on Sheet1 32Dumping names... 33Scope=Sheet1 Name="NAMEA1" Expr=A1 34Scope=Sheet1 Name="NAMEA1ABS" Expr=$A$1 35Scope=Sheet1 Name="NAMEA2" Expr=A2 36Scope=Sheet1 Name="NAMEA2ABS" Expr=$A$2 37Scope=Sheet1 Name="Print_Area" Expr=Sheet1!$1:$65536 38Scope=Sheet1 Name="Sheet_Title" Expr="Sheet1" 39Scope=Sheet2 Name="Print_Area" Expr=Sheet2!$1:$65536 40Scope=Sheet2 Name="Sheet_Title" Expr="Sheet2" 41Scope=Global Name="NAMEG2" Expr=$A$14+Sheet1!$A$14+Sheet2!$A$14 42Scope=Global Name="NAMEGA1" Expr=A1 43Dumping names... Done 44Undoing. 45Done. 46About to insert before column C on Sheet1 47Dumping names... 48Scope=Sheet1 Name="NAMEA1" Expr=A1 49Scope=Sheet1 Name="NAMEA1ABS" Expr=$A$1 50Scope=Sheet1 Name="NAMEA2" Expr=A2 51Scope=Sheet1 Name="NAMEA2ABS" Expr=$A$2 52Scope=Sheet1 Name="Print_Area" Expr=Sheet1!$1:$65536 53Scope=Sheet1 Name="Sheet_Title" Expr="Sheet1" 54Scope=Sheet2 Name="Print_Area" Expr=Sheet2!$1:$65536 55Scope=Sheet2 Name="Sheet_Title" Expr="Sheet2" 56Scope=Global Name="NAMEG2" Expr=$A$14+Sheet1!$A$14+Sheet2!$A$14 57Scope=Global Name="NAMEGA1" Expr=A1 58Dumping names... Done 59Undoing. 60Done. 61About to insert before column B on Sheet1 62Dumping names... 63Scope=Sheet1 Name="NAMEA1" Expr=A1 64Scope=Sheet1 Name="NAMEA1ABS" Expr=$A$1 65Scope=Sheet1 Name="NAMEA2" Expr=A2 66Scope=Sheet1 Name="NAMEA2ABS" Expr=$A$2 67Scope=Sheet1 Name="Print_Area" Expr=Sheet1!$1:$65536 68Scope=Sheet1 Name="Sheet_Title" Expr="Sheet1" 69Scope=Sheet2 Name="Print_Area" Expr=Sheet2!$1:$65536 70Scope=Sheet2 Name="Sheet_Title" Expr="Sheet2" 71Scope=Global Name="NAMEG2" Expr=$A$14+Sheet1!$A$14+Sheet2!$A$14 72Scope=Global Name="NAMEGA1" Expr=A1 73Dumping names... Done 74Undoing. 75Done. 76About to insert before column A on Sheet1 77Dumping names... 78Scope=Sheet1 Name="NAMEA1" Expr=A1 79Scope=Sheet1 Name="NAMEA1ABS" Expr=$M$1 80Scope=Sheet1 Name="NAMEA2" Expr=A2 81Scope=Sheet1 Name="NAMEA2ABS" Expr=$M$2 82Scope=Sheet1 Name="Print_Area" Expr=Sheet1!$1:$65536 83Scope=Sheet1 Name="Sheet_Title" Expr="Sheet1" 84Scope=Sheet2 Name="Print_Area" Expr=Sheet2!$1:$65536 85Scope=Sheet2 Name="Sheet_Title" Expr="Sheet2" 86Scope=Global Name="NAMEG2" Expr=$A$14+Sheet1!$M$14+Sheet2!$A$14 87Scope=Global Name="NAMEGA1" Expr=A1 88Dumping names... Done 89Undoing. 90Done. 91About to insert before column D on Sheet2 92Dumping names... 93Scope=Sheet1 Name="NAMEA1" Expr=A1 94Scope=Sheet1 Name="NAMEA1ABS" Expr=$A$1 95Scope=Sheet1 Name="NAMEA2" Expr=A2 96Scope=Sheet1 Name="NAMEA2ABS" Expr=$A$2 97Scope=Sheet1 Name="Print_Area" Expr=Sheet1!$1:$65536 98Scope=Sheet1 Name="Sheet_Title" Expr="Sheet1" 99Scope=Sheet2 Name="Print_Area" Expr=Sheet2!$1:$65536 100Scope=Sheet2 Name="Sheet_Title" Expr="Sheet2" 101Scope=Global Name="NAMEG2" Expr=$A$14+Sheet1!$A$14+Sheet2!$A$14 102Scope=Global Name="NAMEGA1" Expr=A1 103Dumping names... Done 104Undoing. 105Done. 106About to insert before column C on Sheet2 107Dumping names... 108Scope=Sheet1 Name="NAMEA1" Expr=A1 109Scope=Sheet1 Name="NAMEA1ABS" Expr=$A$1 110Scope=Sheet1 Name="NAMEA2" Expr=A2 111Scope=Sheet1 Name="NAMEA2ABS" Expr=$A$2 112Scope=Sheet1 Name="Print_Area" Expr=Sheet1!$1:$65536 113Scope=Sheet1 Name="Sheet_Title" Expr="Sheet1" 114Scope=Sheet2 Name="Print_Area" Expr=Sheet2!$1:$65536 115Scope=Sheet2 Name="Sheet_Title" Expr="Sheet2" 116Scope=Global Name="NAMEG2" Expr=$A$14+Sheet1!$A$14+Sheet2!$A$14 117Scope=Global Name="NAMEGA1" Expr=A1 118Dumping names... Done 119Undoing. 120Done. 121About to insert before column B on Sheet2 122Dumping names... 123Scope=Sheet1 Name="NAMEA1" Expr=A1 124Scope=Sheet1 Name="NAMEA1ABS" Expr=$A$1 125Scope=Sheet1 Name="NAMEA2" Expr=A2 126Scope=Sheet1 Name="NAMEA2ABS" Expr=$A$2 127Scope=Sheet1 Name="Print_Area" Expr=Sheet1!$1:$65536 128Scope=Sheet1 Name="Sheet_Title" Expr="Sheet1" 129Scope=Sheet2 Name="Print_Area" Expr=Sheet2!$1:$65536 130Scope=Sheet2 Name="Sheet_Title" Expr="Sheet2" 131Scope=Global Name="NAMEG2" Expr=$A$14+Sheet1!$A$14+Sheet2!$A$14 132Scope=Global Name="NAMEGA1" Expr=A1 133Dumping names... Done 134Undoing. 135Done. 136About to insert before column A on Sheet2 137Dumping names... 138Scope=Sheet1 Name="NAMEA1" Expr=A1 139Scope=Sheet1 Name="NAMEA1ABS" Expr=$A$1 140Scope=Sheet1 Name="NAMEA2" Expr=A2 141Scope=Sheet1 Name="NAMEA2ABS" Expr=$A$2 142Scope=Sheet1 Name="Print_Area" Expr=Sheet1!$1:$65536 143Scope=Sheet1 Name="Sheet_Title" Expr="Sheet1" 144Scope=Sheet2 Name="Print_Area" Expr=Sheet2!$1:$65536 145Scope=Sheet2 Name="Sheet_Title" Expr="Sheet2" 146Scope=Global Name="NAMEG2" Expr=$A$14+Sheet1!$A$14+Sheet2!$M$14 147Scope=Global Name="NAMEGA1" Expr=A1 148Dumping names... Done 149Undoing. 150Done. 151About to delete column D on Sheet1 152Dumping names... 153Scope=Sheet1 Name="NAMEA1" Expr=A1 154Scope=Sheet1 Name="NAMEA1ABS" Expr=$A$1 155Scope=Sheet1 Name="NAMEA2" Expr=A2 156Scope=Sheet1 Name="NAMEA2ABS" Expr=$A$2 157Scope=Sheet1 Name="Print_Area" Expr=Sheet1!$1:$65536 158Scope=Sheet1 Name="Sheet_Title" Expr="Sheet1" 159Scope=Sheet2 Name="Print_Area" Expr=Sheet2!$1:$65536 160Scope=Sheet2 Name="Sheet_Title" Expr="Sheet2" 161Scope=Global Name="NAMEG2" Expr=$A$14+Sheet1!$A$14+Sheet2!$A$14 162Scope=Global Name="NAMEGA1" Expr=A1 163Dumping names... Done 164Undoing. 165Done. 166About to delete column C on Sheet1 167Dumping names... 168Scope=Sheet1 Name="NAMEA1" Expr=A1 169Scope=Sheet1 Name="NAMEA1ABS" Expr=$A$1 170Scope=Sheet1 Name="NAMEA2" Expr=A2 171Scope=Sheet1 Name="NAMEA2ABS" Expr=$A$2 172Scope=Sheet1 Name="Print_Area" Expr=Sheet1!$1:$65536 173Scope=Sheet1 Name="Sheet_Title" Expr="Sheet1" 174Scope=Sheet2 Name="Print_Area" Expr=Sheet2!$1:$65536 175Scope=Sheet2 Name="Sheet_Title" Expr="Sheet2" 176Scope=Global Name="NAMEG2" Expr=$A$14+Sheet1!$A$14+Sheet2!$A$14 177Scope=Global Name="NAMEGA1" Expr=A1 178Dumping names... Done 179Undoing. 180Done. 181About to delete column B on Sheet1 182Dumping names... 183Scope=Sheet1 Name="NAMEA1" Expr=A1 184Scope=Sheet1 Name="NAMEA1ABS" Expr=$A$1 185Scope=Sheet1 Name="NAMEA2" Expr=A2 186Scope=Sheet1 Name="NAMEA2ABS" Expr=$A$2 187Scope=Sheet1 Name="Print_Area" Expr=Sheet1!$1:$65536 188Scope=Sheet1 Name="Sheet_Title" Expr="Sheet1" 189Scope=Sheet2 Name="Print_Area" Expr=Sheet2!$1:$65536 190Scope=Sheet2 Name="Sheet_Title" Expr="Sheet2" 191Scope=Global Name="NAMEG2" Expr=$A$14+Sheet1!$A$14+Sheet2!$A$14 192Scope=Global Name="NAMEGA1" Expr=A1 193Dumping names... Done 194Undoing. 195Done. 196About to delete column A on Sheet1 197Dumping names... 198Scope=Sheet1 Name="NAMEA1" Expr=A1 199Scope=Sheet1 Name="NAMEA1ABS" Expr=#REF! 200Scope=Sheet1 Name="NAMEA2" Expr=A2 201Scope=Sheet1 Name="NAMEA2ABS" Expr=#REF! 202Scope=Sheet1 Name="Print_Area" Expr=Sheet1!$1:$65536 203Scope=Sheet1 Name="Sheet_Title" Expr="Sheet1" 204Scope=Sheet2 Name="Print_Area" Expr=Sheet2!$1:$65536 205Scope=Sheet2 Name="Sheet_Title" Expr="Sheet2" 206Scope=Global Name="NAMEG2" Expr=$A$14+#REF!+Sheet2!$A$14 207Scope=Global Name="NAMEGA1" Expr=A1 208Dumping names... Done 209Undoing. 210Done. 211End: test_insdel_rowcol_names 212