Code Duplication    Length = 44-44 lines in 4 locations

src/PhpSpreadsheet/Writer/Xls/Worksheet.php 4 locations

@@ 3581-3624 (lines=44) @@
3578
                    $blockLineStyle |= 0x0D;
3579
                    break;
3580
            }
3581
            switch ($conditional->getStyle()->getBorders()->getRight()->getBorderStyle()) {
3582
                case Border::BORDER_NONE:
3583
                    $blockLineStyle |= 0x00 << 4;
3584
                    break;
3585
                case Border::BORDER_THIN:
3586
                    $blockLineStyle |= 0x01 << 4;
3587
                    break;
3588
                case Border::BORDER_MEDIUM:
3589
                    $blockLineStyle |= 0x02 << 4;
3590
                    break;
3591
                case Border::BORDER_DASHED:
3592
                    $blockLineStyle |= 0x03 << 4;
3593
                    break;
3594
                case Border::BORDER_DOTTED:
3595
                    $blockLineStyle |= 0x04 << 4;
3596
                    break;
3597
                case Border::BORDER_THICK:
3598
                    $blockLineStyle |= 0x05 << 4;
3599
                    break;
3600
                case Border::BORDER_DOUBLE:
3601
                    $blockLineStyle |= 0x06 << 4;
3602
                    break;
3603
                case Border::BORDER_HAIR:
3604
                    $blockLineStyle |= 0x07 << 4;
3605
                    break;
3606
                case Border::BORDER_MEDIUMDASHED:
3607
                    $blockLineStyle |= 0x08 << 4;
3608
                    break;
3609
                case Border::BORDER_DASHDOT:
3610
                    $blockLineStyle |= 0x09 << 4;
3611
                    break;
3612
                case Border::BORDER_MEDIUMDASHDOT:
3613
                    $blockLineStyle |= 0x0A << 4;
3614
                    break;
3615
                case Border::BORDER_DASHDOTDOT:
3616
                    $blockLineStyle |= 0x0B << 4;
3617
                    break;
3618
                case Border::BORDER_MEDIUMDASHDOTDOT:
3619
                    $blockLineStyle |= 0x0C << 4;
3620
                    break;
3621
                case Border::BORDER_SLANTDASHDOT:
3622
                    $blockLineStyle |= 0x0D << 4;
3623
                    break;
3624
            }
3625
            switch ($conditional->getStyle()->getBorders()->getTop()->getBorderStyle()) {
3626
                case Border::BORDER_NONE:
3627
                    $blockLineStyle |= 0x00 << 8;
@@ 3625-3668 (lines=44) @@
3622
                    $blockLineStyle |= 0x0D << 4;
3623
                    break;
3624
            }
3625
            switch ($conditional->getStyle()->getBorders()->getTop()->getBorderStyle()) {
3626
                case Border::BORDER_NONE:
3627
                    $blockLineStyle |= 0x00 << 8;
3628
                    break;
3629
                case Border::BORDER_THIN:
3630
                    $blockLineStyle |= 0x01 << 8;
3631
                    break;
3632
                case Border::BORDER_MEDIUM:
3633
                    $blockLineStyle |= 0x02 << 8;
3634
                    break;
3635
                case Border::BORDER_DASHED:
3636
                    $blockLineStyle |= 0x03 << 8;
3637
                    break;
3638
                case Border::BORDER_DOTTED:
3639
                    $blockLineStyle |= 0x04 << 8;
3640
                    break;
3641
                case Border::BORDER_THICK:
3642
                    $blockLineStyle |= 0x05 << 8;
3643
                    break;
3644
                case Border::BORDER_DOUBLE:
3645
                    $blockLineStyle |= 0x06 << 8;
3646
                    break;
3647
                case Border::BORDER_HAIR:
3648
                    $blockLineStyle |= 0x07 << 8;
3649
                    break;
3650
                case Border::BORDER_MEDIUMDASHED:
3651
                    $blockLineStyle |= 0x08 << 8;
3652
                    break;
3653
                case Border::BORDER_DASHDOT:
3654
                    $blockLineStyle |= 0x09 << 8;
3655
                    break;
3656
                case Border::BORDER_MEDIUMDASHDOT:
3657
                    $blockLineStyle |= 0x0A << 8;
3658
                    break;
3659
                case Border::BORDER_DASHDOTDOT:
3660
                    $blockLineStyle |= 0x0B << 8;
3661
                    break;
3662
                case Border::BORDER_MEDIUMDASHDOTDOT:
3663
                    $blockLineStyle |= 0x0C << 8;
3664
                    break;
3665
                case Border::BORDER_SLANTDASHDOT:
3666
                    $blockLineStyle |= 0x0D << 8;
3667
                    break;
3668
            }
3669
            switch ($conditional->getStyle()->getBorders()->getBottom()->getBorderStyle()) {
3670
                case Border::BORDER_NONE:
3671
                    $blockLineStyle |= 0x00 << 12;
@@ 3669-3712 (lines=44) @@
3666
                    $blockLineStyle |= 0x0D << 8;
3667
                    break;
3668
            }
3669
            switch ($conditional->getStyle()->getBorders()->getBottom()->getBorderStyle()) {
3670
                case Border::BORDER_NONE:
3671
                    $blockLineStyle |= 0x00 << 12;
3672
                    break;
3673
                case Border::BORDER_THIN:
3674
                    $blockLineStyle |= 0x01 << 12;
3675
                    break;
3676
                case Border::BORDER_MEDIUM:
3677
                    $blockLineStyle |= 0x02 << 12;
3678
                    break;
3679
                case Border::BORDER_DASHED:
3680
                    $blockLineStyle |= 0x03 << 12;
3681
                    break;
3682
                case Border::BORDER_DOTTED:
3683
                    $blockLineStyle |= 0x04 << 12;
3684
                    break;
3685
                case Border::BORDER_THICK:
3686
                    $blockLineStyle |= 0x05 << 12;
3687
                    break;
3688
                case Border::BORDER_DOUBLE:
3689
                    $blockLineStyle |= 0x06 << 12;
3690
                    break;
3691
                case Border::BORDER_HAIR:
3692
                    $blockLineStyle |= 0x07 << 12;
3693
                    break;
3694
                case Border::BORDER_MEDIUMDASHED:
3695
                    $blockLineStyle |= 0x08 << 12;
3696
                    break;
3697
                case Border::BORDER_DASHDOT:
3698
                    $blockLineStyle |= 0x09 << 12;
3699
                    break;
3700
                case Border::BORDER_MEDIUMDASHDOT:
3701
                    $blockLineStyle |= 0x0A << 12;
3702
                    break;
3703
                case Border::BORDER_DASHDOTDOT:
3704
                    $blockLineStyle |= 0x0B << 12;
3705
                    break;
3706
                case Border::BORDER_MEDIUMDASHDOTDOT:
3707
                    $blockLineStyle |= 0x0C << 12;
3708
                    break;
3709
                case Border::BORDER_SLANTDASHDOT:
3710
                    $blockLineStyle |= 0x0D << 12;
3711
                    break;
3712
            }
3713
            //@todo writeCFRule() => $blockLineStyle => Index Color for left line
3714
            //@todo writeCFRule() => $blockLineStyle => Index Color for right line
3715
            //@todo writeCFRule() => $blockLineStyle => Top-left to bottom-right on/off
@@ 3721-3764 (lines=44) @@
3718
            //@todo writeCFRule() => $blockColor => Index Color for top line
3719
            //@todo writeCFRule() => $blockColor => Index Color for bottom line
3720
            //@todo writeCFRule() => $blockColor => Index Color for diagonal line
3721
            switch ($conditional->getStyle()->getBorders()->getDiagonal()->getBorderStyle()) {
3722
                case Border::BORDER_NONE:
3723
                    $blockColor |= 0x00 << 21;
3724
                    break;
3725
                case Border::BORDER_THIN:
3726
                    $blockColor |= 0x01 << 21;
3727
                    break;
3728
                case Border::BORDER_MEDIUM:
3729
                    $blockColor |= 0x02 << 21;
3730
                    break;
3731
                case Border::BORDER_DASHED:
3732
                    $blockColor |= 0x03 << 21;
3733
                    break;
3734
                case Border::BORDER_DOTTED:
3735
                    $blockColor |= 0x04 << 21;
3736
                    break;
3737
                case Border::BORDER_THICK:
3738
                    $blockColor |= 0x05 << 21;
3739
                    break;
3740
                case Border::BORDER_DOUBLE:
3741
                    $blockColor |= 0x06 << 21;
3742
                    break;
3743
                case Border::BORDER_HAIR:
3744
                    $blockColor |= 0x07 << 21;
3745
                    break;
3746
                case Border::BORDER_MEDIUMDASHED:
3747
                    $blockColor |= 0x08 << 21;
3748
                    break;
3749
                case Border::BORDER_DASHDOT:
3750
                    $blockColor |= 0x09 << 21;
3751
                    break;
3752
                case Border::BORDER_MEDIUMDASHDOT:
3753
                    $blockColor |= 0x0A << 21;
3754
                    break;
3755
                case Border::BORDER_DASHDOTDOT:
3756
                    $blockColor |= 0x0B << 21;
3757
                    break;
3758
                case Border::BORDER_MEDIUMDASHDOTDOT:
3759
                    $blockColor |= 0x0C << 21;
3760
                    break;
3761
                case Border::BORDER_SLANTDASHDOT:
3762
                    $blockColor |= 0x0D << 21;
3763
                    break;
3764
            }
3765
            $dataBlockBorder = pack('vv', $blockLineStyle, $blockColor);
3766
        }
3767
        if ($bFormatFill == 1) {