View GitHub Repository PhpSpreadsheet

Schedule Inspection
Subscribe

Code Duplication    Length = 5-5 lines in 2 locations

src/PhpSpreadsheet/Calculation.php 2 locations

@@ 3486-3490 (lines=5) @@
3483 
                                $oRow[] = $oCR[1];
3484 
                            }
3485 
                            $cellRef = Cell::stringFromColumnIndex(min($oCol)) . min($oRow) . ':' . Cell::stringFromColumnIndex(max($oCol)) . max($oRow);
3486 
                            if ($pCellParent !== null) {
3487 
                                $cellValue = $this->extractCellRange($cellRef, $this->spreadsheet->getSheetByName($sheet1), false);
3488 
                            } else {
3489 
                                return $this->raiseFormulaError('Unable to access Cell Reference');
3490 
                            }
3491 
                            $stack->push('Cell Reference', $cellValue, $cellRef);
3492 
                        } else {
3493 
                            $stack->push('Error', Calculation\Functions::REF(), null);
@@ 3600-3604 (lines=5) @@
3597 
                            }
3598 
                            $matches[2] = trim($matches[2], "\"'");
3599 
                            $this->_debugLog->writeDebugLog('Evaluating Cell Range ', $cellRef, ' in worksheet ', $matches[2]);
3600 
                            if ($pCellParent !== null) {
3601 
                                $cellValue = $this->extractCellRange($cellRef, $this->spreadsheet->getSheetByName($matches[2]), false);
3602 
                            } else {
3603 
                                return $this->raiseFormulaError('Unable to access Cell Reference');
3604 
                            }
3605 
                            $this->_debugLog->writeDebugLog('Evaluation Result for cells ', $cellRef, ' in worksheet ', $matches[2], ' is ', $this->showTypeDetails($cellValue));
3606 
                        } else {
3607 
                            $this->_debugLog->writeDebugLog('Evaluating Cell Range ', $cellRef, ' in current worksheet');