Code Duplication    Length = 58-58 lines in 4 locations

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

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