Sheets and cells protection
If the sheets and cells in uploaded Excel or .ods files are protected, they are continued to be protected in HCL Connections™ Docs.
If the sheets and cells in the file you upload are protected,
you cannot do the following operations:
- Editing the cells
- Changing the format
- Editing the images or charts
- Inserting or deleting rows and columns
- Pasting objects to target ranges that have protected cells
If the sheets and cells in the file you upload are protected,
you still can perform the following operations:
- Inserting a sheet into the file
- Adding comments on the file
- Creating, editing or deleting named ranges
Note:
- If the cells are locked in the uploaded file, you cannot edit it. When you navigate with tab key, it only navigates between unlocked cells, and the locked cells are ignored.
- If the cell has hidden style in a protected sheet, you cannot see its edit value but can copy its calculated value. However, if the cell is unlocked, then you can edit it.