Code Duplication    Length = 10-10 lines in 4 locations

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

@@ 4496-4505 (lines=10) @@
4493
4494
		// bit: 0-3; mask: 0x0000000F; type
4495
		$type = (0x0000000F & $options) >> 0;
4496
		switch ($type) {
4497
			case 0x00:	$type = PHPExcel_Cell_DataValidation::TYPE_NONE;		break;
4498
			case 0x01:	$type = PHPExcel_Cell_DataValidation::TYPE_WHOLE;		break;
4499
			case 0x02:	$type = PHPExcel_Cell_DataValidation::TYPE_DECIMAL;		break;
4500
			case 0x03:	$type = PHPExcel_Cell_DataValidation::TYPE_LIST;		break;
4501
			case 0x04:	$type = PHPExcel_Cell_DataValidation::TYPE_DATE;		break;
4502
			case 0x05:	$type = PHPExcel_Cell_DataValidation::TYPE_TIME;		break;
4503
			case 0x06:	$type = PHPExcel_Cell_DataValidation::TYPE_TEXTLENGTH;	break;
4504
			case 0x07:	$type = PHPExcel_Cell_DataValidation::TYPE_CUSTOM;		break;
4505
		}
4506
4507
		// bit: 4-6; mask: 0x00000070; error type
4508
		$errorStyle = (0x00000070 & $options) >> 4;
@@ 4533-4542 (lines=10) @@
4530
4531
		// bit: 20-23; mask: 0x00F00000; condition operator
4532
		$operator = (0x00F00000 & $options) >> 20;
4533
		switch ($operator) {
4534
			case 0x00: $operator = PHPExcel_Cell_DataValidation::OPERATOR_BETWEEN			;	break;
4535
			case 0x01: $operator = PHPExcel_Cell_DataValidation::OPERATOR_NOTBETWEEN		;	break;
4536
			case 0x02: $operator = PHPExcel_Cell_DataValidation::OPERATOR_EQUAL				;	break;
4537
			case 0x03: $operator = PHPExcel_Cell_DataValidation::OPERATOR_NOTEQUAL			;	break;
4538
			case 0x04: $operator = PHPExcel_Cell_DataValidation::OPERATOR_GREATERTHAN		;	break;
4539
			case 0x05: $operator = PHPExcel_Cell_DataValidation::OPERATOR_LESSTHAN			;	break;
4540
			case 0x06: $operator = PHPExcel_Cell_DataValidation::OPERATOR_GREATERTHANOREQUAL;	break;
4541
			case 0x07: $operator = PHPExcel_Cell_DataValidation::OPERATOR_LESSTHANOREQUAL	;	break;
4542
		}
4543
4544
		// offset: 4; size: var; title of the prompt box
4545
		$offset = 4;

app/Vendor/PHPExcel/PHPExcel/Writer/Excel5/Worksheet.php 2 locations

@@ 2770-2779 (lines=10) @@
2767
2768
				// data type
2769
				$type = $dataValidation->getType();
2770
				switch ($type) {
2771
					case PHPExcel_Cell_DataValidation::TYPE_NONE:		$type = 0x00;	break;
2772
					case PHPExcel_Cell_DataValidation::TYPE_WHOLE:		$type = 0x01;	break;
2773
					case PHPExcel_Cell_DataValidation::TYPE_DECIMAL:	$type = 0x02;	break;
2774
					case PHPExcel_Cell_DataValidation::TYPE_LIST:		$type = 0x03;	break;
2775
					case PHPExcel_Cell_DataValidation::TYPE_DATE:		$type = 0x04;	break;
2776
					case PHPExcel_Cell_DataValidation::TYPE_TIME:		$type = 0x05;	break;
2777
					case PHPExcel_Cell_DataValidation::TYPE_TEXTLENGTH:	$type = 0x06;	break;
2778
					case PHPExcel_Cell_DataValidation::TYPE_CUSTOM:		$type = 0x07;	break;
2779
				}
2780
				$options |= $type << 0;
2781
2782
				// error style
@@ 2810-2819 (lines=10) @@
2807
2808
				// condition operator
2809
				$operator = $dataValidation->getOperator();
2810
				switch ($operator) {
2811
					case PHPExcel_Cell_DataValidation::OPERATOR_BETWEEN: $operator = 0x00			;	break;
2812
					case PHPExcel_Cell_DataValidation::OPERATOR_NOTBETWEEN: $operator = 0x01		;	break;
2813
					case PHPExcel_Cell_DataValidation::OPERATOR_EQUAL: $operator = 0x02				;	break;
2814
					case PHPExcel_Cell_DataValidation::OPERATOR_NOTEQUAL: $operator = 0x03			;	break;
2815
					case PHPExcel_Cell_DataValidation::OPERATOR_GREATERTHAN: $operator = 0x04		;	break;
2816
					case PHPExcel_Cell_DataValidation::OPERATOR_LESSTHAN: $operator = 0x05			;	break;
2817
					case PHPExcel_Cell_DataValidation::OPERATOR_GREATERTHANOREQUAL: $operator = 0x06;	break;
2818
					case PHPExcel_Cell_DataValidation::OPERATOR_LESSTHANOREQUAL: $operator = 0x07	;	break;
2819
				}
2820
				$options |= $operator << 20;
2821
2822
				$data		= pack('V', $options);