Well I have a SS where I want certain cells read only based on business logic.
For instance, if I have a specific record, maybe a cell is read only for another record it is editable.
Thus, I can’t set the readonly on the entire column but I want to put it on a specific cell.
I don’t want to use enable property which is available on individual cells (I prefer to use the readonly rather than disable property for edit controls because I find the readonly property to be superior => for instance a read only cell might
be a calculated value and you might want to copy the value to another application, an disabled cell is not copiable).
Additional logic might be the cell is editable and then when other data on the row changes, it becomes enabled.
For instance, lets say the columns are:
Items – combo box
Weight – edit control
Volume – edit control
If item is say water, volume is editable and weight is read only
If item is say oranges, volume is read only and weight is editable
I don’t know why the read only flag is read only so I can’t set the value on individual cells based on business logic.