PHPOffice / PhpSpreadsheet

        // bit: 4-6; mask: 0x00000070; error type

        $errorStyle = (0x00000070 & $options) >> 4;

        switch ($errorStyle) {

            case 0x00:

                $errorStyle = \PhpOffice\PhpSpreadsheet\Cell\DataValidation::STYLE_STOP;

                break;

            case 0x01:

                $errorStyle = \PhpOffice\PhpSpreadsheet\Cell\DataValidation::STYLE_WARNING;

                break;

            case 0x02:

                $errorStyle = \PhpOffice\PhpSpreadsheet\Cell\DataValidation::STYLE_INFORMATION;

                break;

        }

        // bit: 7; mask: 0x00000080; 1= formula is explicit (only applies to list)

        // I have only seen cases where this is 1

                // error style

                $errorStyle = $dataValidation->getErrorStyle();

                switch ($errorStyle) {

                    case \PhpOffice\PhpSpreadsheet\Cell\DataValidation::STYLE_STOP:

                        $errorStyle = 0x00;

                        break;

                    case \PhpOffice\PhpSpreadsheet\Cell\DataValidation::STYLE_WARNING:

                        $errorStyle = 0x01;

                        break;

                    case \PhpOffice\PhpSpreadsheet\Cell\DataValidation::STYLE_INFORMATION:

                        $errorStyle = 0x02;

                        break;

                }

                $options |= $errorStyle << 4;