View GitHub Repository PhpSpreadsheet

Schedule Inspection
Subscribe

Code Duplication    Length = 7-7 lines in 2 locations

src/PhpSpreadsheet/Calculation/LookupRef.php 2 locations

@@ 330-336 (lines=7) @@
327 
                return Functions::REF();
328 
            }
329 

                                

                                                            

                                    330
                                    
                                    
            if (strpos($cellAddress, '!') !== false) {

                                

                                                            

                                    331
                                    
                                    
                list($sheetName, $cellAddress) = explode('!', $cellAddress);

                                

                                                            

                                    332
                                    
                                    
                $sheetName = trim($sheetName, "'");

                                

                                                            

                                    333
                                    
                                    
                $pSheet = $pCell->getWorksheet()->getParent()->getSheetByName($sheetName);

                                

                                                            

                                    334
                                    
                                    
            } else {

                                

                                                            

                                    335
                                    
                                    
                $pSheet = $pCell->getWorksheet();

                                

                                                            

                                    336
                                    
                                    
            }

                                

                                                            

                                    337
                                    
                                    

                                

                                                            

                                    338
                                    
                                    
            return Calculation::getInstance()->extractNamedRange($cellAddress, $pSheet, false);

                                

                                                            

                                    339
                                    
                                    
        }

                                

                                                                                

                                
                                
                                    @@ 341-347 (lines=7) @@
                                
                            


                                                            

                                    338
                                    
                                    
            return Calculation::getInstance()->extractNamedRange($cellAddress, $pSheet, false);

                                

                                                            

                                    339
                                    
                                    
        }

                                

                                                            

                                    340
                                    
                                    

                                

                                                            

                                    341
                                    
                                    
        if (strpos($cellAddress, '!') !== false) {

                                

                                                            

                                    342
                                    
                                    
            list($sheetName, $cellAddress) = explode('!', $cellAddress);

                                

                                                            

                                    343
                                    
                                    
            $sheetName = trim($sheetName, "'");

                                

                                                            

                                    344
                                    
                                    
            $pSheet = $pCell->getWorksheet()->getParent()->getSheetByName($sheetName);

                                

                                                            

                                    345
                                    
                                    
        } else {

                                

                                                            

                                    346
                                    
                                    
            $pSheet = $pCell->getWorksheet();

                                

                                                            

                                    347
                                    
                                    
        }

                                

                                                            

                                    348
                                    
                                    

                                

                                                            

                                    349
                                    
                                    
        return Calculation::getInstance()->extractCellRange($cellAddress, $pSheet, false);

                                

                                                            

                                    350
                                    
                                    
    }