Readonly Cell (Static)

[Satish]

Clay,
I have 4 columns, out of 4 columns 1 column is ''Static'' cell. When we use Find & Replace, the value in the ''Static'' cell also getting changed, which basically I dont want to change.
How to achieve this?
Thanks
Satish

[Administrator]

In addition to setting style.CellType = "Static" for the column, have you tried also setting style.ReadOnly = true for that column to see if this will prevent the replace.

[Satish]

Clay,
Thanks it worked.
Another Question.

I have 3 Columns

Example

RowNumber A B C(C=A+B)
1 10 10 20
2 30 10 40
3 20 10 30

Is there any way, i need to see the output value of C without writing any code.

Note : User can change the value in A & B.
But output should be varied based on A & B Value.

Thanks
Satish

>In addition to setting style.CellType = "Static" for the column, have you tried also setting style.ReadOnly = true for that column to see if this will prevent the replace.

[Administrator]

If this is a GridDataBoundGrid, you can add a new DataColumn to the DataTable and set its Expression property to compute [A] + [B]. Then you would use this column as column C.

If this is a GridControl, you could set the style.CellType for column 3 to be "FormulaCell". Then you could loop from row = 1 to grid.RowCound setting

grid[row, 3].Text = string.Format("= A{0} + B{0}", row);

[Satish]

How to prevent user to rightclick on the static cell column and focus should not be set for the static cell.
Thanks
Satish

>If this is a GridDataBoundGrid, you can add a new DataColumn to the DataTable and set its Expression property to compute [A] + [B]. Then you would use this column as column C.
>
>If this is a GridControl, you could set the style.CellType for column 3 to be "FormulaCell". Then you could loop from row = 1 to grid.RowCound setting
>

>grid[row, 3].Text = string.Format("= A{0} + B{0}", row);
>

[Administrator]

You can try setting style.Enabled = false on that cell to see if that does what you want.

[Satish]

No Luck. Same problem. At any cost user should not able to select that particular column (Static Cell)
I tried putting readonly, enabled..
Thanks
Satish

>You can try setting style.Enabled = false on that cell to see if that does what you want.

[Administrator]

Static + Enabled=false seems to work in this sample. You cannot click the colored column or move the currentcell into the column. DisableCol2_6844.zip

[Satish]

Thanks. But even I should not select the row also. Nothing needs to be selected in that column. Thanks Satish >Static + Enabled=false seems to work in this sample. You cannot click the colored column or move the currentcell into the column. >DisableCol2_6844.zip > >

[Administrator]

If you do not want certain cells selected when you select a range of cells, then you can handle grid.Model.SelectionChanging and cancel the selection when the range intersects the cells you do not want selected. (This is different than wanting a cell not to become current or get input focus.)

private void Model_SelectionChanging(object sender, GridSelectionChangingEventArgs e)
{
	if(e.Range.IntersectsWith(GridRangeInfo.Col(2)))
		e.Cancel = true;
}

[Satish]

Clay,

If i use the SelectionChanging event, I am not able to select the multiple row. So how to select multiple row.

Note : Row will contain read (Static) only cells.

Thanks
Satish

>If you do not want certain cells selected when you select a range of cells, then you can handle grid.Model.SelectionChanging and cancel the selection when the range intersects the cells you do not want selected. (This is different than wanting a cell not to become current or get input focus.)
>
>

>private void Model_SelectionChanging(object sender, GridSelectionChangingEventArgs e)
>{
>	if(e.Range.IntersectsWith(GridRangeInfo.Col(2)))
>		e.Cancel = true;
>}
>

>
>

[Administrator]

I am confused. The reason for using the SelectionsChanging event was to avoid selecting something in column 2. I do not know how you will be able to select a row (or several rows), and still not select anything in column 2. Selecting a row, selects the cell in column 2.

Is it that you want to select everything in the row except column 2? If so, then remove the SelectionChanging event, and use the technique in this forum thread to color the selection. But in your PrepareViewStyleInfo, in addition to the check that the cell is in the Selections, also check that the cell is not in column 2.

http://www.syncfusion.com/Support/Forums/message.aspx?MessageID=13587