PHPOffice /
PhpSpreadsheet
| @@ 4811-4844 (lines=34) @@ | ||
| 4808 | ||
| 4809 | // bit: 0-3; mask: 0x0000000F; type |
|
| 4810 | $type = (0x0000000F & $options) >> 0; |
|
| 4811 | switch ($type) { |
|
| 4812 | case 0x00: |
|
| 4813 | $type = DataValidation::TYPE_NONE; |
|
| 4814 | ||
| 4815 | break; |
|
| 4816 | case 0x01: |
|
| 4817 | $type = DataValidation::TYPE_WHOLE; |
|
| 4818 | ||
| 4819 | break; |
|
| 4820 | case 0x02: |
|
| 4821 | $type = DataValidation::TYPE_DECIMAL; |
|
| 4822 | ||
| 4823 | break; |
|
| 4824 | case 0x03: |
|
| 4825 | $type = DataValidation::TYPE_LIST; |
|
| 4826 | ||
| 4827 | break; |
|
| 4828 | case 0x04: |
|
| 4829 | $type = DataValidation::TYPE_DATE; |
|
| 4830 | ||
| 4831 | break; |
|
| 4832 | case 0x05: |
|
| 4833 | $type = DataValidation::TYPE_TIME; |
|
| 4834 | ||
| 4835 | break; |
|
| 4836 | case 0x06: |
|
| 4837 | $type = DataValidation::TYPE_TEXTLENGTH; |
|
| 4838 | ||
| 4839 | break; |
|
| 4840 | case 0x07: |
|
| 4841 | $type = DataValidation::TYPE_CUSTOM; |
|
| 4842 | ||
| 4843 | break; |
|
| 4844 | } |
|
| 4845 | ||
| 4846 | // bit: 4-6; mask: 0x00000070; error type |
|
| 4847 | $errorStyle = (0x00000070 & $options) >> 4; |
|
| @@ 4881-4914 (lines=34) @@ | ||
| 4878 | ||
| 4879 | // bit: 20-23; mask: 0x00F00000; condition operator |
|
| 4880 | $operator = (0x00F00000 & $options) >> 20; |
|
| 4881 | switch ($operator) { |
|
| 4882 | case 0x00: |
|
| 4883 | $operator = DataValidation::OPERATOR_BETWEEN; |
|
| 4884 | ||
| 4885 | break; |
|
| 4886 | case 0x01: |
|
| 4887 | $operator = DataValidation::OPERATOR_NOTBETWEEN; |
|
| 4888 | ||
| 4889 | break; |
|
| 4890 | case 0x02: |
|
| 4891 | $operator = DataValidation::OPERATOR_EQUAL; |
|
| 4892 | ||
| 4893 | break; |
|
| 4894 | case 0x03: |
|
| 4895 | $operator = DataValidation::OPERATOR_NOTEQUAL; |
|
| 4896 | ||
| 4897 | break; |
|
| 4898 | case 0x04: |
|
| 4899 | $operator = DataValidation::OPERATOR_GREATERTHAN; |
|
| 4900 | ||
| 4901 | break; |
|
| 4902 | case 0x05: |
|
| 4903 | $operator = DataValidation::OPERATOR_LESSTHAN; |
|
| 4904 | ||
| 4905 | break; |
|
| 4906 | case 0x06: |
|
| 4907 | $operator = DataValidation::OPERATOR_GREATERTHANOREQUAL; |
|
| 4908 | ||
| 4909 | break; |
|
| 4910 | case 0x07: |
|
| 4911 | $operator = DataValidation::OPERATOR_LESSTHANOREQUAL; |
|
| 4912 | ||
| 4913 | break; |
|
| 4914 | } |
|
| 4915 | ||
| 4916 | // offset: 4; size: var; title of the prompt box |
|
| 4917 | $offset = 4; |
|
| @@ 2697-2730 (lines=34) @@ | ||
| 2694 | ||
| 2695 | // data type |
|
| 2696 | $type = 0x00; |
|
| 2697 | switch ($dataValidation->getType()) { |
|
| 2698 | case DataValidation::TYPE_NONE: |
|
| 2699 | $type = 0x00; |
|
| 2700 | ||
| 2701 | break; |
|
| 2702 | case DataValidation::TYPE_WHOLE: |
|
| 2703 | $type = 0x01; |
|
| 2704 | ||
| 2705 | break; |
|
| 2706 | case DataValidation::TYPE_DECIMAL: |
|
| 2707 | $type = 0x02; |
|
| 2708 | ||
| 2709 | break; |
|
| 2710 | case DataValidation::TYPE_LIST: |
|
| 2711 | $type = 0x03; |
|
| 2712 | ||
| 2713 | break; |
|
| 2714 | case DataValidation::TYPE_DATE: |
|
| 2715 | $type = 0x04; |
|
| 2716 | ||
| 2717 | break; |
|
| 2718 | case DataValidation::TYPE_TIME: |
|
| 2719 | $type = 0x05; |
|
| 2720 | ||
| 2721 | break; |
|
| 2722 | case DataValidation::TYPE_TEXTLENGTH: |
|
| 2723 | $type = 0x06; |
|
| 2724 | ||
| 2725 | break; |
|
| 2726 | case DataValidation::TYPE_CUSTOM: |
|
| 2727 | $type = 0x07; |
|
| 2728 | ||
| 2729 | break; |
|
| 2730 | } |
|
| 2731 | ||
| 2732 | $options |= $type << 0; |
|
| 2733 | ||
| @@ 2772-2805 (lines=34) @@ | ||
| 2769 | ||
| 2770 | // condition operator |
|
| 2771 | $operator = 0x00; |
|
| 2772 | switch ($dataValidation->getOperator()) { |
|
| 2773 | case DataValidation::OPERATOR_BETWEEN: |
|
| 2774 | $operator = 0x00; |
|
| 2775 | ||
| 2776 | break; |
|
| 2777 | case DataValidation::OPERATOR_NOTBETWEEN: |
|
| 2778 | $operator = 0x01; |
|
| 2779 | ||
| 2780 | break; |
|
| 2781 | case DataValidation::OPERATOR_EQUAL: |
|
| 2782 | $operator = 0x02; |
|
| 2783 | ||
| 2784 | break; |
|
| 2785 | case DataValidation::OPERATOR_NOTEQUAL: |
|
| 2786 | $operator = 0x03; |
|
| 2787 | ||
| 2788 | break; |
|
| 2789 | case DataValidation::OPERATOR_GREATERTHAN: |
|
| 2790 | $operator = 0x04; |
|
| 2791 | ||
| 2792 | break; |
|
| 2793 | case DataValidation::OPERATOR_LESSTHAN: |
|
| 2794 | $operator = 0x05; |
|
| 2795 | ||
| 2796 | break; |
|
| 2797 | case DataValidation::OPERATOR_GREATERTHANOREQUAL: |
|
| 2798 | $operator = 0x06; |
|
| 2799 | ||
| 2800 | break; |
|
| 2801 | case DataValidation::OPERATOR_LESSTHANOREQUAL: |
|
| 2802 | $operator = 0x07; |
|
| 2803 | ||
| 2804 | break; |
|
| 2805 | } |
|
| 2806 | ||
| 2807 | $options |= $operator << 20; |
|
| 2808 | ||
