Object: 2DTableDropContext

Object: 2DTableDropContext

The 2DTableDropContext object provides information about the 2D axis system onto which you dragged and dropped an object. Do not set the DoProceed property to TRUE if you change the number of columns in the associated event or if you execute similar operations.

Note  To test the example script, you must first save the script and register the script as a user command in the dialog box that opens when you select Settings»Extensions»User Commands.

The following example executes the user command MyOnDrop2DTableEvent when channels are dragged and dropped into a 3D table. The user command displays the names of the channels that you dragged onto an object. The user command also displays information about the objects you dragged into the channels. The user command receives two parameters. The first parameter corresponds to a 2DTableDropContext object and provides information about the 2D table onto which you dragged and dropped an object. The second parameter corresponds to a DropInformation object and provides information about the object which you dragged and dropped onto another object:

Call AddUserCommandToEvent("Report.Events.OnDrop2DTable", "MyOnDrop2DTableEvent")

Sub MyOnDrop2DTableEvent(Context, DropContext)
  Dim oMyDropElement, sOutput, oMyTable
  sOutput = "Names of dropped channels:"
  For Each oMyDropElement in DropContext.DiademElements
    sOutput = sOutput & VBCrLf & oMyDropElement.Name
  Next
  Call Msgbox(sOutput)
  Set oMyTable = Context.Table
  If Context.ColumnIndex>0 Then
    Call MsgBox(Context.Sheet.Name & VBCrLf & oMyTable.Name & VBCrLf & oMyTable.Columns.Item(Context.ColumnIndex).Type)
  Else  
    Call MsgBox(Context.Sheet.Name & VBCrLf & oMyTable.Name)
  End If  
  Context.DoProceed = TRUE
End Sub