In the Formula Excel samples when you move the move into a cell, it always shows the formula. When i try this in Excel the top formula panel shows the formula but the cell shows the value.
I have to double click in the cell or click in the formula bar for the formula to show up in the cell (as opposed to the value). Can syncfusion recreate this behavior ??
thks,
ak
AD
Administrator
Syncfusion Team
November 22, 2005 12:10 AM UTC
Try setting these properties.
this.gridControl1.ActivateCurrentCellBehavior = GridCellActivateAction.DblClickOnCell;
GridFormulaCellRenderer.ForceEditWhenActivated = false;
AK
Adam K.
November 22, 2005 12:26 AM UTC
where are these settings. do i need to add an additional reference. the compiler doesn''t find
either of these
GridCellActivateAction
GridFormulaCellRenderer
thks,
ak
>Try setting these properties.
>
>this.gridControl1.ActivateCurrentCellBehavior = GridCellActivateAction.DblClickOnCell;
>GridFormulaCellRenderer.ForceEditWhenActivated = false;
>
AK
Adam K.
November 22, 2005 12:29 AM UTC
forget my stupidity .. somehow i lost the reference in my project.
thks
ak
>where are these settings. do i need to add an additional reference. the compiler doesn''t find
>either of these
>
>GridCellActivateAction
>GridFormulaCellRenderer
>
>thks,
>ak
>
>>Try setting these properties.
>>
>>this.gridControl1.ActivateCurrentCellBehavior = GridCellActivateAction.DblClickOnCell;
>>GridFormulaCellRenderer.ForceEditWhenActivated = false;
>>
AK
Adam K.
November 22, 2005 01:10 AM UTC
I added these 2 lines into the GridDataboundgrid example . . it works in the sense that it doesn''t show the formula, but now i have a bigger problem . . . i can''t commit any cells . i hit enter and it stays in edit mode for the cell . .
>forget my stupidity .. somehow i lost the reference in my project.
>
>thks
>ak
>
>>where are these settings. do i need to add an additional reference. the compiler doesn''t find
>>either of these
>>
>>GridCellActivateAction
>>GridFormulaCellRenderer
>>
>>thks,
>>ak
>>
>>>Try setting these properties.
>>>
>>>this.gridControl1.ActivateCurrentCellBehavior = GridCellActivateAction.DblClickOnCell;
>>>GridFormulaCellRenderer.ForceEditWhenActivated = false;
>>>
AD
Administrator
Syncfusion Team
November 22, 2005 08:02 AM UTC
You have to do additional, non-trivial, work to use formula cells in a GridDataBoundGrid. You must somehow maintain a collection of FormulaTag objects. Here is a KB link discussing this process. http://www.syncfusion.com/support/kb/grid/Default.aspx?ToDo=view&questId=104