| Cost Sheet Column | Worksheet | |||||
|---|---|---|---|---|---|---|---|
Case | Can view/edit column data | Can view column data | Owner | Edit permission | View permission | Access in view mode | Access in edit mode |
1 | Yes | Yes | Yes | Yes | Yes | n/a | Yes |
2 | Yes | Yes | No | Yes | Yes | n/a | Yes |
3 | Yes | Yes | No | No | Yes | Yes | No |
4 | Yes | Yes | No | No | No | No | No |
5 | No | Yes | Yes | Yes | Yes | n/a | Yes |
6 | No | Yes | No | Yes | Yes | n/a | Yes |
7 | No | Yes | No | No | Yes | Yes | No |
8 | No | Yes | No | No | No | No | No |
9 | No | No | Yes | Yes | Yes | No | No |
In cases 4 and 8, the user will see an error message that they cannot view the worksheet as they do not have view permissions for the worksheet. In case 9, they will not see any message, as they cannot see the column with worksheet as the data entry method.