Object: Table2DColumnTransformingContext

Download PDF

Updated2024-09-12
1 minute(s) read

The Table2DColumnTransformingContext object provides information about a column of a 2D table for the channel transformation in DIAdem REPORT.

The following example generates a 2D table with two columns, specifies the column properties, and assigns the MyOnChannelTransformation user command to the second column:

Copy script

Dim oMy2DTable, oMyColumn, oMyColumnTrans
Call Report.NewLayout()
Set oMy2DTable = Report.ActiveSheet.Objects.Add(eReportObject2DTable,"My2DTable")
oMy2DTable.Position.ByBorder.Top = 30
oMy2DTable.Position.ByBorder.Bottom = 20
oMy2DTable.Position.ByBorder.Left = 20
oMy2DTable.Position.ByBorder.Right = 30
Set oMyColumn = oMy2DTable.Columns.Add(e2DTableColumnChannel)
oMyColumn.Channel.Reference = "[1]/[2]"
oMyColumn.Settings.Alignment = eTableAlignmentDecimalPoint
oMyColumnTrans.Channel.Reference = "[1]/[2]"
oMy2DTable.Settings.UseChannelTransformation = True
oMyColumnTrans.OnChannelTransformation = "MyOnChannelTransformation"
Call Report.Refresh()

The user command summates all values in the columns and returns the results in the second column:

Copy script

Sub MyOnChannelTransformation(TransformContext)
  Dim oMyDataContext
  Set oMyDataContext = TransformContext.DataContext
  Call ChnSum(oMyDataContext.ChannelNumberIn, oMyDataContext.ChannelNumberOut) 'Calculates the sum of the single values
End Sub

Properties

Column | DataContext | Sheet | Table

DIAdem Help

Table of Contents

Object: Table2DColumnTransformingContext

Properties

See Also