如何隐藏用户的某些列？ （Google Spreadsheet） [英] How to hide certain columns for a user? (Google Spreadsheet)
问题描述
在共享的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）的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
