View GitHub Repository PhpSpreadsheet

Schedule Inspection
Subscribe

Code Duplication    Length = 4-4 lines in 2 locations

docs/Examples/Calculations/DateTime/DATE.php 1 location

@@ 39-42 (lines=4) @@
36 

                                

                                                            

                                    37
                                    
                                    
$worksheet->fromArray($testDates, null, 'A1', true);

                                

                                                            

                                    38
                                    
                                    

                                

                                                            

                                    39
                                    
                                    
for ($row = 1; $row <= $testDateCount; ++$row) {

                                

                                                            

                                    40
                                    
                                    
    $worksheet->setCellValue('D' . $row, '=DATE(A' . $row . ',B' . $row . ',C' . $row . ')');

                                

                                                            

                                    41
                                    
                                    
    $worksheet->setCellValue('E' . $row, '=D' . $row);

                                

                                                            

                                    42
                                    
                                    
}

                                

                                                            

                                    43
                                    
                                    
$worksheet->getStyle('E1:E' . $testDateCount)

                                

                                                            

                                    44
                                    
                                    
          ->getNumberFormat()

                                

                                                            

                                    45
                                    
                                    
          ->setFormatCode('yyyy-mmm-dd');

                                

                                                                        

                

                                                            

                    
docs/Examples/Calculations/DateTime/TIME.php 1 location

                

                

                    

                                                
                                                    

                                
                                
                                    @@ 37-40 (lines=4) @@
                                
                            


                                                            

                                    34
                                    
                                    

                                

                                                            

                                    35
                                    
                                    
$worksheet->fromArray($testDates, null, 'A1', true);

                                

                                                            

                                    36
                                    
                                    

                                

                                                            

                                    37
                                    
                                    
for ($row = 1; $row <= $testDateCount; ++$row) {

                                

                                                            

                                    38
                                    
                                    
    $worksheet->setCellValue('D' . $row, '=TIME(A' . $row . ',B' . $row . ',C' . $row . ')');

                                

                                                            

                                    39
                                    
                                    
    $worksheet->setCellValue('E' . $row, '=D' . $row);

                                

                                                            

                                    40
                                    
                                    
}

                                

                                                            

                                    41
                                    
                                    
$worksheet->getStyle('E1:E' . $testDateCount)

                                

                                                            

                                    42
                                    
                                    
          ->getNumberFormat()

                                

                                                            

                                    43
                                    
                                    
          ->setFormatCode('hh:mm:ss');