{"text_format":"3","workbook":"xls","n_sheets":2,"sheets":["统计","个人信息"],"not_rendered":{"external_links":1,"defined_names":2},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"统计","index":0,"n_rows":3,"n_cols":8,"rows_kept":3,"flags":["formulas_cached_only"]}
["作成者：",null,"作成日：",null,"承认者：",null,"承认日："]
["功能模块","用例数目","OK","NG","NA","已测试","未测试","执行率"]
["个人信息",29,0,0,0,0,29,{"v":0,"d":"0%"}]

{"sheet":"个人信息","index":1,"n_rows":30,"n_cols":10,"rows_kept":30,"merged":[[2,1,7,1],[2,2,7,2],[4,3,7,3],[8,1,29,1],[10,2,12,2],[13,2,16,2],[17,2,20,2],[21,2,24,2],[25,2,27,2]],"flags":["formulas_cached_only"]}
["编号","测试项目","测试步骤","测试条件分支","测试条件分支明细","期待结果","判定履历","担当者","最新结果","BUG票ID"]
[1,"界面展示","点击菜单栏的公文管理，在功能导航选择个人办公的个人信息",null,null,"1.在个人信息页签打开，当前位置显示正确；\n2.页面的右上方有密码和编辑按钮；\n3.一览姓名、性别、用户名、工号、Email、微信、QQ、手机、电话、个人头像、所属机构、所属部门内容显示正确，处于不可编辑状态，并与数据库保持一致；"]
[2,"修改密码","点击密码按钮",null,null,"弹出窗口，界面展示旧密码、新密码、确认密码这3个输入框，每个输入框名称有红色*；下方有完成和取消按钮"]
[3,null,null,"必填项不输入点击完成按钮",null,"修改失败，弹出对话框，提示输入必填项"]
[4,null,null,"必填项全填点击完成按钮","旧密码输入不对","修改失败，提示“旧密码不对”，点击确定返回修改窗口"]
[5,{"$nulls":3},"旧密码与新密码相同","修改失败，提示“新旧密码不能相同”，点击确定返回修改窗口"]
[6,{"$nulls":3},"新密码与确认密码不同","修改失败，提示“新密码和确认密码不同”，点击确定返回修改窗口"]
[7,{"$nulls":3},"旧密码输入正确，新旧密码不相同，新密码与确认密码相同","修改成功，返回个人信息界面"]
[8,"编辑信息",{"$nulls":3},"1.在个人信息页签打开，当前位置显示正确；\n2.页面的右上方有保存、重置、取消按钮；\n3.一览姓名、性别、用户名、工号、Email、微信、QQ、手机、电话、个人头像、所属机构、所属部门内容显示正确，其中姓名、用户名、所属机构、所属部门处于不可编辑状态，并与数据库保持一致；\n4.头像下方有上传头像控件"]
[9,null,"输入框输入字符串长度超过最大",null,null,"不再显示超过长度的字符"]
[10,null,"Email输入框输入内容，点击保存","Email输入框输入不是**@**.**格式",null,"修改失败，提示“请输入正确的邮箱地址”"]
[11,null,null,"Email输入框输入是**@**.**格式，且包含非数字、字母的字符",null,"修改失败，提示“请输入正确的邮箱地址”"]
[12,null,null,"Email输入框输入是**@**.**格式，且不包含非数字、字母的字符",null,"修改成功，返回个人信息，Email输入框内容显示正确"]
[13,null,"QQ输入框输入内容，点击保存","QQ输入框包含非数字的字符",null,"修改失败，提示“请输入正确的QQ号”"]
[14,null,null,"QQ输入框不包含非数字的字符，字符串长度小于5",null,"修改失败，提示“请输入正确的QQ号”"]
[15,null,null,"QQ输入框不包含非数字的字符，字符串长度大于10",null,"修改失败，提示“请输入正确的QQ号”"]
[16,null,null,"QQ输入框不包含非数字的字符，字符串长度不小于5，且不大于10",null,"修改成功，返回个人信息，QQ输入框内容显示正确"]
[17,null,"手机号输入框输入内容，点击保存","手机号输入框包含非数字的字符",null,"修改失败，提示“请输入正确的手机号”"]
[18,null,null,"手机输入框不包含非数字的字符，字符串长度不等于11",null,"修改失败，提示“请输入正确的手机号”"]
[19,null,null,"手机输入框不包含非数字的字符，字符串长度等于11，开头两位数不是13，15，18这三种之一",null,"修改失败，提示“请输入正确的手机号”"]
[20,null,null,"手机输入框不包含非数字的字符，字符串长度等于11，开头两位数是13，15，19这三种之一",null,"修改成功，返回个人信息，手机输入框内容显示正确"]
[21,null,"电话输入框输入内容，点击保存","电话输入框包含非数字的字符",null,"修改失败，提示“请输入正确的电话号码”"]
[22,null,null,"电话输入框不包含非数字的字符，字符串长度小于10",null,"修改失败，提示“请输入正确的电话号码”"]
[23,null,null,"电话输入框不包含非数字的字符，字符串长度大于11",null,"修改失败，提示“请输入正确的电话号码”"]
[24,null,null,"电话输入框不包含非数字的字符，字符串长度不小于10，且不大于11",null,"修改成功，返回个人信息，电话输入框内容显示正确"]
[25,null,"点击上传头像控件","选择不是png、jpg、jpeg格式的文件",null,"上传失败，弹出对话框，提示“请上传png、jpg、jpeg格式图片”，点击确定，返回信息编辑界面"]
[26,null,null,"选择png、jpg、jpeg格式的文件，大小超过1M",null,"上传失败，弹出对话框，提示“图片大小不能超过1M”，点击确定，返回信息编辑界面"]
[27,null,null,"选择png、jpg、jpeg格式的文件，大小不超过1M",null,"上传成功，返回信息编辑界面，头像为刚上传的图片"]
[28,null,"点击重置",null,null,"个人信息内容初始化到最新保存的数据"]
[29,null,"点击取消",null,null,"返回到个人信息查看界面，内容未做修改"]