wps AI帮你写代码，错误 WOApiTypeError:Cannot read properties of undefined (reading 'bind') at prova1.js:1:19

阅读次数 45
airscript

wps智能表【AI 帮你写代码】，我测试条件更改字母颜色： 指令为：列“盈利”如果数字大于0，字母为红色，如果数字低于0，字母为绿色。

let targetRange = Range("$G$2:$G$14")
let dataMap = {}
dataMap.type = xlExpression
dataMap.formula1 = '=G2>0'
targetRange.Select()
let fc = targetRange.FormatConditions.Add(dataMap.type, dataMap.operator, dataMap.formula1, dataMap.formula2, dataMap.text, dataMap.textOperator, dataMap.dateOperator, undefined)
fc.SetFirstPriority()
fc.Font.Color = RGB(255, 0, 0) 
fc.Font.Strikethrough = false 

let targetRange1 = Range("$G$2:$G$14")
let dataMap1 = {}
dataMap1.type = xlExpression
dataMap1.formula1 = '=G2<0'
targetRange1.Select()
let fc1 = targetRange1.FormatConditions.Add(dataMap1.type, dataMap1.operator, dataMap1.formula1, dataMap1.formula2, dataMap1.text, dataMap1.textOperator, dataMap1.dateOperator, undefined)
fc1.SetFirstPriority()
fc1.Font.Color = RGB(0, 255, 0) 
fc1.Font.Strikethrough = false

显示错误为：错误 WOApiTypeError:Cannot read properties of undefined (reading 'bind') at prova1.js:1:19

简单指令都出错。。

Ale1
0 Answers