Code Duplication    Length = 18-18 lines in 2 locations

app/Vendor/PHPExcel/PHPExcel/Calculation/LookupRef.php 2 locations

@@ 120-137 (lines=18) @@
117
				$columnKey = preg_replace('/[^a-z]/i','',$columnKey);
118
				return (integer) PHPExcel_Cell::columnIndexFromString($columnKey);
119
			}
120
		} else {
121
			if (strpos($cellAddress,'!') !== false) {
122
				list($sheet,$cellAddress) = explode('!',$cellAddress);
123
			}
124
			if (strpos($cellAddress,':') !== false) {
125
				list($startAddress,$endAddress) = explode(':',$cellAddress);
126
				$startAddress = preg_replace('/[^a-z]/i','',$startAddress);
127
				$endAddress = preg_replace('/[^a-z]/i','',$endAddress);
128
				$returnValue = array();
129
				do {
130
					$returnValue[] = (integer) PHPExcel_Cell::columnIndexFromString($startAddress);
131
				} while ($startAddress++ != $endAddress);
132
				return $returnValue;
133
			} else {
134
				$cellAddress = preg_replace('/[^a-z]/i','',$cellAddress);
135
				return (integer) PHPExcel_Cell::columnIndexFromString($cellAddress);
136
			}
137
		}
138
	}	//	function COLUMN()
139
140
@@ 195-212 (lines=18) @@
192
					return (integer) preg_replace('/[^0-9]/i','',$rowKey);
193
				}
194
			}
195
		} else {
196
			if (strpos($cellAddress,'!') !== false) {
197
				list($sheet,$cellAddress) = explode('!',$cellAddress);
198
			}
199
			if (strpos($cellAddress,':') !== false) {
200
				list($startAddress,$endAddress) = explode(':',$cellAddress);
201
				$startAddress = preg_replace('/[^0-9]/','',$startAddress);
202
				$endAddress = preg_replace('/[^0-9]/','',$endAddress);
203
				$returnValue = array();
204
				do {
205
					$returnValue[][] = (integer) $startAddress;
206
				} while ($startAddress++ != $endAddress);
207
				return $returnValue;
208
			} else {
209
				list($cellAddress) = explode(':',$cellAddress);
210
				return (integer) preg_replace('/[^0-9]/','',$cellAddress);
211
			}
212
		}
213
	}	//	function ROW()
214
215