如何为用户隐藏某些列? [英] How to hide certain columns for a user?

问题描述

在共享的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?

推荐答案

经过研究并尝试了各种不同的选择，我终于能够使用

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.

这篇关于如何为用户隐藏某些列?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！