Object: 2DTableIndexSettings

DIAdem 2018 Help


Edition Date: June 2018
Part Number: 370858P-01
View Product Info

DOWNLOAD (Windows Only)


DIAdem 2015 Help
DIAdem 2017 Help
DIAdem 2018 Help
DIAdem 2019 Help
DIAdem 2020 Help

The 2DTableIndexSettings object provides the scaling properties of a 2D table in DIAdem REPORT.

The following example generates a table with two columns and specifies the start value, the step width, and the end value of the scale:

Dim oMy2DTable, oMyPosition, oMySettings, oMyColumn1, oMyColumn2, oMyIndexSettings
Call Report.NewLayout()
Set oMy2DTable = Report.ActiveSheet.Objects.Add(eReportObject2DTable,"My2DTable")
Set oMyPosition = oMy2DTable.Position.ByBorder
oMyPosition.Top = 30
oMyPosition.Bottom = 20
oMyPosition.Left = 20
oMyPosition.Right = 30
Set oMySettings = oMy2DTable.Settings
oMySettings.Header.Height = 20
Call oMySettings.BackgroundColor.SetPredefinedColor(eColorIndexGrey )
Set oMyColumn1 = oMy2DTable.Columns.Add(e2DTableColumnChannel)
oMyColumn1.Channel.Reference = "[1]/[1]"
Set oMyColumn2 = oMy2DTable.Columns.Add(e2DTableColumnChannel)
oMyColumn2.Channel.Reference = "[1]/[2]"
Set oMyIndexSettings = oMy2DTable.Settings.IndexSettings
oMyIndexSettings.IndexMode = e2DTableIndexModeFixed
oMyIndexSettings.IndexBegin = 1
oMyIndexSettings.IndexEnd = 1024
oMyIndexSettings.IndexIncrement = 100
Call Report.Refresh()

WAS THIS ARTICLE HELPFUL?

Not Helpful