Users can enter a formula in a cell by starting with an equals sign (=). Type the equal sign and then the formula such as 单元格中以“=”开头的字符串将会被视为公式,比如 “=sum(A1+B1). You can allow or prevent the user from entering formulas with the options.allowUserEditFormula property.
Using Code
This example sets the options.allowUserEditFormula property.”。
你可以使用 options.allowUserEditFormula 来设置用户能否使用公式。
示例代码
以下代码使用了 options.allowUserEditFormula 属性。
JavaScript | Copy Code |
spread.options.allowUserEditFormula = true; |
|
See Also另见
Workbook Method