Code Duplication    Length = 16-16 lines in 2 locations

src/PhpSpreadsheet/Reader/Xls.php 2 locations

@@ 6604-6619 (lines=16) @@
6601
                break;
6602
            case 0x3A:    //    3d reference to cell
6603
            case 0x5A:
6604
            case 0x7A:
6605
                $name = 'tRef3d';
6606
                $size = 7;
6607
6608
                try {
6609
                    // offset: 1; size: 2; index to REF entry
6610
                    $sheetRange = $this->readSheetRangeByRefIndex(self::getInt2d($formulaData, 1));
6611
                    // offset: 3; size: 4; cell address
6612
                    $cellAddress = $this->readBIFF8CellAddress(substr($formulaData, 3, 4));
6613
6614
                    $data = "$sheetRange!$cellAddress";
6615
                } catch (\PhpOffice\PhpSpreadsheet\Exception $e) {
6616
                    // deleted sheet reference
6617
                    $data = '#REF!';
6618
                }
6619
                break;
6620
            case 0x3B:    //    3d reference to cell range
6621
            case 0x5B:
6622
            case 0x7B:
@@ 6622-6637 (lines=16) @@
6619
                break;
6620
            case 0x3B:    //    3d reference to cell range
6621
            case 0x5B:
6622
            case 0x7B:
6623
                $name = 'tArea3d';
6624
                $size = 11;
6625
6626
                try {
6627
                    // offset: 1; size: 2; index to REF entry
6628
                    $sheetRange = $this->readSheetRangeByRefIndex(self::getInt2d($formulaData, 1));
6629
                    // offset: 3; size: 8; cell address
6630
                    $cellRangeAddress = $this->readBIFF8CellRangeAddress(substr($formulaData, 3, 8));
6631
6632
                    $data = "$sheetRange!$cellRangeAddress";
6633
                } catch (\PhpOffice\PhpSpreadsheet\Exception $e) {
6634
                    // deleted sheet reference
6635
                    $data = '#REF!';
6636
                }
6637
                break;
6638
            // Unknown cases    // don't know how to deal with
6639
            default:
6640
                throw new Exception('Unrecognized token ' . sprintf('%02X', $id) . ' in formula');