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