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_formula1(self): # 其他类型公式
logging.info('==========test_formula1==========')
cv = CreateView(self.driver)
cv.create_file('ss')
time.sleep(1)
for i in range(10):
cv.tap(110 + 263 * 1.5, 295 + 55 * (1.5 + i)) # 双击进入编辑
cv.tap(110 + 263 * 1.5, 295 + 55 * (1.5 + i))
self.driver.press_keycode(random.randint(7, 16))
ss = SSView(self.driver)
cv.tap(110 + 263 * 2.5, 295 + 55 * 0.5)
ss.formula_all('最近使用', 'MAX')
cv.tap(110 + 263 * 1.5, 295 + 55 * 1.5)
self.driver.find_element(By.ID, 'com.yozo.office:id/formulabar_ok').click()
cv.tap(110 + 263 * 2.5, 295 + 55 * 1.5)
ss.formula_all('数学和三角', 'ABS')
cv.tap(110 + 263 * 1.5, 295 + 55 * 1.5)
self.driver.find_element(By.ID, 'com.yozo.office:id/formulabar_ok').click()
cv.tap(110 + 263 * 2.5, 295 + 55 * 2.5)
ss.formula_all('财务', 'DOLLARDE')
cv.tap(110 + 263 * 1.5, 295 + 55 * 1.5)
time.sleep(0.5)
cv.tap(110 + 263 * 1.5, 295 + 55 * 5.5)
self.driver.find_element(By.ID, 'com.yozo.office:id/formulabar_ok').click()
cv.tap(110 + 263 * 2.5, 295 + 55 * 3.5)
ss.formula_all('逻辑', 'AND')
cv.tap(110 + 263 * 1.5, 295 + 55 * 1.5)
time.sleep(0.5)
cv.tap(110 + 263 * 1.5, 295 + 55 * 5.5)
self.driver.find_element(By.ID, 'com.yozo.office:id/formulabar_ok').click()
cv.tap(110 + 263 * 2.5, 295 + 55 * 4.5)
ss.formula_all('文本', 'ASC')
cv.tap(110 + 263 * 1.5, 295 + 55 * 1.5)
self.driver.find_element(By.ID, 'com.yozo.office:id/formulabar_ok').click()
cv.tap(110 + 263 * 2.5, 295 + 55 * 5.5)
ss.formula_all('日期和时间', 'NOW')
self.driver.find_element(By.ID, 'com.yozo.office:id/formulabar_ok').click()
cv.tap(110 + 263 * 2.5, 295 + 55 * 6.5)
ss.formula_all('查找与引用', 'COLUMN')
cv.tap(110 + 263 * 1.5, 295 + 55 * 1.5)
self.driver.find_element(By.ID, 'com.yozo.office:id/formulabar_ok').click()
cv.tap(110 + 263 * 2.5, 295 + 55 * 7.5)
ss.formula_all('统计', 'AVERAGE')
cv.tap(110 + 263 * 1.5, 295 + 55 * 1.5)
self.driver.find_element(By.ID, 'com.yozo.office:id/formulabar_ok').click()
# cv.tap(110 + 263 * 2.5, 295 + 55 * 8.5)
# ss.formula_all('工程', 'DEC2BIN')
# cv.tap(110 + 263 * 1.5, 295 + 55 * 1.5)
# self.driver.find_element(By.ID, 'com.yozo.office:id/formulabar_ok').click()
cv.tap(110 + 263 * 2.5, 295 + 55 * 9.5)
ss.formula_all('信息', 'ISBLANK')
cv.tap(110 + 263 * 1.5, 295 + 55 * 1.5)
self.driver.find_element(By.ID, 'com.yozo.office:id/formulabar_ok').click()
cv.tap(110 + 263 * 2.5, 295 + 55 * 10.5)
ss.formula_all('所有公式', 'ABS')
cv.tap(110 + 263 * 1.5, 295 + 55 * 1.5)
self.driver.find_element(By.ID, 'com.yozo.office:id/formulabar_ok').click()
