View GitHub Repository PhpSpreadsheet

Schedule Inspection
Subscribe

Code Duplication    Length = 7-7 lines in 2 locations

src/PhpSpreadsheet/Calculation/LookupRef.php 2 locations

@@ 317-323 (lines=7) @@
314 
                return Functions::REF();
315 
            }
316 

                                

                                                            

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

                                

                                                            

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

                                

                                                            

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

                                

                                                            

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

                                

                                                            

                                    321
                                    
                                    
            } else {

                                

                                                            

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

                                

                                                            

                                    323
                                    
                                    
            }

                                

                                                            

                                    324
                                    
                                    

                                

                                                            

                                    325
                                    
                                    
            return \PhpSpreadsheet\Calculation::getInstance()->extractNamedRange($cellAddress, $pSheet, false);

                                

                                                            

                                    326
                                    
                                    
        }

                                

                                                                                

                                
                                
                                    @@ 328-334 (lines=7) @@
                                
                            


                                                            

                                    325
                                    
                                    
            return \PhpSpreadsheet\Calculation::getInstance()->extractNamedRange($cellAddress, $pSheet, false);

                                

                                                            

                                    326
                                    
                                    
        }

                                

                                                            

                                    327
                                    
                                    

                                

                                                            

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

                                

                                                            

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

                                

                                                            

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

                                

                                                            

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

                                

                                                            

                                    332
                                    
                                    
        } else {

                                

                                                            

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

                                

                                                            

                                    334
                                    
                                    
        }

                                

                                                            

                                    335
                                    
                                    

                                

                                                            

                                    336
                                    
                                    
        return \PhpSpreadsheet\Calculation::getInstance()->extractCellRange($cellAddress, $pSheet, false);

                                

                                                            

                                    337
                                    
                                    
    }