PHPOffice /
PhpSpreadsheet
| @@ 3215-3387 (lines=173) @@ | ||
| 3212 | // Not used (3) |
|
| 3213 | $dataBlockFont .= pack('vC', 0x0000, 0x00); |
|
| 3214 | // Font color index |
|
| 3215 | switch ($conditional->getStyle()->getFont()->getColor()->getRGB()) { |
|
| 3216 | case '000000': |
|
| 3217 | $colorIdx = 0x08; |
|
| 3218 | break; |
|
| 3219 | case 'FFFFFF': |
|
| 3220 | $colorIdx = 0x09; |
|
| 3221 | break; |
|
| 3222 | case 'FF0000': |
|
| 3223 | $colorIdx = 0x0A; |
|
| 3224 | break; |
|
| 3225 | case '00FF00': |
|
| 3226 | $colorIdx = 0x0B; |
|
| 3227 | break; |
|
| 3228 | case '0000FF': |
|
| 3229 | $colorIdx = 0x0C; |
|
| 3230 | break; |
|
| 3231 | case 'FFFF00': |
|
| 3232 | $colorIdx = 0x0D; |
|
| 3233 | break; |
|
| 3234 | case 'FF00FF': |
|
| 3235 | $colorIdx = 0x0E; |
|
| 3236 | break; |
|
| 3237 | case '00FFFF': |
|
| 3238 | $colorIdx = 0x0F; |
|
| 3239 | break; |
|
| 3240 | case '800000': |
|
| 3241 | $colorIdx = 0x10; |
|
| 3242 | break; |
|
| 3243 | case '008000': |
|
| 3244 | $colorIdx = 0x11; |
|
| 3245 | break; |
|
| 3246 | case '000080': |
|
| 3247 | $colorIdx = 0x12; |
|
| 3248 | break; |
|
| 3249 | case '808000': |
|
| 3250 | $colorIdx = 0x13; |
|
| 3251 | break; |
|
| 3252 | case '800080': |
|
| 3253 | $colorIdx = 0x14; |
|
| 3254 | break; |
|
| 3255 | case '008080': |
|
| 3256 | $colorIdx = 0x15; |
|
| 3257 | break; |
|
| 3258 | case 'C0C0C0': |
|
| 3259 | $colorIdx = 0x16; |
|
| 3260 | break; |
|
| 3261 | case '808080': |
|
| 3262 | $colorIdx = 0x17; |
|
| 3263 | break; |
|
| 3264 | case '9999FF': |
|
| 3265 | $colorIdx = 0x18; |
|
| 3266 | break; |
|
| 3267 | case '993366': |
|
| 3268 | $colorIdx = 0x19; |
|
| 3269 | break; |
|
| 3270 | case 'FFFFCC': |
|
| 3271 | $colorIdx = 0x1A; |
|
| 3272 | break; |
|
| 3273 | case 'CCFFFF': |
|
| 3274 | $colorIdx = 0x1B; |
|
| 3275 | break; |
|
| 3276 | case '660066': |
|
| 3277 | $colorIdx = 0x1C; |
|
| 3278 | break; |
|
| 3279 | case 'FF8080': |
|
| 3280 | $colorIdx = 0x1D; |
|
| 3281 | break; |
|
| 3282 | case '0066CC': |
|
| 3283 | $colorIdx = 0x1E; |
|
| 3284 | break; |
|
| 3285 | case 'CCCCFF': |
|
| 3286 | $colorIdx = 0x1F; |
|
| 3287 | break; |
|
| 3288 | case '000080': |
|
| 3289 | $colorIdx = 0x20; |
|
| 3290 | break; |
|
| 3291 | case 'FF00FF': |
|
| 3292 | $colorIdx = 0x21; |
|
| 3293 | break; |
|
| 3294 | case 'FFFF00': |
|
| 3295 | $colorIdx = 0x22; |
|
| 3296 | break; |
|
| 3297 | case '00FFFF': |
|
| 3298 | $colorIdx = 0x23; |
|
| 3299 | break; |
|
| 3300 | case '800080': |
|
| 3301 | $colorIdx = 0x24; |
|
| 3302 | break; |
|
| 3303 | case '800000': |
|
| 3304 | $colorIdx = 0x25; |
|
| 3305 | break; |
|
| 3306 | case '008080': |
|
| 3307 | $colorIdx = 0x26; |
|
| 3308 | break; |
|
| 3309 | case '0000FF': |
|
| 3310 | $colorIdx = 0x27; |
|
| 3311 | break; |
|
| 3312 | case '00CCFF': |
|
| 3313 | $colorIdx = 0x28; |
|
| 3314 | break; |
|
| 3315 | case 'CCFFFF': |
|
| 3316 | $colorIdx = 0x29; |
|
| 3317 | break; |
|
| 3318 | case 'CCFFCC': |
|
| 3319 | $colorIdx = 0x2A; |
|
| 3320 | break; |
|
| 3321 | case 'FFFF99': |
|
| 3322 | $colorIdx = 0x2B; |
|
| 3323 | break; |
|
| 3324 | case '99CCFF': |
|
| 3325 | $colorIdx = 0x2C; |
|
| 3326 | break; |
|
| 3327 | case 'FF99CC': |
|
| 3328 | $colorIdx = 0x2D; |
|
| 3329 | break; |
|
| 3330 | case 'CC99FF': |
|
| 3331 | $colorIdx = 0x2E; |
|
| 3332 | break; |
|
| 3333 | case 'FFCC99': |
|
| 3334 | $colorIdx = 0x2F; |
|
| 3335 | break; |
|
| 3336 | case '3366FF': |
|
| 3337 | $colorIdx = 0x30; |
|
| 3338 | break; |
|
| 3339 | case '33CCCC': |
|
| 3340 | $colorIdx = 0x31; |
|
| 3341 | break; |
|
| 3342 | case '99CC00': |
|
| 3343 | $colorIdx = 0x32; |
|
| 3344 | break; |
|
| 3345 | case 'FFCC00': |
|
| 3346 | $colorIdx = 0x33; |
|
| 3347 | break; |
|
| 3348 | case 'FF9900': |
|
| 3349 | $colorIdx = 0x34; |
|
| 3350 | break; |
|
| 3351 | case 'FF6600': |
|
| 3352 | $colorIdx = 0x35; |
|
| 3353 | break; |
|
| 3354 | case '666699': |
|
| 3355 | $colorIdx = 0x36; |
|
| 3356 | break; |
|
| 3357 | case '969696': |
|
| 3358 | $colorIdx = 0x37; |
|
| 3359 | break; |
|
| 3360 | case '003366': |
|
| 3361 | $colorIdx = 0x38; |
|
| 3362 | break; |
|
| 3363 | case '339966': |
|
| 3364 | $colorIdx = 0x39; |
|
| 3365 | break; |
|
| 3366 | case '003300': |
|
| 3367 | $colorIdx = 0x3A; |
|
| 3368 | break; |
|
| 3369 | case '333300': |
|
| 3370 | $colorIdx = 0x3B; |
|
| 3371 | break; |
|
| 3372 | case '993300': |
|
| 3373 | $colorIdx = 0x3C; |
|
| 3374 | break; |
|
| 3375 | case '993366': |
|
| 3376 | $colorIdx = 0x3D; |
|
| 3377 | break; |
|
| 3378 | case '333399': |
|
| 3379 | $colorIdx = 0x3E; |
|
| 3380 | break; |
|
| 3381 | case '333333': |
|
| 3382 | $colorIdx = 0x3F; |
|
| 3383 | break; |
|
| 3384 | default: |
|
| 3385 | $colorIdx = 0x00; |
|
| 3386 | break; |
|
| 3387 | } |
|
| 3388 | $dataBlockFont .= pack('V', $colorIdx); |
|
| 3389 | // Not used (4) |
|
| 3390 | $dataBlockFont .= pack('V', 0x00000000); |
|
| @@ 3778-3950 (lines=173) @@ | ||
| 3775 | break; |
|
| 3776 | } |
|
| 3777 | // Color |
|
| 3778 | switch ($conditional->getStyle()->getFill()->getStartColor()->getRGB()) { |
|
| 3779 | case '000000': |
|
| 3780 | $colorIdxBg = 0x08; |
|
| 3781 | break; |
|
| 3782 | case 'FFFFFF': |
|
| 3783 | $colorIdxBg = 0x09; |
|
| 3784 | break; |
|
| 3785 | case 'FF0000': |
|
| 3786 | $colorIdxBg = 0x0A; |
|
| 3787 | break; |
|
| 3788 | case '00FF00': |
|
| 3789 | $colorIdxBg = 0x0B; |
|
| 3790 | break; |
|
| 3791 | case '0000FF': |
|
| 3792 | $colorIdxBg = 0x0C; |
|
| 3793 | break; |
|
| 3794 | case 'FFFF00': |
|
| 3795 | $colorIdxBg = 0x0D; |
|
| 3796 | break; |
|
| 3797 | case 'FF00FF': |
|
| 3798 | $colorIdxBg = 0x0E; |
|
| 3799 | break; |
|
| 3800 | case '00FFFF': |
|
| 3801 | $colorIdxBg = 0x0F; |
|
| 3802 | break; |
|
| 3803 | case '800000': |
|
| 3804 | $colorIdxBg = 0x10; |
|
| 3805 | break; |
|
| 3806 | case '008000': |
|
| 3807 | $colorIdxBg = 0x11; |
|
| 3808 | break; |
|
| 3809 | case '000080': |
|
| 3810 | $colorIdxBg = 0x12; |
|
| 3811 | break; |
|
| 3812 | case '808000': |
|
| 3813 | $colorIdxBg = 0x13; |
|
| 3814 | break; |
|
| 3815 | case '800080': |
|
| 3816 | $colorIdxBg = 0x14; |
|
| 3817 | break; |
|
| 3818 | case '008080': |
|
| 3819 | $colorIdxBg = 0x15; |
|
| 3820 | break; |
|
| 3821 | case 'C0C0C0': |
|
| 3822 | $colorIdxBg = 0x16; |
|
| 3823 | break; |
|
| 3824 | case '808080': |
|
| 3825 | $colorIdxBg = 0x17; |
|
| 3826 | break; |
|
| 3827 | case '9999FF': |
|
| 3828 | $colorIdxBg = 0x18; |
|
| 3829 | break; |
|
| 3830 | case '993366': |
|
| 3831 | $colorIdxBg = 0x19; |
|
| 3832 | break; |
|
| 3833 | case 'FFFFCC': |
|
| 3834 | $colorIdxBg = 0x1A; |
|
| 3835 | break; |
|
| 3836 | case 'CCFFFF': |
|
| 3837 | $colorIdxBg = 0x1B; |
|
| 3838 | break; |
|
| 3839 | case '660066': |
|
| 3840 | $colorIdxBg = 0x1C; |
|
| 3841 | break; |
|
| 3842 | case 'FF8080': |
|
| 3843 | $colorIdxBg = 0x1D; |
|
| 3844 | break; |
|
| 3845 | case '0066CC': |
|
| 3846 | $colorIdxBg = 0x1E; |
|
| 3847 | break; |
|
| 3848 | case 'CCCCFF': |
|
| 3849 | $colorIdxBg = 0x1F; |
|
| 3850 | break; |
|
| 3851 | case '000080': |
|
| 3852 | $colorIdxBg = 0x20; |
|
| 3853 | break; |
|
| 3854 | case 'FF00FF': |
|
| 3855 | $colorIdxBg = 0x21; |
|
| 3856 | break; |
|
| 3857 | case 'FFFF00': |
|
| 3858 | $colorIdxBg = 0x22; |
|
| 3859 | break; |
|
| 3860 | case '00FFFF': |
|
| 3861 | $colorIdxBg = 0x23; |
|
| 3862 | break; |
|
| 3863 | case '800080': |
|
| 3864 | $colorIdxBg = 0x24; |
|
| 3865 | break; |
|
| 3866 | case '800000': |
|
| 3867 | $colorIdxBg = 0x25; |
|
| 3868 | break; |
|
| 3869 | case '008080': |
|
| 3870 | $colorIdxBg = 0x26; |
|
| 3871 | break; |
|
| 3872 | case '0000FF': |
|
| 3873 | $colorIdxBg = 0x27; |
|
| 3874 | break; |
|
| 3875 | case '00CCFF': |
|
| 3876 | $colorIdxBg = 0x28; |
|
| 3877 | break; |
|
| 3878 | case 'CCFFFF': |
|
| 3879 | $colorIdxBg = 0x29; |
|
| 3880 | break; |
|
| 3881 | case 'CCFFCC': |
|
| 3882 | $colorIdxBg = 0x2A; |
|
| 3883 | break; |
|
| 3884 | case 'FFFF99': |
|
| 3885 | $colorIdxBg = 0x2B; |
|
| 3886 | break; |
|
| 3887 | case '99CCFF': |
|
| 3888 | $colorIdxBg = 0x2C; |
|
| 3889 | break; |
|
| 3890 | case 'FF99CC': |
|
| 3891 | $colorIdxBg = 0x2D; |
|
| 3892 | break; |
|
| 3893 | case 'CC99FF': |
|
| 3894 | $colorIdxBg = 0x2E; |
|
| 3895 | break; |
|
| 3896 | case 'FFCC99': |
|
| 3897 | $colorIdxBg = 0x2F; |
|
| 3898 | break; |
|
| 3899 | case '3366FF': |
|
| 3900 | $colorIdxBg = 0x30; |
|
| 3901 | break; |
|
| 3902 | case '33CCCC': |
|
| 3903 | $colorIdxBg = 0x31; |
|
| 3904 | break; |
|
| 3905 | case '99CC00': |
|
| 3906 | $colorIdxBg = 0x32; |
|
| 3907 | break; |
|
| 3908 | case 'FFCC00': |
|
| 3909 | $colorIdxBg = 0x33; |
|
| 3910 | break; |
|
| 3911 | case 'FF9900': |
|
| 3912 | $colorIdxBg = 0x34; |
|
| 3913 | break; |
|
| 3914 | case 'FF6600': |
|
| 3915 | $colorIdxBg = 0x35; |
|
| 3916 | break; |
|
| 3917 | case '666699': |
|
| 3918 | $colorIdxBg = 0x36; |
|
| 3919 | break; |
|
| 3920 | case '969696': |
|
| 3921 | $colorIdxBg = 0x37; |
|
| 3922 | break; |
|
| 3923 | case '003366': |
|
| 3924 | $colorIdxBg = 0x38; |
|
| 3925 | break; |
|
| 3926 | case '339966': |
|
| 3927 | $colorIdxBg = 0x39; |
|
| 3928 | break; |
|
| 3929 | case '003300': |
|
| 3930 | $colorIdxBg = 0x3A; |
|
| 3931 | break; |
|
| 3932 | case '333300': |
|
| 3933 | $colorIdxBg = 0x3B; |
|
| 3934 | break; |
|
| 3935 | case '993300': |
|
| 3936 | $colorIdxBg = 0x3C; |
|
| 3937 | break; |
|
| 3938 | case '993366': |
|
| 3939 | $colorIdxBg = 0x3D; |
|
| 3940 | break; |
|
| 3941 | case '333399': |
|
| 3942 | $colorIdxBg = 0x3E; |
|
| 3943 | break; |
|
| 3944 | case '333333': |
|
| 3945 | $colorIdxBg = 0x3F; |
|
| 3946 | break; |
|
| 3947 | default: |
|
| 3948 | $colorIdxBg = 0x41; |
|
| 3949 | break; |
|
| 3950 | } |
|
| 3951 | // Fg Color |
|
| 3952 | switch ($conditional->getStyle()->getFill()->getEndColor()->getRGB()) { |
|
| 3953 | case '000000': |
|
| @@ 3952-4124 (lines=173) @@ | ||
| 3949 | break; |
|
| 3950 | } |
|
| 3951 | // Fg Color |
|
| 3952 | switch ($conditional->getStyle()->getFill()->getEndColor()->getRGB()) { |
|
| 3953 | case '000000': |
|
| 3954 | $colorIdxFg = 0x08; |
|
| 3955 | break; |
|
| 3956 | case 'FFFFFF': |
|
| 3957 | $colorIdxFg = 0x09; |
|
| 3958 | break; |
|
| 3959 | case 'FF0000': |
|
| 3960 | $colorIdxFg = 0x0A; |
|
| 3961 | break; |
|
| 3962 | case '00FF00': |
|
| 3963 | $colorIdxFg = 0x0B; |
|
| 3964 | break; |
|
| 3965 | case '0000FF': |
|
| 3966 | $colorIdxFg = 0x0C; |
|
| 3967 | break; |
|
| 3968 | case 'FFFF00': |
|
| 3969 | $colorIdxFg = 0x0D; |
|
| 3970 | break; |
|
| 3971 | case 'FF00FF': |
|
| 3972 | $colorIdxFg = 0x0E; |
|
| 3973 | break; |
|
| 3974 | case '00FFFF': |
|
| 3975 | $colorIdxFg = 0x0F; |
|
| 3976 | break; |
|
| 3977 | case '800000': |
|
| 3978 | $colorIdxFg = 0x10; |
|
| 3979 | break; |
|
| 3980 | case '008000': |
|
| 3981 | $colorIdxFg = 0x11; |
|
| 3982 | break; |
|
| 3983 | case '000080': |
|
| 3984 | $colorIdxFg = 0x12; |
|
| 3985 | break; |
|
| 3986 | case '808000': |
|
| 3987 | $colorIdxFg = 0x13; |
|
| 3988 | break; |
|
| 3989 | case '800080': |
|
| 3990 | $colorIdxFg = 0x14; |
|
| 3991 | break; |
|
| 3992 | case '008080': |
|
| 3993 | $colorIdxFg = 0x15; |
|
| 3994 | break; |
|
| 3995 | case 'C0C0C0': |
|
| 3996 | $colorIdxFg = 0x16; |
|
| 3997 | break; |
|
| 3998 | case '808080': |
|
| 3999 | $colorIdxFg = 0x17; |
|
| 4000 | break; |
|
| 4001 | case '9999FF': |
|
| 4002 | $colorIdxFg = 0x18; |
|
| 4003 | break; |
|
| 4004 | case '993366': |
|
| 4005 | $colorIdxFg = 0x19; |
|
| 4006 | break; |
|
| 4007 | case 'FFFFCC': |
|
| 4008 | $colorIdxFg = 0x1A; |
|
| 4009 | break; |
|
| 4010 | case 'CCFFFF': |
|
| 4011 | $colorIdxFg = 0x1B; |
|
| 4012 | break; |
|
| 4013 | case '660066': |
|
| 4014 | $colorIdxFg = 0x1C; |
|
| 4015 | break; |
|
| 4016 | case 'FF8080': |
|
| 4017 | $colorIdxFg = 0x1D; |
|
| 4018 | break; |
|
| 4019 | case '0066CC': |
|
| 4020 | $colorIdxFg = 0x1E; |
|
| 4021 | break; |
|
| 4022 | case 'CCCCFF': |
|
| 4023 | $colorIdxFg = 0x1F; |
|
| 4024 | break; |
|
| 4025 | case '000080': |
|
| 4026 | $colorIdxFg = 0x20; |
|
| 4027 | break; |
|
| 4028 | case 'FF00FF': |
|
| 4029 | $colorIdxFg = 0x21; |
|
| 4030 | break; |
|
| 4031 | case 'FFFF00': |
|
| 4032 | $colorIdxFg = 0x22; |
|
| 4033 | break; |
|
| 4034 | case '00FFFF': |
|
| 4035 | $colorIdxFg = 0x23; |
|
| 4036 | break; |
|
| 4037 | case '800080': |
|
| 4038 | $colorIdxFg = 0x24; |
|
| 4039 | break; |
|
| 4040 | case '800000': |
|
| 4041 | $colorIdxFg = 0x25; |
|
| 4042 | break; |
|
| 4043 | case '008080': |
|
| 4044 | $colorIdxFg = 0x26; |
|
| 4045 | break; |
|
| 4046 | case '0000FF': |
|
| 4047 | $colorIdxFg = 0x27; |
|
| 4048 | break; |
|
| 4049 | case '00CCFF': |
|
| 4050 | $colorIdxFg = 0x28; |
|
| 4051 | break; |
|
| 4052 | case 'CCFFFF': |
|
| 4053 | $colorIdxFg = 0x29; |
|
| 4054 | break; |
|
| 4055 | case 'CCFFCC': |
|
| 4056 | $colorIdxFg = 0x2A; |
|
| 4057 | break; |
|
| 4058 | case 'FFFF99': |
|
| 4059 | $colorIdxFg = 0x2B; |
|
| 4060 | break; |
|
| 4061 | case '99CCFF': |
|
| 4062 | $colorIdxFg = 0x2C; |
|
| 4063 | break; |
|
| 4064 | case 'FF99CC': |
|
| 4065 | $colorIdxFg = 0x2D; |
|
| 4066 | break; |
|
| 4067 | case 'CC99FF': |
|
| 4068 | $colorIdxFg = 0x2E; |
|
| 4069 | break; |
|
| 4070 | case 'FFCC99': |
|
| 4071 | $colorIdxFg = 0x2F; |
|
| 4072 | break; |
|
| 4073 | case '3366FF': |
|
| 4074 | $colorIdxFg = 0x30; |
|
| 4075 | break; |
|
| 4076 | case '33CCCC': |
|
| 4077 | $colorIdxFg = 0x31; |
|
| 4078 | break; |
|
| 4079 | case '99CC00': |
|
| 4080 | $colorIdxFg = 0x32; |
|
| 4081 | break; |
|
| 4082 | case 'FFCC00': |
|
| 4083 | $colorIdxFg = 0x33; |
|
| 4084 | break; |
|
| 4085 | case 'FF9900': |
|
| 4086 | $colorIdxFg = 0x34; |
|
| 4087 | break; |
|
| 4088 | case 'FF6600': |
|
| 4089 | $colorIdxFg = 0x35; |
|
| 4090 | break; |
|
| 4091 | case '666699': |
|
| 4092 | $colorIdxFg = 0x36; |
|
| 4093 | break; |
|
| 4094 | case '969696': |
|
| 4095 | $colorIdxFg = 0x37; |
|
| 4096 | break; |
|
| 4097 | case '003366': |
|
| 4098 | $colorIdxFg = 0x38; |
|
| 4099 | break; |
|
| 4100 | case '339966': |
|
| 4101 | $colorIdxFg = 0x39; |
|
| 4102 | break; |
|
| 4103 | case '003300': |
|
| 4104 | $colorIdxFg = 0x3A; |
|
| 4105 | break; |
|
| 4106 | case '333300': |
|
| 4107 | $colorIdxFg = 0x3B; |
|
| 4108 | break; |
|
| 4109 | case '993300': |
|
| 4110 | $colorIdxFg = 0x3C; |
|
| 4111 | break; |
|
| 4112 | case '993366': |
|
| 4113 | $colorIdxFg = 0x3D; |
|
| 4114 | break; |
|
| 4115 | case '333399': |
|
| 4116 | $colorIdxFg = 0x3E; |
|
| 4117 | break; |
|
| 4118 | case '333333': |
|
| 4119 | $colorIdxFg = 0x3F; |
|
| 4120 | break; |
|
| 4121 | default: |
|
| 4122 | $colorIdxFg = 0x40; |
|
| 4123 | break; |
|
| 4124 | } |
|
| 4125 | $dataBlockFill = pack('v', $blockFillPatternStyle); |
|
| 4126 | $dataBlockFill .= pack('v', $colorIdxFg | ($colorIdxBg << 7)); |
|
| 4127 | } |
|
