View GitHub Repository PhpSpreadsheet

Schedule Inspection
Subscribe

Code Duplication    Length = 3-3 lines in 2 locations

src/PhpSpreadsheet/Writer/Excel2007/Worksheet.php 1 location

@@ 761-763 (lines=3) @@
758 
            $range = \PhpOffice\PhpSpreadsheet\Cell::splitRange($autoFilterRange);
759 
            $range = $range[0];
760 
            //    Strip any worksheet ref
761 
            if (strpos($range[0], '!') !== false) {
762 
                list($ws, $range[0]) = explode('!', $range[0]);
763 
            }
764 
            $range = implode(':', $range);
765 

                                

                                                            

                                    766
                                    
                                    
            $objWriter->writeAttribute('ref', str_replace('$', '', $range));

                                

                                                                        

                

                                                            

                    
src/PhpSpreadsheet/Writer/Excel2007/Workbook.php 1 location

                

                

                    

                                                
                                                    

                                
                                
                                    @@ 355-357 (lines=3) @@
                                
                            


                                                            

                                    352
                                    
                                    
            $range = \PhpOffice\PhpSpreadsheet\Cell::splitRange($autoFilterRange);

                                

                                                            

                                    353
                                    
                                    
            $range = $range[0];

                                

                                                            

                                    354
                                    
                                    
            //    Strip any worksheet ref so we can make the cell ref absolute

                                

                                                            

                                    355
                                    
                                    
            if (strpos($range[0], '!') !== false) {

                                

                                                            

                                    356
                                    
                                    
                list($ws, $range[0]) = explode('!', $range[0]);

                                

                                                            

                                    357
                                    
                                    
            }

                                

                                                            

                                    358
                                    
                                    

                                

                                                            

                                    359
                                    
                                    
            $range[0] = \PhpOffice\PhpSpreadsheet\Cell::absoluteCoordinate($range[0]);

                                

                                                            

                                    360
                                    
                                    
            $range[1] = \PhpOffice\PhpSpreadsheet\Cell::absoluteCoordinate($range[1]);