Code Duplication    Length = 15-15 lines in 8 locations

app/Vendor/PHPExcel/PHPExcel/Reader/Excel5.php 8 locations

@@ 2209-2223 (lines=15) @@
2206
				$extData = substr($recordData, $offset + 4, $cb);
2207
2208
				switch ($extType) {
2209
					case 4:		// fill start color
2210
						$xclfType  = self::_GetInt2d($extData, 0); // color type
2211
						$xclrValue = substr($extData, 4, 4); // color value (value based on color type)
2212
2213
						if ($xclfType == 2) {
2214
							$rgb = sprintf('%02X%02X%02X', ord($xclrValue{0}), ord($xclrValue{1}), ord($xclrValue{2}));
2215
2216
							// modify the relevant style property
2217
							if ( isset($this->_mapCellXfIndex[$ixfe]) ) {
2218
								$fill = $this->_phpExcel->getCellXfByIndex($this->_mapCellXfIndex[$ixfe])->getFill();
2219
								$fill->getStartColor()->setRGB($rgb);
2220
								unset($fill->startcolorIndex); // normal color index does not apply, discard
2221
							}
2222
						}
2223
						break;
2224
2225
					case 5:		// fill end color
2226
						$xclfType  = self::_GetInt2d($extData, 0); // color type
@@ 2225-2239 (lines=15) @@
2222
						}
2223
						break;
2224
2225
					case 5:		// fill end color
2226
						$xclfType  = self::_GetInt2d($extData, 0); // color type
2227
						$xclrValue = substr($extData, 4, 4); // color value (value based on color type)
2228
2229
						if ($xclfType == 2) {
2230
							$rgb = sprintf('%02X%02X%02X', ord($xclrValue{0}), ord($xclrValue{1}), ord($xclrValue{2}));
2231
2232
							// modify the relevant style property
2233
							if ( isset($this->_mapCellXfIndex[$ixfe]) ) {
2234
								$fill = $this->_phpExcel->getCellXfByIndex($this->_mapCellXfIndex[$ixfe])->getFill();
2235
								$fill->getEndColor()->setRGB($rgb);
2236
								unset($fill->endcolorIndex); // normal color index does not apply, discard
2237
							}
2238
						}
2239
						break;
2240
2241
					case 7:		// border color top
2242
						$xclfType  = self::_GetInt2d($extData, 0); // color type
@@ 2241-2255 (lines=15) @@
2238
						}
2239
						break;
2240
2241
					case 7:		// border color top
2242
						$xclfType  = self::_GetInt2d($extData, 0); // color type
2243
						$xclrValue = substr($extData, 4, 4); // color value (value based on color type)
2244
2245
						if ($xclfType == 2) {
2246
							$rgb = sprintf('%02X%02X%02X', ord($xclrValue{0}), ord($xclrValue{1}), ord($xclrValue{2}));
2247
2248
							// modify the relevant style property
2249
							if ( isset($this->_mapCellXfIndex[$ixfe]) ) {
2250
								$top = $this->_phpExcel->getCellXfByIndex($this->_mapCellXfIndex[$ixfe])->getBorders()->getTop();
2251
								$top->getColor()->setRGB($rgb);
2252
								unset($top->colorIndex); // normal color index does not apply, discard
2253
							}
2254
						}
2255
						break;
2256
2257
					case 8:		// border color bottom
2258
						$xclfType  = self::_GetInt2d($extData, 0); // color type
@@ 2257-2271 (lines=15) @@
2254
						}
2255
						break;
2256
2257
					case 8:		// border color bottom
2258
						$xclfType  = self::_GetInt2d($extData, 0); // color type
2259
						$xclrValue = substr($extData, 4, 4); // color value (value based on color type)
2260
2261
						if ($xclfType == 2) {
2262
							$rgb = sprintf('%02X%02X%02X', ord($xclrValue{0}), ord($xclrValue{1}), ord($xclrValue{2}));
2263
2264
							// modify the relevant style property
2265
							if ( isset($this->_mapCellXfIndex[$ixfe]) ) {
2266
								$bottom = $this->_phpExcel->getCellXfByIndex($this->_mapCellXfIndex[$ixfe])->getBorders()->getBottom();
2267
								$bottom->getColor()->setRGB($rgb);
2268
								unset($bottom->colorIndex); // normal color index does not apply, discard
2269
							}
2270
						}
2271
						break;
2272
2273
					case 9:		// border color left
2274
						$xclfType  = self::_GetInt2d($extData, 0); // color type
@@ 2273-2287 (lines=15) @@
2270
						}
2271
						break;
2272
2273
					case 9:		// border color left
2274
						$xclfType  = self::_GetInt2d($extData, 0); // color type
2275
						$xclrValue = substr($extData, 4, 4); // color value (value based on color type)
2276
2277
						if ($xclfType == 2) {
2278
							$rgb = sprintf('%02X%02X%02X', ord($xclrValue{0}), ord($xclrValue{1}), ord($xclrValue{2}));
2279
2280
							// modify the relevant style property
2281
							if ( isset($this->_mapCellXfIndex[$ixfe]) ) {
2282
								$left = $this->_phpExcel->getCellXfByIndex($this->_mapCellXfIndex[$ixfe])->getBorders()->getLeft();
2283
								$left->getColor()->setRGB($rgb);
2284
								unset($left->colorIndex); // normal color index does not apply, discard
2285
							}
2286
						}
2287
						break;
2288
2289
					case 10:		// border color right
2290
						$xclfType  = self::_GetInt2d($extData, 0); // color type
@@ 2289-2303 (lines=15) @@
2286
						}
2287
						break;
2288
2289
					case 10:		// border color right
2290
						$xclfType  = self::_GetInt2d($extData, 0); // color type
2291
						$xclrValue = substr($extData, 4, 4); // color value (value based on color type)
2292
2293
						if ($xclfType == 2) {
2294
							$rgb = sprintf('%02X%02X%02X', ord($xclrValue{0}), ord($xclrValue{1}), ord($xclrValue{2}));
2295
2296
							// modify the relevant style property
2297
							if ( isset($this->_mapCellXfIndex[$ixfe]) ) {
2298
								$right = $this->_phpExcel->getCellXfByIndex($this->_mapCellXfIndex[$ixfe])->getBorders()->getRight();
2299
								$right->getColor()->setRGB($rgb);
2300
								unset($right->colorIndex); // normal color index does not apply, discard
2301
							}
2302
						}
2303
						break;
2304
2305
					case 11:		// border color diagonal
2306
						$xclfType  = self::_GetInt2d($extData, 0); // color type
@@ 2305-2319 (lines=15) @@
2302
						}
2303
						break;
2304
2305
					case 11:		// border color diagonal
2306
						$xclfType  = self::_GetInt2d($extData, 0); // color type
2307
						$xclrValue = substr($extData, 4, 4); // color value (value based on color type)
2308
2309
						if ($xclfType == 2) {
2310
							$rgb = sprintf('%02X%02X%02X', ord($xclrValue{0}), ord($xclrValue{1}), ord($xclrValue{2}));
2311
2312
							// modify the relevant style property
2313
							if ( isset($this->_mapCellXfIndex[$ixfe]) ) {
2314
								$diagonal = $this->_phpExcel->getCellXfByIndex($this->_mapCellXfIndex[$ixfe])->getBorders()->getDiagonal();
2315
								$diagonal->getColor()->setRGB($rgb);
2316
								unset($diagonal->colorIndex); // normal color index does not apply, discard
2317
							}
2318
						}
2319
						break;
2320
2321
					case 13:	// font color
2322
						$xclfType  = self::_GetInt2d($extData, 0); // color type
@@ 2321-2335 (lines=15) @@
2318
						}
2319
						break;
2320
2321
					case 13:	// font color
2322
						$xclfType  = self::_GetInt2d($extData, 0); // color type
2323
						$xclrValue = substr($extData, 4, 4); // color value (value based on color type)
2324
2325
						if ($xclfType == 2) {
2326
							$rgb = sprintf('%02X%02X%02X', ord($xclrValue{0}), ord($xclrValue{1}), ord($xclrValue{2}));
2327
2328
							// modify the relevant style property
2329
							if ( isset($this->_mapCellXfIndex[$ixfe]) ) {
2330
								$font = $this->_phpExcel->getCellXfByIndex($this->_mapCellXfIndex[$ixfe])->getFont();
2331
								$font->getColor()->setRGB($rgb);
2332
								unset($font->colorIndex); // normal color index does not apply, discard
2333
							}
2334
						}
2335
						break;
2336
				}
2337
2338
				$offset += $cb;