We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. Image for the cookie policy date

Excel - enter cell always shows formula

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

5 Replies

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

Loader.
Live Chat Icon For mobile
Up arrow icon