View Single Post
Just a thought, but it would be nice to be able to 'lock' portions or settings of a document. This would include columns, rows, sections and other document level attributes.

For example, the ability to 'lock' columns to prevent editing. This would provide a way to prevent changes to certain columns in a document (say, text or date columns), yet allow for other columns (such as checkboxes) to be changed or updated.

Any column or column type could be locked. This would be controlled from the Column Inspector.
Locking a column would:
* Prevent any changes to the column
* Prevent column level Style changes

Any row could be locked. This would be controlled from the Row Inspector.
Locking a row would:
* Prevent any changes to the row, including notes
* Prevent any changes to the row's children
* Prevent row level Style changes

Any section or subsection could be locked. This would be controlled from a new Section Inspector.
Locking a section or subsection would:
* Prevent any changes to the section, including reordering
* Prevent section level Style changes

Also, from the Document Inspector:
* The option to lock the row 'Status Checkboxes'
* The option to lock all 'Notes'
* The option to use the Status Checkbox to lock a row
* The option to lock the entire document. This would the would prevent content changes, reordering, adding columns or rows, and Style changes.

This would need to be implemented in a hierarchal fashion, where document level locks override section level locks, which override column level locks, which would override row level locks.

Though this is rough, it would allow for flexibility during collaboration without exposing certain items or data to unwanted changes.

Any thoughts?