Code Duplication    Length = 16-16 lines in 2 locations

src/PhpSpreadsheet/Reader/Xls.php 2 locations

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