Paste multiple cells not adjusting formulas event with copy flags set

Hi, Type a formula into a cell. Select the single cell and do a copy. Paste into another cell and the formula is adjusted. Type two formulas in adjacent cells. Select the two cells and copy them. Now do a paste into some blank cells. The first pasted cell formula is adjusted but not the second. Here are my copy flags: engine.FormulaCopyFlags = GridFormulaCopyFlags.ClipBoardReferencesAdjusted Or GridFormulaCopyFlags.InsDelRangeReferencesUpdated Or GridFormulaCopyFlags.ClipBoardFormula I''m using v4.102.0.50 Any suggestions?

Try handling the ClipboardPaste event and call CurrentCell.EndEdit there to see if this takes care of this issue. Private Sub GridControl1_ClipboardPaste(ByVal sender As Object, ByVal e As Syncfusion.Windows.Forms.Grid.GridCutPasteEventArgs) Handles GridControl1.ClipboardPaste Dim cc As GridCurrentCell = Me.gridControl1.CurrentCell If Not (cc Is Nothing) AndAlso cc.IsEditing Then cc.EndEdit() End If End Sub

Hi Clay, I have cell activation set to double click so the current cell is never editing when I do a paste. Just to be sure, I set cell activation to ClickOnCell and put in your suggestion. The issue is still there. Thanks.

This is a defect. We have corrected it here in our library code, so this correction will be in the next point release (~mid July). I do not really see a good way to work around this issue using the current library. If you need a fix before then, you can create a Direct Trac support incident and we will work with you to get an intermediate build to you.

Hi Clay, Thanks for your quick replies. I will evaluate my options and get back to you guys. Thanks.