在共享的Google电子表格上:
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.
我尝试创建一个主"电子表格,并使用importrange将数据带到共享"工作表中,但是一旦我编辑了共享电子表格中的任何单元格,由于该工作表被清空,因此importrange不再起作用.
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?
推荐答案经过研究并尝试了各种不同的选择,我终于能够使用 importrange 函数.
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.
解决方案:主"电子表格没有任何敏感的列数据,并且可以与组织中的每个人共享...然后,我 ADD 将敏感数据添加到新的电子表格中,并使用importrange从主"那里获取内容. (以前我把角色调换了,但这没用)
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.
更多推荐
如何为用户隐藏某些列?
发布评论