我可以在没有Google Apps脚本的情况下在Google电子表格上执行自定义功能吗? [英] Can I make custom function on google spreadsheet without Google Apps Script?

问题描述

我正在将Google电子表格与Google Apps脚本一起使用.

I'm using google spreadsheet with Google Apps Script.

但是它很容易给我错误信息.像这样

but it gives me error message too easily. like this

错误
每秒对此Google用户帐户调用脚本的次数过多. (第0行).

Error
Script invoked too many times per second for this Google user account. (line 0).

有什么办法可以避免该错误? (除了减少函数调用的方式) 或支持Javascript函数定义的替代电子表格程序?

Is there any way to avoid the error? (except the way reduce function call) or alternative Spreadsheet program that support Javascript function define?

推荐答案

如关于优化的部分页面.

As noted in the documentation you can work around this by ensuring that your function supports ranges, and the function on a range. See also the section on Optimization on the Custom Functions in Google Sheets page.

这篇关于我可以在没有Google Apps脚本的情况下在Google电子表格上执行自定义功能吗?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！