I have a column where each cell has different format. How do I achieve it ?
you can handle the Grid's InitializeRow event and access each cell by its index, and use the appearance object. Your code would look similar to:
Private
e.Row.Cells(0).Appearance.BackColor = Color.Blue
Sub
By formatting I mean as follows.
Column A format is,
with column a
.format="###,###,###,##0.00"
end with
two of the cells in column Ashould have format "0.00000" and "000.000" respectively.
my question was , how do I achieve this.
There's no really simple way to do this. You have to use editors.
Luckily, I happen to have a sample of this lying around. Check out the attached sample project.