Replied 8 September 2017, 3:17 pm EST
Reeva, Thanks for the reply.
Let me explain our situation in a little more detail.
We have a grid bound to a bindingsource linked to a typed datatable.
The grid is only for display purposes and NOT for data entry.
We really want the grid to be read-only (though scrollable).
In my previous example, we want to force a date of 1/1/1900 to display as a string = "XXXX".
However, we found no way to do that and you suggested we use the Paint event.
We tried that and it throws an exception when we try and set the date column to a text value.
Also, we really would NOT want to use the Paint event anyway. It's pretty gross to loop through the rows and columns every time the grid is re-displayed/re-painted.
We got around the immediate issue by hiding the original column, adding an unbound column and then populating the unbound column with our "final" display value.
Unfortunately, in some of our "read-only" grids we not only change column values but we do so in spanned cells and that fails miserably.
I'm hoping someone has some method to allow this kind of flexibility; we had it in Spread 6 for heaven's sake.
Help Mr/Ms Wizard!