Google Spreadsheet:任何人都可以编辑，但无法保存更改 [英] Google Spreadsheet: Anyone can edit but not able to save the changes

问题描述

我想以操场模式在网页上发布Google Spreadsheet，这将使访问者可以编辑内容，更改公式等.但是所有这些更改必须保留在本地且不能保存在原始Google Spreadsheet中./p>

是否可以发布和嵌入这样的Google Spreadsheet，例如为最终用户禁用保存"功能，即无法自动保存更改并且也不能手动保存?

任何解决方案都可以做到这一点，即使它涉及Google Apps脚本！请指教.谢谢.

解决方案

在允许人们进行编辑的同时保持主电子表格完整性的一种简便方法是在单击链接时强制复制.

您的电子表格至少需要在共享设置中查看权限.然后，获取URL:

https://docs.google.com/spreadsheets/d/SOME_BIG_LONG_KEY/view

将结尾处的视图"更改为复制":

https://docs.google.com/spreadsheets/d/SOME_BIG_LONG_KEY/copy

系统将要求用户登录并将副本保存到其云端硬盘.您的母版保持不变，每个人都拥有工作表的工作副本，并且您不需要大型脚本来管理更改.

话虽这么说，但如果您对原版进行更改，由于它们是新文档，因此不会反映在副本中.

I would like to publish a Google Spreadsheet on a webpage in playground mode which would enable the visitors to edit the content, change the formulas etc. but all those changes must remain local and not be saved in the original Google Spreadsheet.

Is it possible to publish and embed such a Google Spreadsheet like disabling the 'Save' functionality for end-users i.e. unable to auto-save on changes and can't save manually too?

Any solution will do that even if it involves Google Apps Script! Please advise. Thanks.

解决方案

An easy method to maintain the integrity of a master spreadsheet while allowing people to edit is to just force a copy when they click the link.

Your spreadsheet needs, at minimum, view rights in the sharing settings. Then, grab the URL:

https://docs.google.com/spreadsheets/d/SOME_BIG_LONG_KEY/view

Change "view" at the end to "copy":

https://docs.google.com/spreadsheets/d/SOME_BIG_LONG_KEY/copy

The user will be asked to sign in and save a copy to their Drive. Your master remain untouched, everyone has a working copy of the sheet, and you don't need a big script to manage changes.

That being said, if you make changes to the master, they aren't reflected in the copy because it's a new document.

这篇关于Google Spreadsheet:任何人都可以编辑，但无法保存更改的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！