电子表格中自定义函数的权限 [英] Permissions for custom functions in Spreadsheets

问题描述

我在Google表格中使用了SpreadSheet的新功能：
命名和保护范围。在这个受保护的单元格范围内，我使用算术内置函数和我自己的书面函数。
运行我的函数的触发器位于编辑电子表格中。

具有写入权限的用户共享电子表格的链接，无法正常运行我的函数内置函数运行正常。

我可以自己授予我的函数的权限，以作为Google Sheets内置函数运行。

解决方案

内置函数（Google Spreadsheet函数）与您的触发函数无关（由您制作）。你用两个没有共同点的东西使解释变得复杂。当然谷歌功能也可以使用！

请解释一下你的功能，它们是由什么引发的？ onEdit，onOpen，一个菜单？什么样的保护范围与它有关？如果您取消了对范围的保护，您的功能是否有效？

简单事件处理程序（如onEdit）的设计权限有限，您可能需要在编辑触发器上设置可安装的。请查看我给出的其他答案。

I am using a new feature of SpreadSheet in Google Sheets: "Named and protected ranges". In this range of protected cells, I use arithmetic built-in functions and my own written functions. The trigger to run my functions is on edit spreadsheet.

Users with write permissions, sharing the link of the spreadsheet, can't properly run my functions for permissions problem while built-in functions run properly.

Own can I grant permissions for my functions to run as Google Sheets built-in functions.

解决方案

Built-in functions (Google Spreadsheet functions) have nothing to do with your triggered functions (made by you). You're complicating the explanation with 2 things that have nothing in common. Of course Google functions will work!

Please explain better your functions, are they triggered by what? onEdit, onOpen, a menu? What protected ranges have to do with it? Does your functions work if you remove the protection of your ranges?

[edit]

Simple event handlers (like onEdit) have limited permissions by design, you probably need to set a installable on edit trigger. Please check out this other answer I gave.

这篇关于电子表格中自定义函数的权限的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！