Code Duplication    Length = 9-9 lines in 2 locations

src/PhpSpreadsheet/Calculation/Calculation.php 2 locations

@@ 3472-3480 (lines=9) @@
3469
                            $sheet2 = $sheet1;
3470
                        }
3471
                        if ($sheet1 == $sheet2) {
3472
                            if ($operand1Data['reference'] === null) {
3473
                                if ((trim($operand1Data['value']) != '') && (is_numeric($operand1Data['value']))) {
3474
                                    $operand1Data['reference'] = $pCell->getColumn() . $operand1Data['value'];
3475
                                } elseif (trim($operand1Data['reference']) == '') {
3476
                                    $operand1Data['reference'] = $pCell->getCoordinate();
3477
                                } else {
3478
                                    $operand1Data['reference'] = $operand1Data['value'] . $pCell->getRow();
3479
                                }
3480
                            }
3481
                            if ($operand2Data['reference'] === null) {
3482
                                if ((trim($operand2Data['value']) != '') && (is_numeric($operand2Data['value']))) {
3483
                                    $operand2Data['reference'] = $pCell->getColumn() . $operand2Data['value'];
@@ 3481-3489 (lines=9) @@
3478
                                    $operand1Data['reference'] = $operand1Data['value'] . $pCell->getRow();
3479
                                }
3480
                            }
3481
                            if ($operand2Data['reference'] === null) {
3482
                                if ((trim($operand2Data['value']) != '') && (is_numeric($operand2Data['value']))) {
3483
                                    $operand2Data['reference'] = $pCell->getColumn() . $operand2Data['value'];
3484
                                } elseif (trim($operand2Data['reference']) == '') {
3485
                                    $operand2Data['reference'] = $pCell->getCoordinate();
3486
                                } else {
3487
                                    $operand2Data['reference'] = $operand2Data['value'] . $pCell->getRow();
3488
                                }
3489
                            }
3490
3491
                            $oData = array_merge(explode(':', $operand1Data['reference']), explode(':', $operand2Data['reference']));
3492
                            $oCol = $oRow = [];