英文:
Validate an integer input value in SpreadSheet with GAS
问题
我想使用GAS在SpreadSheet中验证整数输入值。
然而，SpreadSheet验证器不太强大，没有正则表达式。
有更好的方法吗？
https://developers.google.com/apps-script/reference/spreadsheet?#datavalidationbuilder
英文:
I want to validate an integer input value in SpreadSheet with GAS.
However, the SpreadSheet validator is not very powerful, with no regular expressions.
Is there any better way to do this?
https://developers.google.com/apps-script/reference/spreadsheet?#datavalidationbuilder
答案1
得分: 1
没有 GAS 脚本。只需为一个单元格创建自定义公式，比如 A1，然后在数据验证侧边栏中扩展范围，如下所示。我扩展到 A1:A10。
英文:
There is no GAS script. You simply create the custom formula for one cell say A1 and then expand the range in the Data Validation sidebar as shown below. I expanded to A1:A10.
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库，让每个人都能够通过互相帮助和分享经验来进步。
评论