Property: Bottom for ObjectPositionDefinedByBorders

DIAdem 2018 Help

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

DOWNLOAD (Windows Only)

---

	DIAdem 2017 Help
	DIAdem 2018 Help
	DIAdem 2019 Help
	DIAdem 2020 Help
	DIAdem 2020 SP1 Help

Specifies in DIAdem REPORT the distance from the bottom edge of an object to the bottom edge of the worksheet as a percentage of the page area, in cm, or in inch, if you use margins to position the object. Because you can use either the Bottom, Height, Left, Right, Top, and Width for the ObjectPositionDefinedByBorders property, or the Height, Width, X1, X2, Y1, and Y2 for the ObjectPositionDefinedByCoordinates property to specify the position, these properties impact each other and the value of the property set first can be modified by another property.

Object.Bottom

The following example generates a formula graphic, specifies the distances between the border of the formula graphic and the edges of the worksheet, and generates a frame which the example positions using the distances to the bottom left corner and the height and width:

Dim oMyFormula, oMyPosFormula, oMyFrame, oMyPosFrame
Call Report.NewLayout()
Set oMyFormula = Report.ActiveSheet.Objects.Add(eReportObjectFormulaDisplay ,"MyFormular")
Set oMyPosFormula = oMyFormula.Position.ByBorder
oMyFormula.Text = "a^2+b^2=c^2"
oMyPosFormula.Left = 10
oMyPosFormula.Right = 70
oMyPosFormula.Bottom = 10
oMyPosFormula.Top = 75
Set oMyFrame = Report.ActiveSheet.Objects.Add(eReportObjectFrame,"MyFrame")
Set oMyPosFrame = oMyFrame.Position.ByBorder
oMyPosFrame.Left = 40
oMyPosFrame.Width = 20
oMyPosFrame.Bottom = 10
oMyPosFrame.Height = 15
Call Report.Refresh()