问题描述
在共享的Google电子表格中:
我不希望我的域中的特定用户查看包含敏感数据的列,但这个人应该仍然可以编辑电子表格的其余部分。
我试着创建一个'主'电子表格并使用导入范围将数据导入'共享'表格,但是一旦我编辑共享电子表格中的任何单元格,如果工作表已被清空,则工作时间会更长。
是否有快速的方法来执行此操作,也许使用脚本?
起初,我尝试使用隐藏栏&保护范围,但这是行不通的,因为简单的复制&粘贴会显示隐藏列的内容。解决方案:'主'电子表格没有任何敏感的列数据,可以与组织中的每个人共享。[/ b] 。然后,我将将敏感数据添加到新电子表格中,并使用导入范围从主中抓取内容。 (以前我的角色相反,但这不起作用)
您可能希望每行添加唯一的键因此当您压缩敏感数据和主数据时,排序等操作不会造成混乱。
On a shared Google spreadsheet:
I don't want a specific user in my domain to view columns with sensitive data, but this person should still be able to edit the rest of the spreadsheet.
I tried creating a 'master' spreadsheet and using importrange to bring the data into a 'shared' sheet, but once I edit any cell in the shared spreadsheet, importrange no longer works as the sheet is emptied out.
Is there a quick way to do this, maybe using scripting?
After some research and trying various different options, I was finally able to achieve what I want using the importrange function.
At first, I tried using a combination of hide columns & protect range, but this wouldn't work because a simple copy & paste would reveal the contents of the hidden columns.
Solution: The 'master' spreadsheet does not have any sensitive column data and can be shared with everyone in the organization... I then ADD the sensitive data to a new spreadsheet and use importrange to grab contents from the 'master'. (Previously I had the roles reversed, but this didn't work)
You may want to add unique keys per row entry so that sorting etc won't mess things up when you zip-up the sensitive data and the 'master' data.
这篇关于如何隐藏用户的某些列? (Google Spreadsheet)的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!