Skip to Main Content
HCL Connections Ideas Portal

Welcome to the HCL Connections Product Ideas Lab! The place where you can submit product ideas and enhancement request. We encourage you to participate by voting on, commenting on, and creating new ideas. All new ideas will be evaluated by the HCL Product Management & Engineering teams, and the next steps will be communicated. While not all submitted ideas will be executed upon, community feedback will play a key role in influencing which ideas are and when they will be implemented.

For more information and upcoming events, please visit our HCL Connections page.

Status Under Consideration
Created by Guest
Created on Aug 30, 2018

Docs: Hope to create Protected Area if some cells are already in other Protected Area

Problem:

Can not create Protected Area if some cells are already in other Protected Area

 

Steps to reproduce:
1. user1 create a new excel file in Docs, share to user2 and user3 as Editors.
2. user1 select the whole 2nd line of the file, assign "Editable" right to user2 for the Protection Area.
3. user1 select the whole F column of the file, assign "Read only" right to "Everyone except me" for the Protection Area, but failed with a window:
--Title: "Your changes cannot be saved."
--Content: "The changes you made were in a range that is protected."

Cause:
The F2 cell is already in the 1st Protection Area, so it can not be in the 2nd Protection Area.

Expectation:
Prompt a window: F2 is already in other Protection Area. Override? If select Yes, then override the 1st Protection Area for F2 cell. If select No, then does not override the 1st Protection Area for F2 cell.

Scenario for this enhancement request:
F column is summary column which is a computing formula, not allowed to modify, so set it to read only.
There maybe several summary columns in one line, and they are not at the last columns.
Each user can only modify one line that he owns, but he can not modify the summary columns in the line.
So the problem is, when user set the summary columns to read only, he can not set Protection Area to each line.

  • Attach files