def test_ss_filter_cd1_none(self):
logging.info('==========test_ss_filter_cd1_none==========')
ss = SSView(self.driver)
ov = OpenView(self.driver)
ov.open_file('screen.xls')
ss.switch_write_read()
ss.cell_edit()
x, y, width, height = ss.cell_location()
ss.tap(x + width / 2, y - height / 2)
ss.group_button_click(' View ')
self.driver.find_element(
By.ID,
'com.yozo.office.en:id/yozo_ui_ss_option_id_filter').click()
for i in range(3):
x1 = x - width * (1 - i) - 18
y1 = y - height * 3 - 27
ss.tap(x1, y1)
self.driver.find_element(By.XPATH, '//*[@text="自定义"]').click()
self.driver.find_element(
By.ID, 'com.yozo.office.en:id/tv_filter_condition1').click()
self.driver.find_element(
By.XPATH,
'//android.widget.ListView/android.widget.LinearLayout[1]'
).click()
self.driver.find_element(
By.ID, 'com.yozo.office.en:id/tv_ss_filter_ok').click()
self.assertTrue(ss.get_toast_message('第一个条件不能为空'))
self.driver.find_element(
By.ID, 'com.yozo.office.en:id/iv_ss_customize_back').click()
def test_insert_chart1(self, file_type):
logging.info('==========test_insert_chart1==========')
cv = CreateView(self.driver)
cv.create_file(file_type)
gv = GeneralView(self.driver)
ss = SSView(self.driver)
time.sleep(1)
if file_type == 'ss':
x, y, width, height = ss.cell_location()
for i in range(3):
cv.tap(x + width * 0.5, y + height * (i + 0.5))
ss.cell_edit() # 双击进入编辑
self.driver.press_keycode(random.randint(7, 16))
gv.drag_coordinate(x, y + height * 2, x, y)
gv.group_button_click(' Insert ')
if file_type == 'pg':
ele1 = '//*[@text=" Slide "]'
ele2 = '//*[@text=" Picture "]'
gv.swipe_ele(ele2, ele1)
gv.insert_chart_insert(' Column Chart ', random.randint(1, 9))
gv.chart_color(random.randint(1, 8))
gv.chart_element(file_type, '大标题', 1, 1, 1)
gv.chart_element_XY('x', 'x', 0, 1, 1, 1, 1, 1)
gv.chart_element_XY('y', 'y', 0, 1, 1, 0, 1, 0)
self.driver.find_element(
By.ID, 'com.yozo.office.en:id/yozo_ui_option_back_button').click()
gv.change_row_column()
time.sleep(3)
def test_ss_filter_by_num_shortcut(self):
logging.info('==========test_ss_filter_by_num_shortcut==========')
ss = SSView(self.driver)
ov = OpenView(self.driver)
ov.open_file('screen.xls')
ss.switch_write_read()
ss.cell_edit()
x, y, width, height = ss.cell_location()
ss.tap(x + width / 2, y - height / 2)
ss.group_button_click(' View ')
self.driver.find_element(
By.ID,
'com.yozo.office.en:id/yozo_ui_ss_option_id_filter').click()
x1 = x - 18
y1 = y - height * 3 - 27
ss.tap(x1, y1)
self.driver.find_element(By.XPATH, '//*[@text="自定义"]').click()
self.driver.find_element(By.XPATH, '//*[@text="前十项"]').click()
self.driver.find_element(By.ID, 'com.yozo.office.en:id/tv_ok').click()
ss.tap(x1, y1, 2) # 非初次需要点两次
self.driver.find_element(By.XPATH, '//*[@text="自定义"]').click()
self.driver.find_element(By.XPATH, '//*[@text="高于平均值"]').click()
ss.tap(x1, y1, 2)
self.driver.find_element(By.XPATH, '//*[@text="自定义"]').click()
self.driver.find_element(By.XPATH, '//*[@text="低于平均值"]').click()
def test_ss_filter1(self):
logging.info('==========test_ss_filter1==========')
gv = GeneralView(self.driver)
ss = SSView(self.driver)
cv = CreateView(self.driver)
cv.create_file(self.file_type)
gv.group_button_click(' View ')
self.driver.find_element(
By.ID,
'com.yozo.office.en:id/yozo_ui_ss_option_id_filter').click()
tip = self.driver.find_element(By.ID,
'com.yozo.office.en:id/text_content')
self.assertTrue(tip != None)
self.driver.find_element(By.ID,
'com.yozo.office.en:id/btn_right').click()
ss.cell_edit()
x, y, width, height = ss.cell_location()
self.driver.press_keycode(15)
self.driver.press_keycode(7)
self.driver.press_keycode(7)
self.driver.press_keycode(7)
gv.tap(x + width / 2, y - height / 2)
gv.group_button_click(' View ')
self.driver.find_element(
By.ID,
'com.yozo.office.en:id/yozo_ui_ss_option_id_filter').click()
state = self.driver.find_element(
By.ID,
'com.yozo.office.en:id/yozo_ui_option_group_checkbox_switch').text
self.assertTrue(state == 'ON')
print(x, y)
gv.tap(x + width - 10, y + height)
def test_pop_cell_row_col1(self): # 单元格、行、列相关操作
logging.info('==========test_pop_cell_row_col1==========')
cv = CreateView(self.driver)
cv.create_file(self.file_type)
gv = GeneralView(self.driver)
ss = SSView(self.driver)
time.sleep(1)
x, y, width, height = ss.cell_location() # 新建默认B8
ss.cell_edit() # 进入 Edit
for i in range(8):
self.driver.press_keycode(random.randint(29, 54))
self.driver.find_element(
By.ID, 'com.yozo.office.en:id/formulabar_ok').click()
time.sleep(0.5)
cv.tap(x + width * 0.5, y + height * 0.5) # 复制粘贴
gv.pop_menu_click('copy')
cv.tap(x + width * 1.5, y + height * 1.5)
cv.tap(x + width * 1.5, y + height * 1.5)
gv.pop_menu_click('paste')
cv.tap(x + width * 0.5, y + height * 0.5)
gv.pop_menu_click('cut')
cv.tap(x + width * 2.5, y + height * 2.5)
cv.tap(x + width * 2.5, y + height * 2.5)
gv.pop_menu_click('paste')
x, y = gv.find_pic_position('drag_point2') # 多选单元格
gv.drag_coordinate(x, y, x + width, y + height)
def test_ss_merge_wrap(self):
logging.info('==========test_ss_merge_wrap==========')
gv = GeneralView(self.driver)
cv = CreateView(self.driver)
cv.create_file('ss')
ss = SSView(self.driver)
ss.cell_edit()
x, y, width, height = ss.cell_location()
for i in range(20):
self.driver.press_keycode(45)
self.driver.find_element(
By.ID, 'com.yozo.office.en:id/formulabar_ok').click()
ss.tap(x + width * 1.5, y + height * 2.5)
x1, y1 = gv.find_pic_position("drag_point1")
cv.drag_coordinate(x1, y1, x, y)
ss.group_button_click(' Edit ')
ele = '//*[@resource-id="com.yozo.office.en:id/yozo_ui_option_content_container"]'
ss.swipe_options(ele, 'up')
ss.swipe_options(ele, 'up')
ss.swipe_options(ele, 'up')
ss.cell_merge_split()
ss.cell_merge_split()
ss.cell_auto_wrap()
ss.cell_auto_wrap()
time.sleep(1)
def test_shape_attr1(self, file_type): # 文本框字符属性
logging.info('==========test_shape_attr1==========')
cv = CreateView(self.driver)
cv.create_file(file_type)
gv = GeneralView(self.driver)
x1, y1 = 0, 0
if file_type == 'ss':
ss = SSView(self.driver)
x1, y1, w, h = ss.cell_location()
self.driver.find_element(
By.ID, 'com.yozo.office.en:id/formulabar_ok').click()
gv.group_button_click(' Insert ')
gv.insert_shape(file_type)
time.sleep(1)
x, y = gv.find_pic_position('drag_all')
gv.tap(x, y) # 进入编辑
gv.pop_menu_click('editText')
if file_type == 'ss':
gv.fold_expand()
gv.fold_expand()
x, y = gv.find_pic_position('drag_all')
gv.tap(x, y) # 进入编辑
gv.pop_menu_click('editText')
for i in range(50):
self.driver.press_keycode(random.randint(7, 16))
if file_type == 'pg':
gv.tap(250, 250)
gv.tap(550, 850)
elif file_type == 'ss':
gv.tap(x1, y1)
gv.tap(x, y)
else:
gv.tap(250, 450)
time.sleep(1)
gv.fold_expand()
gv.tap(x, y)
time.sleep(1)
gv.fold_expand()
gv.shape_option(file_type, 5, width=5, height=5)
gv.shape_option(file_type, 6, top=0.5, bottom=0.5, left=0.5, right=0.5)
ele1 = '//*[@text=" Shape "]'
ele2 = '//*[@text=" Outline "]'
ele3 = '//*[@text=" Effect "]'
if file_type == 'pg':
ele0 = '//*[@text=" Insert "]'
gv.swipe_ele(ele0, ele1)
gv.swipe_ele(ele2, ele1)
gv.swipe_ele(ele3, ele1)
gv.shape_content_align(file_type, '右对齐', '下对齐')
gv.shape_content_align(file_type)
gv.shape_content_align(file_type, '水平居中', '垂直居中')
time.sleep(3)
def test_formula1(self): # 其他类型公式
logging.info('==========test_formula1==========')
cv = CreateView(self.driver)
ss = SSView(self.driver)
cv.create_file('ss')
time.sleep(1)
x, y, width, height = ss.cell_location() # cell B8
for i in range(6):
ss.tap(x + width * 1.5, y + height * (1.5 + i))
ss.tap(x + width * 0.5, y + height * (1.5 + i))
ss.cell_edit()
self.driver.press_keycode(random.randint(7, 16))
formula_dic = {
' Recently Used ': 'MAX',
' Math and Trig ': 'GCD',
' Financial ': 'DOLLARDE',
' Logical ': 'AND',
' Text ': 'CONCATENATE',
' Date and Time ': 'DATE',
' Lookup and Reference ': 'CHOOSE',
' Statistical ': 'AVERAGE',
' Engineering ': 'IMPRODUCT',
' Database ': 'GETPIVOTDATA',
' Information ': 'ISBLANK',
' ALL ': 'MAX'
}
keys_list = [
' Recently Used ', ' Math and Trig ', ' Financial ', ' Logical ',
' Text ', ' Date and Time ', ' Lookup and Reference ',
' Statistical ', ' Engineering ', ' Database ', ' Information ',
' All '
]
for i in keys_list:
if keys_list.index(i) > 5:
ss.tap(x + width * 2.5,
y + height * (1.5 + keys_list.index(i) - 5))
else:
ss.tap(x + width * 1.5,
y + height * (1.5 + keys_list.index(i)))
ss.formula_all(i, formula_dic.get(i))
print(i, formula_dic.get(i))
# cv.tap(110 + 263 * 1.5, 295 + 55 * 1.5)
if i == ' Database ' or i == ' Date and Time ':
m = 3
elif i == ' Information ':
m = 1
else:
m = 6
for n in range(m):
ss.tap(x + width * 0.5, y + height * (1.5 + n))
self.driver.find_element(
By.ID, 'com.yozo.office.en:id/formulabar_ok').click()
def test_ss_filter_by_text(self):
logging.info('==========test_ss_filter_by_text==========')
ss = SSView(self.driver)
ov = OpenView(self.driver)
ov.open_file('screen.xls')
ss.switch_write_read()
ss.cell_edit()
x, y, width, height = ss.cell_location()
ss.tap(x + width / 2, y - height / 2)
ss.group_button_click(' View ')
self.driver.find_element(
By.ID,
'com.yozo.office.en:id/yozo_ui_ss_option_id_filter').click()
x1 = x + width - 18
y1 = y - height * 3 - 27
ss.filter_data(x1, y1, '自定义', TEXT_FILTER[random.randint(1, 12)],
TEXT_FILTER[random.randint(1, 12)])
def test_pop_cell_row_col3(self): # 单元格、行、列相关操作
logging.info('==========test_pop_cell_row_col3==========')
cv = CreateView(self.driver)
cv.create_file(self.file_type)
gv = GeneralView(self.driver)
ss = SSView(self.driver)
time.sleep(1)
x, y, width, height = ss.cell_location() # 新建默认B8
cv.tap(x + width * 0.5, y - height * 5.5)
ss.cell_edit() # 进入 Edit
for i in range(8):
self.driver.press_keycode(random.randint(29, 54))
self.driver.find_element(
By.ID, 'com.yozo.office.en:id/formulabar_ok').click()
time.sleep(0.5)
x1, y1, x2, y2 = ss.row_col_loc()
ss.tap(x2 + width * 1.5, y2 - 10)
gv.pop_menu_click('insert')
ss.tap(x2 + width * 1.5, y2 - 10)
gv.pop_menu_click('delete')
ss.tap(x2 + width * 1.5, y2 - 10)
gv.pop_menu_click('copy')
ss.tap(x2 + width * 2.5, y2 - 10)
x3, y3 = gv.find_pic_position('copy')
x4, y4 = gv.find_pic_position('insert')
gv.swipe(x3, y3, x4, y4)
time.sleep(1)
gv.pop_menu_click('paste')
ss.tap(x2 + width * 1.5, y2 - 10)
gv.pop_menu_click('cut')
ss.tap(x2 + width * 2.5, y2 - 10)
gv.pop_menu_click('paste')
ss.tap(x2 + width * 1.5, y2 - 10)
gv.pop_menu_click('hide')
ss.tap(x2 + width * 1.5, y2 - 10)
x3, y3 = gv.find_pic_position('hide')
x4, y4 = gv.find_pic_position('copy')
gv.swipe(x3, y3, x4, y4)
time.sleep(1)
gv.pop_menu_click('hide_cancel')
ss.tap(x2 + width * 1.5, y2 - 10)
x, y = gv.find_pic_position('column_right')
gv.drag_coordinate(x, y, x + width, y)
gv.drag_coordinate(x, y2 - 10, x + width, y2 - 10)
def test_ss_filter_by_color(self):
logging.info('==========test_ss_filter_cd1_none==========')
ss = SSView(self.driver)
ov = OpenView(self.driver)
ov.open_file('screen.xls')
ss.switch_write_read()
ss.cell_edit()
x, y, width, height = ss.cell_location()
ss.tap(x + width / 2, y - height / 2)
ss.group_button_click(' View ')
self.driver.find_element(
By.ID,
'com.yozo.office.en:id/yozo_ui_ss_option_id_filter').click()
x1 = x - width - 18
y1 = y - height * 3 - 27
ss.tap(x1, y1)
self.driver.find_element(By.XPATH, '//*[@text="自定义"]').click()
self.driver.find_element(
By.ID, 'com.yozo.office.en:id/tv_filter_color_type').click()
time.sleep(1)
self.driver.find_element(By.XPATH, '//*[@text="字体颜色"]').click()
eles = self.driver.find_elements(
By.XPATH,
'//android.support.v7.widget.RecyclerView/android.widget.RelativeLayout'
)
eles[random.randint(0, len(eles) - 1)].click()
self.driver.find_element(
By.ID, 'com.yozo.office.en:id/tv_ss_filter_ok').click()
ss.tap(x1, y1, 2)
self.driver.find_element(By.XPATH, '//*[@text="自定义"]').click()
self.driver.find_element(
By.ID, 'com.yozo.office.en:id/tv_filter_color_type').click()
time.sleep(1)
self.driver.find_element(By.XPATH, '//*[@text="单元格颜色"]').click()
eles = self.driver.find_elements(
By.XPATH,
'//android.support.v7.widget.RecyclerView/android.widget.RelativeLayout'
)
eles[random.randint(0, len(eles) - 1)].click()
self.driver.find_element(
By.ID, 'com.yozo.office.en:id/tv_ss_filter_ok').click()
def test_ss_formula_auto_sum(self):
logging.info('==========test_ss_formula_auto_sum==========')
cv = CreateView(self.driver)
cv.create_file('ss')
ss = SSView(self.driver)
x, y, width, height = ss.cell_location() # cell D6
for i in range(5):
ss.tap(x + width * 0.5, y + height * (1.5 + i))
ss.tap(x + width * 1.5, y + height * (1.5 + i))
ss.cell_edit()
self.driver.press_keycode(random.randint(7, 16))
for i, value in enumerate(AUTO_SUM):
ss.tap(x + width * 2.5, y + height * (1.5 + i)) # 求和
ss.auto_sum(AUTO_SUM[i])
for n in range(5): # 依次点击代替拖动
ss.tap(x + width * 1.5, y + height * (1.5 + n))
# ss.drag_coordinate(x + width, y + height * 5, x + width, y + height)
self.driver.find_element(
By.ID, 'com.yozo.office.en:id/formulabar_ok').click()
def test_ss_filter2(self):
logging.info('==========test_ss_filter2==========')
ss = SSView(self.driver)
ov = OpenView(self.driver)
ov.open_file('screen.xls')
ss.switch_write_read()
ss.cell_edit()
x, y, width, height = ss.cell_location()
ss.tap(x + width / 2, y - height / 2)
ss.group_button_click(' View ')
self.driver.find_element(
By.ID,
'com.yozo.office.en:id/yozo_ui_ss_option_id_filter').click()
x1 = x - width - 18
y1 = y - height * 3 - 27
ss.tap(x1, y1)
self.driver.find_element_by_id(
'com.yozo.office.en:id/ll_ss_filter_asc').click()
ss.tap(x1, y1)
self.driver.find_element_by_id(
'com.yozo.office.en:id/ll_ss_filter_desc').click()
ss.tap(x1, y1)
self.driver.find_element_by_id(
'com.yozo.office.en:id/ll_ss_filter_clean').click()
self.driver.find_element_by_id(
'com.yozo.office.en:id/tv_ss_filter_complete').click()
ss.tap(x1, y1)
self.driver.find_element_by_id(
'com.yozo.office.en:id/tv_ss_filter_cancel').click()
ss.tap(x1, y1)
self.driver.find_element_by_id(
'com.yozo.office.en:id/tv_ss_filter_select_all').click()
self.driver.find_element_by_id(
'com.yozo.office.en:id/iv_ss_filter_select').click()
self.driver.find_element_by_id(
'com.yozo.office.en:id/tv_ss_filter_select_all').click()
self.driver.find_element_by_id(
'com.yozo.office.en:id/ll_ss_filter_customize').click()
self.driver.find_element_by_id(
'com.yozo.office.en:id/iv_ss_customize_back').click()
def test_insert_chart(self, file_type): # Insert 图表，仅ss，pg
logging.info('==========test_insert_chart==========')
chart_list = [
' Column Chart ', ' Bar Chart ', ' Line Chart ', ' Pie Chart ',
' Scatter Chart ', ' Area Chart ', ' Doughnut Chart ',
' Radar Chart ', ' Bubble Chart ', ' Cylind Chart ',
' Cone Chart ', ' Pyramid Chart '
]
cv = CreateView(self.driver)
cv.create_file(file_type)
gv = GeneralView(self.driver)
ss = SSView(self.driver)
time.sleep(1)
if file_type == 'ss':
x, y, width, height = ss.cell_location()
for i in range(3):
cv.tap(x + width * 0.5, y + height * (i + 0.5))
ss.cell_edit() # 双击进入编辑
self.driver.press_keycode(random.randint(7, 16))
gv.drag_coordinate(x, y + height * 2, x, y)
for i in range(3):
gv.group_button_click(' Insert ')
if file_type == 'pg' and i == 0:
ele1 = '//*[@text=" Slide "]'
ele2 = '//*[@text=" Picture "]'
gv.swipe_ele(ele2, ele1)
gv.insert_chart_insert(chart_list[i], random.randint(1, 9))
gv.chart_template()
ele1 = '//*[@text=" Chart "]'
ele2 = '//*[@text=" Chart Type "]'
gv.swipe_ele(ele2, ele1)
gv.shape_layer(' Send Backward ')
gv.shape_layer(' Send to Back ')
gv.shape_layer(' Bring Forward ')
gv.shape_layer(' Bring to Front ')
time.sleep(3)
def test_ss_data_table(self): # 数据排序，工作表格式
logging.info('==========test_ss_data_table==========')
cv = CreateView(self.driver)
cv.create_file('ss')
ss = SSView(self.driver)
ss.cell_edit()
x, y, width, height = ss.cell_location()
for i in range(8):
ss.tap(x + width * 0.5, y + height * (1.5 + i))
ss.tap(x + width * 1.5, y + height * (1.5 + i))
ss.cell_edit()
self.driver.press_keycode(random.randint(7, 16))
ss.group_button_click(' View ')
ss.data_sort(' Sort Z to A ')
ss.data_sort(' Sort A to Z ')
ss.sheet_style(' Hide formula bar ')
ss.sheet_style(' Hide formula bar ')
ele = '//android.widget.ScrollView'
ss.swipe_options(ele, 'up')
ss.sheet_style(' Hide row and column headers ')
ss.sheet_style(' Hide row and column headers ')
ss.sheet_style(' Hide gridlines ')
ss.sheet_style(' Hide gridlines ')
ss.sheet_style(' Freeze Window ')
self.driver.find_element(
By.ID,
'com.yozo.office.en:id/yozo_ui_ss_option_id_freeze_current').click(
)
self.driver.find_element(
By.ID,
'com.yozo.office.en:id/yozo_ui_ss_option_id_freeze_row').click()
self.driver.find_element(
By.ID,
'com.yozo.office.en:id/yozo_ui_ss_option_id_freeze_column').click(
)
self.driver.find_element(
By.ID, 'com.yozo.office.en:id/yozo_ui_option_back_button').click()
ss.sheet_style(' Unfreeze ')
ss.sheet_style('100%')
def test_pop_menu_cell_text(self):
logging.info('==========test_pop_menu_cell_text==========')
cv = CreateView(self.driver)
cv.create_file(self.file_type)
gv = GeneralView(self.driver)
ss = SSView(self.driver)
time.sleep(1)
x, y, width, height = ss.cell_location() # 新建默认B8
cv.tap(x + width * 0.5, y - height * 5.5) # 点击B2
ss.cell_edit() # 进入 Edit
for i in range(15):
self.driver.press_keycode(random.randint(29, 54))
# time.sleep(1)
gv.drag_coordinate(x + 200, y - height * 5.5, x + 50, y - height * 5.5)
gv.pop_menu_click('copy')
gv.tap(x + width * 0.5, y - height * 5.5)
gv.pop_menu_click('paste')
gv.drag_coordinate(x + 200, y - height * 5.5, x + 50, y - height * 5.5)
gv.pop_menu_click('cut')
gv.tap(x + width * 0.5, y - height * 5.5)
gv.pop_menu_click('paste')
gv.tap(x + width * 0.5, y - height * 5.5)
gv.pop_menu_click('newline')
self.driver.find_element(
By.ID, 'com.yozo.office.en:id/formulabar_ok').click()
gv.tap(x + width * 0.5, y - height * 5.5)
gv.pop_menu_click('fill_data')
x1, y1 = gv.find_pic_position('fill_down')
gv.drag_coordinate(x1, y1, x1, y1 + height * 2)
gv.tap(x + width * 0.5, y - height * 5.5)
time.sleep(1)
x2, y2 = gv.find_pic_position('fill_data')
gv.swipe(x2, y2, x2 - width * 2, y2)
gv.pop_menu_click('clear_content')
