Paste multiple cells not adjusting formulas event with copy flags set

[Administrator]

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?

[Administrator]

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

[Administrator]

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.

[Administrator]

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.

[Administrator]

Hi Clay,

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

Thanks.