PHPOffice /
PhpSpreadsheet
| @@ 3276-3448 (lines=173) @@ | ||
| 3273 | // Not used (3) |
|
| 3274 | $dataBlockFont .= pack('vC', 0x0000, 0x00); |
|
| 3275 | // Font color index |
|
| 3276 | switch ($conditional->getStyle()->getFont()->getColor()->getRGB()) { |
|
| 3277 | case '000000': |
|
| 3278 | $colorIdx = 0x08; |
|
| 3279 | break; |
|
| 3280 | case 'FFFFFF': |
|
| 3281 | $colorIdx = 0x09; |
|
| 3282 | break; |
|
| 3283 | case 'FF0000': |
|
| 3284 | $colorIdx = 0x0A; |
|
| 3285 | break; |
|
| 3286 | case '00FF00': |
|
| 3287 | $colorIdx = 0x0B; |
|
| 3288 | break; |
|
| 3289 | case '0000FF': |
|
| 3290 | $colorIdx = 0x0C; |
|
| 3291 | break; |
|
| 3292 | case 'FFFF00': |
|
| 3293 | $colorIdx = 0x0D; |
|
| 3294 | break; |
|
| 3295 | case 'FF00FF': |
|
| 3296 | $colorIdx = 0x0E; |
|
| 3297 | break; |
|
| 3298 | case '00FFFF': |
|
| 3299 | $colorIdx = 0x0F; |
|
| 3300 | break; |
|
| 3301 | case '800000': |
|
| 3302 | $colorIdx = 0x10; |
|
| 3303 | break; |
|
| 3304 | case '008000': |
|
| 3305 | $colorIdx = 0x11; |
|
| 3306 | break; |
|
| 3307 | case '000080': |
|
| 3308 | $colorIdx = 0x12; |
|
| 3309 | break; |
|
| 3310 | case '808000': |
|
| 3311 | $colorIdx = 0x13; |
|
| 3312 | break; |
|
| 3313 | case '800080': |
|
| 3314 | $colorIdx = 0x14; |
|
| 3315 | break; |
|
| 3316 | case '008080': |
|
| 3317 | $colorIdx = 0x15; |
|
| 3318 | break; |
|
| 3319 | case 'C0C0C0': |
|
| 3320 | $colorIdx = 0x16; |
|
| 3321 | break; |
|
| 3322 | case '808080': |
|
| 3323 | $colorIdx = 0x17; |
|
| 3324 | break; |
|
| 3325 | case '9999FF': |
|
| 3326 | $colorIdx = 0x18; |
|
| 3327 | break; |
|
| 3328 | case '993366': |
|
| 3329 | $colorIdx = 0x19; |
|
| 3330 | break; |
|
| 3331 | case 'FFFFCC': |
|
| 3332 | $colorIdx = 0x1A; |
|
| 3333 | break; |
|
| 3334 | case 'CCFFFF': |
|
| 3335 | $colorIdx = 0x1B; |
|
| 3336 | break; |
|
| 3337 | case '660066': |
|
| 3338 | $colorIdx = 0x1C; |
|
| 3339 | break; |
|
| 3340 | case 'FF8080': |
|
| 3341 | $colorIdx = 0x1D; |
|
| 3342 | break; |
|
| 3343 | case '0066CC': |
|
| 3344 | $colorIdx = 0x1E; |
|
| 3345 | break; |
|
| 3346 | case 'CCCCFF': |
|
| 3347 | $colorIdx = 0x1F; |
|
| 3348 | break; |
|
| 3349 | case '000080': |
|
| 3350 | $colorIdx = 0x20; |
|
| 3351 | break; |
|
| 3352 | case 'FF00FF': |
|
| 3353 | $colorIdx = 0x21; |
|
| 3354 | break; |
|
| 3355 | case 'FFFF00': |
|
| 3356 | $colorIdx = 0x22; |
|
| 3357 | break; |
|
| 3358 | case '00FFFF': |
|
| 3359 | $colorIdx = 0x23; |
|
| 3360 | break; |
|
| 3361 | case '800080': |
|
| 3362 | $colorIdx = 0x24; |
|
| 3363 | break; |
|
| 3364 | case '800000': |
|
| 3365 | $colorIdx = 0x25; |
|
| 3366 | break; |
|
| 3367 | case '008080': |
|
| 3368 | $colorIdx = 0x26; |
|
| 3369 | break; |
|
| 3370 | case '0000FF': |
|
| 3371 | $colorIdx = 0x27; |
|
| 3372 | break; |
|
| 3373 | case '00CCFF': |
|
| 3374 | $colorIdx = 0x28; |
|
| 3375 | break; |
|
| 3376 | case 'CCFFFF': |
|
| 3377 | $colorIdx = 0x29; |
|
| 3378 | break; |
|
| 3379 | case 'CCFFCC': |
|
| 3380 | $colorIdx = 0x2A; |
|
| 3381 | break; |
|
| 3382 | case 'FFFF99': |
|
| 3383 | $colorIdx = 0x2B; |
|
| 3384 | break; |
|
| 3385 | case '99CCFF': |
|
| 3386 | $colorIdx = 0x2C; |
|
| 3387 | break; |
|
| 3388 | case 'FF99CC': |
|
| 3389 | $colorIdx = 0x2D; |
|
| 3390 | break; |
|
| 3391 | case 'CC99FF': |
|
| 3392 | $colorIdx = 0x2E; |
|
| 3393 | break; |
|
| 3394 | case 'FFCC99': |
|
| 3395 | $colorIdx = 0x2F; |
|
| 3396 | break; |
|
| 3397 | case '3366FF': |
|
| 3398 | $colorIdx = 0x30; |
|
| 3399 | break; |
|
| 3400 | case '33CCCC': |
|
| 3401 | $colorIdx = 0x31; |
|
| 3402 | break; |
|
| 3403 | case '99CC00': |
|
| 3404 | $colorIdx = 0x32; |
|
| 3405 | break; |
|
| 3406 | case 'FFCC00': |
|
| 3407 | $colorIdx = 0x33; |
|
| 3408 | break; |
|
| 3409 | case 'FF9900': |
|
| 3410 | $colorIdx = 0x34; |
|
| 3411 | break; |
|
| 3412 | case 'FF6600': |
|
| 3413 | $colorIdx = 0x35; |
|
| 3414 | break; |
|
| 3415 | case '666699': |
|
| 3416 | $colorIdx = 0x36; |
|
| 3417 | break; |
|
| 3418 | case '969696': |
|
| 3419 | $colorIdx = 0x37; |
|
| 3420 | break; |
|
| 3421 | case '003366': |
|
| 3422 | $colorIdx = 0x38; |
|
| 3423 | break; |
|
| 3424 | case '339966': |
|
| 3425 | $colorIdx = 0x39; |
|
| 3426 | break; |
|
| 3427 | case '003300': |
|
| 3428 | $colorIdx = 0x3A; |
|
| 3429 | break; |
|
| 3430 | case '333300': |
|
| 3431 | $colorIdx = 0x3B; |
|
| 3432 | break; |
|
| 3433 | case '993300': |
|
| 3434 | $colorIdx = 0x3C; |
|
| 3435 | break; |
|
| 3436 | case '993366': |
|
| 3437 | $colorIdx = 0x3D; |
|
| 3438 | break; |
|
| 3439 | case '333399': |
|
| 3440 | $colorIdx = 0x3E; |
|
| 3441 | break; |
|
| 3442 | case '333333': |
|
| 3443 | $colorIdx = 0x3F; |
|
| 3444 | break; |
|
| 3445 | default: |
|
| 3446 | $colorIdx = 0x00; |
|
| 3447 | break; |
|
| 3448 | } |
|
| 3449 | $dataBlockFont .= pack('V', $colorIdx); |
|
| 3450 | // Not used (4) |
|
| 3451 | $dataBlockFont .= pack('V', 0x00000000); |
|
| @@ 3839-4011 (lines=173) @@ | ||
| 3836 | break; |
|
| 3837 | } |
|
| 3838 | // Color |
|
| 3839 | switch ($conditional->getStyle()->getFill()->getStartColor()->getRGB()) { |
|
| 3840 | case '000000': |
|
| 3841 | $colorIdxBg = 0x08; |
|
| 3842 | break; |
|
| 3843 | case 'FFFFFF': |
|
| 3844 | $colorIdxBg = 0x09; |
|
| 3845 | break; |
|
| 3846 | case 'FF0000': |
|
| 3847 | $colorIdxBg = 0x0A; |
|
| 3848 | break; |
|
| 3849 | case '00FF00': |
|
| 3850 | $colorIdxBg = 0x0B; |
|
| 3851 | break; |
|
| 3852 | case '0000FF': |
|
| 3853 | $colorIdxBg = 0x0C; |
|
| 3854 | break; |
|
| 3855 | case 'FFFF00': |
|
| 3856 | $colorIdxBg = 0x0D; |
|
| 3857 | break; |
|
| 3858 | case 'FF00FF': |
|
| 3859 | $colorIdxBg = 0x0E; |
|
| 3860 | break; |
|
| 3861 | case '00FFFF': |
|
| 3862 | $colorIdxBg = 0x0F; |
|
| 3863 | break; |
|
| 3864 | case '800000': |
|
| 3865 | $colorIdxBg = 0x10; |
|
| 3866 | break; |
|
| 3867 | case '008000': |
|
| 3868 | $colorIdxBg = 0x11; |
|
| 3869 | break; |
|
| 3870 | case '000080': |
|
| 3871 | $colorIdxBg = 0x12; |
|
| 3872 | break; |
|
| 3873 | case '808000': |
|
| 3874 | $colorIdxBg = 0x13; |
|
| 3875 | break; |
|
| 3876 | case '800080': |
|
| 3877 | $colorIdxBg = 0x14; |
|
| 3878 | break; |
|
| 3879 | case '008080': |
|
| 3880 | $colorIdxBg = 0x15; |
|
| 3881 | break; |
|
| 3882 | case 'C0C0C0': |
|
| 3883 | $colorIdxBg = 0x16; |
|
| 3884 | break; |
|
| 3885 | case '808080': |
|
| 3886 | $colorIdxBg = 0x17; |
|
| 3887 | break; |
|
| 3888 | case '9999FF': |
|
| 3889 | $colorIdxBg = 0x18; |
|
| 3890 | break; |
|
| 3891 | case '993366': |
|
| 3892 | $colorIdxBg = 0x19; |
|
| 3893 | break; |
|
| 3894 | case 'FFFFCC': |
|
| 3895 | $colorIdxBg = 0x1A; |
|
| 3896 | break; |
|
| 3897 | case 'CCFFFF': |
|
| 3898 | $colorIdxBg = 0x1B; |
|
| 3899 | break; |
|
| 3900 | case '660066': |
|
| 3901 | $colorIdxBg = 0x1C; |
|
| 3902 | break; |
|
| 3903 | case 'FF8080': |
|
| 3904 | $colorIdxBg = 0x1D; |
|
| 3905 | break; |
|
| 3906 | case '0066CC': |
|
| 3907 | $colorIdxBg = 0x1E; |
|
| 3908 | break; |
|
| 3909 | case 'CCCCFF': |
|
| 3910 | $colorIdxBg = 0x1F; |
|
| 3911 | break; |
|
| 3912 | case '000080': |
|
| 3913 | $colorIdxBg = 0x20; |
|
| 3914 | break; |
|
| 3915 | case 'FF00FF': |
|
| 3916 | $colorIdxBg = 0x21; |
|
| 3917 | break; |
|
| 3918 | case 'FFFF00': |
|
| 3919 | $colorIdxBg = 0x22; |
|
| 3920 | break; |
|
| 3921 | case '00FFFF': |
|
| 3922 | $colorIdxBg = 0x23; |
|
| 3923 | break; |
|
| 3924 | case '800080': |
|
| 3925 | $colorIdxBg = 0x24; |
|
| 3926 | break; |
|
| 3927 | case '800000': |
|
| 3928 | $colorIdxBg = 0x25; |
|
| 3929 | break; |
|
| 3930 | case '008080': |
|
| 3931 | $colorIdxBg = 0x26; |
|
| 3932 | break; |
|
| 3933 | case '0000FF': |
|
| 3934 | $colorIdxBg = 0x27; |
|
| 3935 | break; |
|
| 3936 | case '00CCFF': |
|
| 3937 | $colorIdxBg = 0x28; |
|
| 3938 | break; |
|
| 3939 | case 'CCFFFF': |
|
| 3940 | $colorIdxBg = 0x29; |
|
| 3941 | break; |
|
| 3942 | case 'CCFFCC': |
|
| 3943 | $colorIdxBg = 0x2A; |
|
| 3944 | break; |
|
| 3945 | case 'FFFF99': |
|
| 3946 | $colorIdxBg = 0x2B; |
|
| 3947 | break; |
|
| 3948 | case '99CCFF': |
|
| 3949 | $colorIdxBg = 0x2C; |
|
| 3950 | break; |
|
| 3951 | case 'FF99CC': |
|
| 3952 | $colorIdxBg = 0x2D; |
|
| 3953 | break; |
|
| 3954 | case 'CC99FF': |
|
| 3955 | $colorIdxBg = 0x2E; |
|
| 3956 | break; |
|
| 3957 | case 'FFCC99': |
|
| 3958 | $colorIdxBg = 0x2F; |
|
| 3959 | break; |
|
| 3960 | case '3366FF': |
|
| 3961 | $colorIdxBg = 0x30; |
|
| 3962 | break; |
|
| 3963 | case '33CCCC': |
|
| 3964 | $colorIdxBg = 0x31; |
|
| 3965 | break; |
|
| 3966 | case '99CC00': |
|
| 3967 | $colorIdxBg = 0x32; |
|
| 3968 | break; |
|
| 3969 | case 'FFCC00': |
|
| 3970 | $colorIdxBg = 0x33; |
|
| 3971 | break; |
|
| 3972 | case 'FF9900': |
|
| 3973 | $colorIdxBg = 0x34; |
|
| 3974 | break; |
|
| 3975 | case 'FF6600': |
|
| 3976 | $colorIdxBg = 0x35; |
|
| 3977 | break; |
|
| 3978 | case '666699': |
|
| 3979 | $colorIdxBg = 0x36; |
|
| 3980 | break; |
|
| 3981 | case '969696': |
|
| 3982 | $colorIdxBg = 0x37; |
|
| 3983 | break; |
|
| 3984 | case '003366': |
|
| 3985 | $colorIdxBg = 0x38; |
|
| 3986 | break; |
|
| 3987 | case '339966': |
|
| 3988 | $colorIdxBg = 0x39; |
|
| 3989 | break; |
|
| 3990 | case '003300': |
|
| 3991 | $colorIdxBg = 0x3A; |
|
| 3992 | break; |
|
| 3993 | case '333300': |
|
| 3994 | $colorIdxBg = 0x3B; |
|
| 3995 | break; |
|
| 3996 | case '993300': |
|
| 3997 | $colorIdxBg = 0x3C; |
|
| 3998 | break; |
|
| 3999 | case '993366': |
|
| 4000 | $colorIdxBg = 0x3D; |
|
| 4001 | break; |
|
| 4002 | case '333399': |
|
| 4003 | $colorIdxBg = 0x3E; |
|
| 4004 | break; |
|
| 4005 | case '333333': |
|
| 4006 | $colorIdxBg = 0x3F; |
|
| 4007 | break; |
|
| 4008 | default: |
|
| 4009 | $colorIdxBg = 0x41; |
|
| 4010 | break; |
|
| 4011 | } |
|
| 4012 | // Fg Color |
|
| 4013 | switch ($conditional->getStyle()->getFill()->getEndColor()->getRGB()) { |
|
| 4014 | case '000000': |
|
| @@ 4013-4185 (lines=173) @@ | ||
| 4010 | break; |
|
| 4011 | } |
|
| 4012 | // Fg Color |
|
| 4013 | switch ($conditional->getStyle()->getFill()->getEndColor()->getRGB()) { |
|
| 4014 | case '000000': |
|
| 4015 | $colorIdxFg = 0x08; |
|
| 4016 | break; |
|
| 4017 | case 'FFFFFF': |
|
| 4018 | $colorIdxFg = 0x09; |
|
| 4019 | break; |
|
| 4020 | case 'FF0000': |
|
| 4021 | $colorIdxFg = 0x0A; |
|
| 4022 | break; |
|
| 4023 | case '00FF00': |
|
| 4024 | $colorIdxFg = 0x0B; |
|
| 4025 | break; |
|
| 4026 | case '0000FF': |
|
| 4027 | $colorIdxFg = 0x0C; |
|
| 4028 | break; |
|
| 4029 | case 'FFFF00': |
|
| 4030 | $colorIdxFg = 0x0D; |
|
| 4031 | break; |
|
| 4032 | case 'FF00FF': |
|
| 4033 | $colorIdxFg = 0x0E; |
|
| 4034 | break; |
|
| 4035 | case '00FFFF': |
|
| 4036 | $colorIdxFg = 0x0F; |
|
| 4037 | break; |
|
| 4038 | case '800000': |
|
| 4039 | $colorIdxFg = 0x10; |
|
| 4040 | break; |
|
| 4041 | case '008000': |
|
| 4042 | $colorIdxFg = 0x11; |
|
| 4043 | break; |
|
| 4044 | case '000080': |
|
| 4045 | $colorIdxFg = 0x12; |
|
| 4046 | break; |
|
| 4047 | case '808000': |
|
| 4048 | $colorIdxFg = 0x13; |
|
| 4049 | break; |
|
| 4050 | case '800080': |
|
| 4051 | $colorIdxFg = 0x14; |
|
| 4052 | break; |
|
| 4053 | case '008080': |
|
| 4054 | $colorIdxFg = 0x15; |
|
| 4055 | break; |
|
| 4056 | case 'C0C0C0': |
|
| 4057 | $colorIdxFg = 0x16; |
|
| 4058 | break; |
|
| 4059 | case '808080': |
|
| 4060 | $colorIdxFg = 0x17; |
|
| 4061 | break; |
|
| 4062 | case '9999FF': |
|
| 4063 | $colorIdxFg = 0x18; |
|
| 4064 | break; |
|
| 4065 | case '993366': |
|
| 4066 | $colorIdxFg = 0x19; |
|
| 4067 | break; |
|
| 4068 | case 'FFFFCC': |
|
| 4069 | $colorIdxFg = 0x1A; |
|
| 4070 | break; |
|
| 4071 | case 'CCFFFF': |
|
| 4072 | $colorIdxFg = 0x1B; |
|
| 4073 | break; |
|
| 4074 | case '660066': |
|
| 4075 | $colorIdxFg = 0x1C; |
|
| 4076 | break; |
|
| 4077 | case 'FF8080': |
|
| 4078 | $colorIdxFg = 0x1D; |
|
| 4079 | break; |
|
| 4080 | case '0066CC': |
|
| 4081 | $colorIdxFg = 0x1E; |
|
| 4082 | break; |
|
| 4083 | case 'CCCCFF': |
|
| 4084 | $colorIdxFg = 0x1F; |
|
| 4085 | break; |
|
| 4086 | case '000080': |
|
| 4087 | $colorIdxFg = 0x20; |
|
| 4088 | break; |
|
| 4089 | case 'FF00FF': |
|
| 4090 | $colorIdxFg = 0x21; |
|
| 4091 | break; |
|
| 4092 | case 'FFFF00': |
|
| 4093 | $colorIdxFg = 0x22; |
|
| 4094 | break; |
|
| 4095 | case '00FFFF': |
|
| 4096 | $colorIdxFg = 0x23; |
|
| 4097 | break; |
|
| 4098 | case '800080': |
|
| 4099 | $colorIdxFg = 0x24; |
|
| 4100 | break; |
|
| 4101 | case '800000': |
|
| 4102 | $colorIdxFg = 0x25; |
|
| 4103 | break; |
|
| 4104 | case '008080': |
|
| 4105 | $colorIdxFg = 0x26; |
|
| 4106 | break; |
|
| 4107 | case '0000FF': |
|
| 4108 | $colorIdxFg = 0x27; |
|
| 4109 | break; |
|
| 4110 | case '00CCFF': |
|
| 4111 | $colorIdxFg = 0x28; |
|
| 4112 | break; |
|
| 4113 | case 'CCFFFF': |
|
| 4114 | $colorIdxFg = 0x29; |
|
| 4115 | break; |
|
| 4116 | case 'CCFFCC': |
|
| 4117 | $colorIdxFg = 0x2A; |
|
| 4118 | break; |
|
| 4119 | case 'FFFF99': |
|
| 4120 | $colorIdxFg = 0x2B; |
|
| 4121 | break; |
|
| 4122 | case '99CCFF': |
|
| 4123 | $colorIdxFg = 0x2C; |
|
| 4124 | break; |
|
| 4125 | case 'FF99CC': |
|
| 4126 | $colorIdxFg = 0x2D; |
|
| 4127 | break; |
|
| 4128 | case 'CC99FF': |
|
| 4129 | $colorIdxFg = 0x2E; |
|
| 4130 | break; |
|
| 4131 | case 'FFCC99': |
|
| 4132 | $colorIdxFg = 0x2F; |
|
| 4133 | break; |
|
| 4134 | case '3366FF': |
|
| 4135 | $colorIdxFg = 0x30; |
|
| 4136 | break; |
|
| 4137 | case '33CCCC': |
|
| 4138 | $colorIdxFg = 0x31; |
|
| 4139 | break; |
|
| 4140 | case '99CC00': |
|
| 4141 | $colorIdxFg = 0x32; |
|
| 4142 | break; |
|
| 4143 | case 'FFCC00': |
|
| 4144 | $colorIdxFg = 0x33; |
|
| 4145 | break; |
|
| 4146 | case 'FF9900': |
|
| 4147 | $colorIdxFg = 0x34; |
|
| 4148 | break; |
|
| 4149 | case 'FF6600': |
|
| 4150 | $colorIdxFg = 0x35; |
|
| 4151 | break; |
|
| 4152 | case '666699': |
|
| 4153 | $colorIdxFg = 0x36; |
|
| 4154 | break; |
|
| 4155 | case '969696': |
|
| 4156 | $colorIdxFg = 0x37; |
|
| 4157 | break; |
|
| 4158 | case '003366': |
|
| 4159 | $colorIdxFg = 0x38; |
|
| 4160 | break; |
|
| 4161 | case '339966': |
|
| 4162 | $colorIdxFg = 0x39; |
|
| 4163 | break; |
|
| 4164 | case '003300': |
|
| 4165 | $colorIdxFg = 0x3A; |
|
| 4166 | break; |
|
| 4167 | case '333300': |
|
| 4168 | $colorIdxFg = 0x3B; |
|
| 4169 | break; |
|
| 4170 | case '993300': |
|
| 4171 | $colorIdxFg = 0x3C; |
|
| 4172 | break; |
|
| 4173 | case '993366': |
|
| 4174 | $colorIdxFg = 0x3D; |
|
| 4175 | break; |
|
| 4176 | case '333399': |
|
| 4177 | $colorIdxFg = 0x3E; |
|
| 4178 | break; |
|
| 4179 | case '333333': |
|
| 4180 | $colorIdxFg = 0x3F; |
|
| 4181 | break; |
|
| 4182 | default: |
|
| 4183 | $colorIdxFg = 0x40; |
|
| 4184 | break; |
|
| 4185 | } |
|
| 4186 | $dataBlockFill = pack('v', $blockFillPatternStyle); |
|
| 4187 | $dataBlockFill .= pack('v', $colorIdxFg | ($colorIdxBg << 7)); |
|
| 4188 | } |
|
