View GitHub Repository PhpSpreadsheet

Schedule Inspection
Subscribe

Code Duplication    Length = 5-5 lines in 4 locations

src/PhpSpreadsheet/Calculation.php 4 locations

@@ 4092-4096 (lines=5) @@
4089 
            if (!isset($aReferences[1])) {
4090 
                //    Single cell in range
4091 
                sscanf($aReferences[0], '%[A-Z]%d', $currentCol, $currentRow);
4092 
                if ($pSheet->cellExists($aReferences[0])) {
4093 
                    $returnValue[$currentRow][$currentCol] = $pSheet->getCell($aReferences[0])->getCalculatedValue($resetLog);
4094 
                } else {
4095 
                    $returnValue[$currentRow][$currentCol] = null;
4096 
                }
4097 
            } else {
4098 
                // Extract cell data for all cells in the range
4099 
                foreach ($aReferences as $reference) {
@@ 4102-4106 (lines=5) @@
4099 
                foreach ($aReferences as $reference) {
4100 
                    // Extract range
4101 
                    sscanf($reference, '%[A-Z]%d', $currentCol, $currentRow);
4102 
                    if ($pSheet->cellExists($reference)) {
4103 
                        $returnValue[$currentRow][$currentCol] = $pSheet->getCell($reference)->getCalculatedValue($resetLog);
4104 
                    } else {
4105 
                        $returnValue[$currentRow][$currentCol] = null;
4106 
                    }
4107 
                }
4108 
            }
4109 
        }
@@ 4158-4162 (lines=5) @@
4155 
            if (!isset($aReferences[1])) {
4156 
                //    Single cell (or single column or row) in range
4157 
                list($currentCol, $currentRow) = Cell::coordinateFromString($aReferences[0]);
4158 
                if ($pSheet->cellExists($aReferences[0])) {
4159 
                    $returnValue[$currentRow][$currentCol] = $pSheet->getCell($aReferences[0])->getCalculatedValue($resetLog);
4160 
                } else {
4161 
                    $returnValue[$currentRow][$currentCol] = null;
4162 
                }
4163 
            } else {
4164 
                // Extract cell data for all cells in the range
4165 
                foreach ($aReferences as $reference) {
@@ 4168-4172 (lines=5) @@
4165 
                foreach ($aReferences as $reference) {
4166 
                    // Extract range
4167 
                    list($currentCol, $currentRow) = Cell::coordinateFromString($reference);
4168 
                    if ($pSheet->cellExists($reference)) {
4169 
                        $returnValue[$currentRow][$currentCol] = $pSheet->getCell($reference)->getCalculatedValue($resetLog);
4170 
                    } else {
4171 
                        $returnValue[$currentRow][$currentCol] = null;
4172 
                    }
4173 
                }
4174 
            }
4175 
        }