DataGridXL » Docs

Column Settings

Read-only Columns

To make a column read-only, add the attribute readOnly to your column and set it to true.

{
  readOnly: true
}

By setting a column to read-only, the contents of the column can no longer be changed.

Any read-only column will have a grey background color to inform the user that the column contents cannot be edited.

By setting the column to readOnly, the following actions are prevented from changing the cell contents:

• Opening Cell Editor
• Changing cell contents by input bar (in DataGridXL bottom bar)
• Changing cell contents by paste action
• Changing cell contents by fill action

The only way values in a read-only column can be changed is by code.