Code Duplication    Length = 16-16 lines in 2 locations

src/PhpSpreadsheet/Reader/Excel5.php 2 locations

@@ 6727-6742 (lines=16) @@
6724
                break;
6725
            case 0x3A:    //    3d reference to cell
6726
            case 0x5A:
6727
            case 0x7A:
6728
                $name = 'tRef3d';
6729
                $size = 7;
6730
6731
                try {
6732
                    // offset: 1; size: 2; index to REF entry
6733
                    $sheetRange = $this->readSheetRangeByRefIndex(self::getInt2d($formulaData, 1));
6734
                    // offset: 3; size: 4; cell address
6735
                    $cellAddress = $this->readBIFF8CellAddress(substr($formulaData, 3, 4));
6736
6737
                    $data = "$sheetRange!$cellAddress";
6738
                } catch (\PhpSpreadsheet\Exception $e) {
6739
                    // deleted sheet reference
6740
                    $data = '#REF!';
6741
                }
6742
                break;
6743
            case 0x3B:    //    3d reference to cell range
6744
            case 0x5B:
6745
            case 0x7B:
@@ 6745-6760 (lines=16) @@
6742
                break;
6743
            case 0x3B:    //    3d reference to cell range
6744
            case 0x5B:
6745
            case 0x7B:
6746
                $name = 'tArea3d';
6747
                $size = 11;
6748
6749
                try {
6750
                    // offset: 1; size: 2; index to REF entry
6751
                    $sheetRange = $this->readSheetRangeByRefIndex(self::getInt2d($formulaData, 1));
6752
                    // offset: 3; size: 8; cell address
6753
                    $cellRangeAddress = $this->readBIFF8CellRangeAddress(substr($formulaData, 3, 8));
6754
6755
                    $data = "$sheetRange!$cellRangeAddress";
6756
                } catch (\PhpSpreadsheet\Exception $e) {
6757
                    // deleted sheet reference
6758
                    $data = '#REF!';
6759
                }
6760
                break;
6761
            // Unknown cases    // don't know how to deal with
6762
            default:
6763
                throw new Exception('Unrecognized token ' . sprintf('%02X', $id) . ' in formula');