禁止编辑者下载文件 [英] Prevent editors from downloading the file

问题描述

我目前正在使用Google表格.

I am currently working on a google sheet.

有两个选项卡，一个是主表，另一个是表，允许用户输入产品名称，然后将显示销售价格.但是，我不希望用户看到母版纸.即使我隐藏了主工作表，但如果用户下载工作表，也可以取消隐藏它.

There are two tabs, one is a master sheet and the other one is a table that allow the user to input the product name and the sales price will show up. However, I don't want the user to see the master sheet. Even though I hide the master sheet, the user is able to unhide it if they download the sheet. Is it possible to

1. 禁用编辑器的下载选项?

或

1. 引用主列表而不将其包含在同一文件中吗?

OR

1. 即使用户下载文件也隐藏主列表吗?

推荐答案

AFAIK，无法禁用对文件打印的编辑​​器访问权限(使用

AFAIK, the editor access to print the file cannot be disable (tried and tested using this guide). I would suggest creating a file (master) and a dependent file which users can download. You can also create a script that will copy the content of the master file to the dependent file. Then only limit the master file access to yourself.

下面是一个代码片段，它将主文件复制到您的公共文件中:

Here is a code snippet that will copy the master file to your public file:

var source = SpreadsheetApp.getActiveSpreadsheet();

 var sheet = source.getSheets()[0];

 var destination = SpreadsheetApp.openById("ID_GOES HERE");

 sheet.copyTo(destination);

希望这会有所帮助.

这篇关于禁止编辑者下载文件的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！