![]() | 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
Object | ObjectPositionDefinedByBorders Object with this property |
Object.Bottom | Double with read and write access |
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()
Helpful
Not Helpful