PHPOffice /
PhpSpreadsheet
| @@ 2827-2852 (lines=26) @@ | ||
| 2824 | ||
| 2825 | // data type |
|
| 2826 | $type = $dataValidation->getType(); |
|
| 2827 | switch ($type) { |
|
| 2828 | case DataValidation::TYPE_NONE: |
|
| 2829 | $type = 0x00; |
|
| 2830 | break; |
|
| 2831 | case DataValidation::TYPE_WHOLE: |
|
| 2832 | $type = 0x01; |
|
| 2833 | break; |
|
| 2834 | case DataValidation::TYPE_DECIMAL: |
|
| 2835 | $type = 0x02; |
|
| 2836 | break; |
|
| 2837 | case DataValidation::TYPE_LIST: |
|
| 2838 | $type = 0x03; |
|
| 2839 | break; |
|
| 2840 | case DataValidation::TYPE_DATE: |
|
| 2841 | $type = 0x04; |
|
| 2842 | break; |
|
| 2843 | case DataValidation::TYPE_TIME: |
|
| 2844 | $type = 0x05; |
|
| 2845 | break; |
|
| 2846 | case DataValidation::TYPE_TEXTLENGTH: |
|
| 2847 | $type = 0x06; |
|
| 2848 | break; |
|
| 2849 | case DataValidation::TYPE_CUSTOM: |
|
| 2850 | $type = 0x07; |
|
| 2851 | break; |
|
| 2852 | } |
|
| 2853 | ||
| 2854 | $options |= $type << 0; |
|
| 2855 | ||
| @@ 2891-2916 (lines=26) @@ | ||
| 2888 | ||
| 2889 | // condition operator |
|
| 2890 | $operator = $dataValidation->getOperator(); |
|
| 2891 | switch ($operator) { |
|
| 2892 | case DataValidation::OPERATOR_BETWEEN: |
|
| 2893 | $operator = 0x00; |
|
| 2894 | break; |
|
| 2895 | case DataValidation::OPERATOR_NOTBETWEEN: |
|
| 2896 | $operator = 0x01; |
|
| 2897 | break; |
|
| 2898 | case DataValidation::OPERATOR_EQUAL: |
|
| 2899 | $operator = 0x02; |
|
| 2900 | break; |
|
| 2901 | case DataValidation::OPERATOR_NOTEQUAL: |
|
| 2902 | $operator = 0x03; |
|
| 2903 | break; |
|
| 2904 | case DataValidation::OPERATOR_GREATERTHAN: |
|
| 2905 | $operator = 0x04; |
|
| 2906 | break; |
|
| 2907 | case DataValidation::OPERATOR_LESSTHAN: |
|
| 2908 | $operator = 0x05; |
|
| 2909 | break; |
|
| 2910 | case DataValidation::OPERATOR_GREATERTHANOREQUAL: |
|
| 2911 | $operator = 0x06; |
|
| 2912 | break; |
|
| 2913 | case DataValidation::OPERATOR_LESSTHANOREQUAL: |
|
| 2914 | $operator = 0x07; |
|
| 2915 | break; |
|
| 2916 | } |
|
| 2917 | ||
| 2918 | $options |= $operator << 20; |
|
| 2919 | ||
| @@ 4661-4686 (lines=26) @@ | ||
| 4658 | ||
| 4659 | // bit: 0-3; mask: 0x0000000F; type |
|
| 4660 | $type = (0x0000000F & $options) >> 0; |
|
| 4661 | switch ($type) { |
|
| 4662 | case 0x00: |
|
| 4663 | $type = DataValidation::TYPE_NONE; |
|
| 4664 | break; |
|
| 4665 | case 0x01: |
|
| 4666 | $type = DataValidation::TYPE_WHOLE; |
|
| 4667 | break; |
|
| 4668 | case 0x02: |
|
| 4669 | $type = DataValidation::TYPE_DECIMAL; |
|
| 4670 | break; |
|
| 4671 | case 0x03: |
|
| 4672 | $type = DataValidation::TYPE_LIST; |
|
| 4673 | break; |
|
| 4674 | case 0x04: |
|
| 4675 | $type = DataValidation::TYPE_DATE; |
|
| 4676 | break; |
|
| 4677 | case 0x05: |
|
| 4678 | $type = DataValidation::TYPE_TIME; |
|
| 4679 | break; |
|
| 4680 | case 0x06: |
|
| 4681 | $type = DataValidation::TYPE_TEXTLENGTH; |
|
| 4682 | break; |
|
| 4683 | case 0x07: |
|
| 4684 | $type = DataValidation::TYPE_CUSTOM; |
|
| 4685 | break; |
|
| 4686 | } |
|
| 4687 | ||
| 4688 | // bit: 4-6; mask: 0x00000070; error type |
|
| 4689 | $errorStyle = (0x00000070 & $options) >> 4; |
|
| @@ 4720-4745 (lines=26) @@ | ||
| 4717 | ||
| 4718 | // bit: 20-23; mask: 0x00F00000; condition operator |
|
| 4719 | $operator = (0x00F00000 & $options) >> 20; |
|
| 4720 | switch ($operator) { |
|
| 4721 | case 0x00: |
|
| 4722 | $operator = DataValidation::OPERATOR_BETWEEN; |
|
| 4723 | break; |
|
| 4724 | case 0x01: |
|
| 4725 | $operator = DataValidation::OPERATOR_NOTBETWEEN; |
|
| 4726 | break; |
|
| 4727 | case 0x02: |
|
| 4728 | $operator = DataValidation::OPERATOR_EQUAL; |
|
| 4729 | break; |
|
| 4730 | case 0x03: |
|
| 4731 | $operator = DataValidation::OPERATOR_NOTEQUAL; |
|
| 4732 | break; |
|
| 4733 | case 0x04: |
|
| 4734 | $operator = DataValidation::OPERATOR_GREATERTHAN; |
|
| 4735 | break; |
|
| 4736 | case 0x05: |
|
| 4737 | $operator = DataValidation::OPERATOR_LESSTHAN; |
|
| 4738 | break; |
|
| 4739 | case 0x06: |
|
| 4740 | $operator = DataValidation::OPERATOR_GREATERTHANOREQUAL; |
|
| 4741 | break; |
|
| 4742 | case 0x07: |
|
| 4743 | $operator = DataValidation::OPERATOR_LESSTHANOREQUAL; |
|
| 4744 | break; |
|
| 4745 | } |
|
| 4746 | ||
| 4747 | // offset: 4; size: var; title of the prompt box |
|
| 4748 | $offset = 4; |
|
