PHPOffice /
PhpSpreadsheet
| @@ 4813-4838 (lines=26) @@ | ||
| 4810 | ||
| 4811 | // bit: 0-3; mask: 0x0000000F; type |
|
| 4812 | $type = (0x0000000F & $options) >> 0; |
|
| 4813 | switch ($type) { |
|
| 4814 | case 0x00: |
|
| 4815 | $type = DataValidation::TYPE_NONE; |
|
| 4816 | ||
| 4817 | break; |
|
| 4818 | case 0x01: |
|
| 4819 | $type = DataValidation::TYPE_WHOLE; |
|
| 4820 | ||
| 4821 | break; |
|
| 4822 | case 0x02: |
|
| 4823 | $type = DataValidation::TYPE_DECIMAL; |
|
| 4824 | ||
| 4825 | break; |
|
| 4826 | case 0x03: |
|
| 4827 | $type = DataValidation::TYPE_LIST; |
|
| 4828 | ||
| 4829 | break; |
|
| 4830 | case 0x04: |
|
| 4831 | $type = DataValidation::TYPE_DATE; |
|
| 4832 | ||
| 4833 | break; |
|
| 4834 | case 0x05: |
|
| 4835 | $type = DataValidation::TYPE_TIME; |
|
| 4836 | ||
| 4837 | break; |
|
| 4838 | case 0x06: |
|
| 4839 | $type = DataValidation::TYPE_TEXTLENGTH; |
|
| 4840 | ||
| 4841 | break; |
|
| @@ 4883-4908 (lines=26) @@ | ||
| 4880 | ||
| 4881 | // bit: 20-23; mask: 0x00F00000; condition operator |
|
| 4882 | $operator = (0x00F00000 & $options) >> 20; |
|
| 4883 | switch ($operator) { |
|
| 4884 | case 0x00: |
|
| 4885 | $operator = DataValidation::OPERATOR_BETWEEN; |
|
| 4886 | ||
| 4887 | break; |
|
| 4888 | case 0x01: |
|
| 4889 | $operator = DataValidation::OPERATOR_NOTBETWEEN; |
|
| 4890 | ||
| 4891 | break; |
|
| 4892 | case 0x02: |
|
| 4893 | $operator = DataValidation::OPERATOR_EQUAL; |
|
| 4894 | ||
| 4895 | break; |
|
| 4896 | case 0x03: |
|
| 4897 | $operator = DataValidation::OPERATOR_NOTEQUAL; |
|
| 4898 | ||
| 4899 | break; |
|
| 4900 | case 0x04: |
|
| 4901 | $operator = DataValidation::OPERATOR_GREATERTHAN; |
|
| 4902 | ||
| 4903 | break; |
|
| 4904 | case 0x05: |
|
| 4905 | $operator = DataValidation::OPERATOR_LESSTHAN; |
|
| 4906 | ||
| 4907 | break; |
|
| 4908 | case 0x06: |
|
| 4909 | $operator = DataValidation::OPERATOR_GREATERTHANOREQUAL; |
|
| 4910 | ||
| 4911 | break; |
|
| @@ 2697-2722 (lines=26) @@ | ||
| 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; |
|
| @@ 2772-2797 (lines=26) @@ | ||
| 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; |
|
