End Points Section

In This Topic

The end-points section defines the start and end points of a 1D shape. It is an optional section and is represented by an instance of the NEndPointsSection class. This section is created and accessed by the EndPointsSection property:

C#	Copy Code
// create the end points section and modify the start and end points sheet.EndPointsSection = new NEndPointsSection(); sheet.EndPointsSection.StartX.Value = 130; sheet.EndPointsSection.StartY.Value = 210; sheet.EndPointsSection.EndX.Value = 170; sheet.EndPointsSection.EndY.Value = 160;

Copy Code

// create the end points section and modify the start and end points
sheet.EndPointsSection = new NEndPointsSection();
sheet.EndPointsSection.StartX.Value = 130;
sheet.EndPointsSection.StartY.Value = 210;
sheet.EndPointsSection.EndX.Value = 170;
sheet.EndPointsSection.EndY.Value = 160;

Visual Basic	Copy Code
' create the end points section and modify the start and end points sheet.EndPointsSection = New NEndPointsSection() sheet.EndPointsSection.StartX.Value = 130 sheet.EndPointsSection.StartY.Value = 210 sheet.EndPointsSection.EndX.Value = 170 sheet.EndPointsSection.EndY.Value = 160

Visual Basic

Copy Code

' create the end points section and modify the start and end points
sheet.EndPointsSection = New NEndPointsSection()
sheet.EndPointsSection.StartX.Value = 130
sheet.EndPointsSection.StartY.Value = 210
sheet.EndPointsSection.EndX.Value = 170
sheet.EndPointsSection.EndY.Value = 160

The end-points section contains the following set of named cells:

Cell Name	Cell Type	Description	Notes
StartX	Single	Controls the X coordinate of the shape start point. Accessible from the StartX property.	Usually a constant
StartY	Single	Controls the Y coordinate of the shape start point. Accessible from the StartY property.	Usually a constant
EndX	Single	Controls the X coordinate of the shape end point. Accessible from the EndX property.	Usually a constant
EndY	Single	Controls the Y coordinate of the shape end point. Accessible from the EndY property.	Usually a constant

Usually when you create a 1D shape the transform section of the sheet is also modified to represent the following:
1. The Width is the distance between the start and end points

2. The Angle is the angle between the (start point, end point) vector and the X axis.

3. The Local Pin is the middle of the local coordinate system

4. The Pin is the middle of the (start point, end point) line segment.

5. The Height is a user defined constant

The following code example illustrates a typical transform section for a 1D shape:

C#	Copy Code
sheet.TransformSection.Width.Formula = "SQRT((EndX-StartX)^2+(EndY-StartY)^2)"; sheet.TransformSection.Height.Value = 193; sheet.TransformSection.Angle.Formula = "ATAN2(EndY-StartY,EndX-StartX)"; sheet.TransformSection.PinX.Formula = "(StartX+EndX)/2"; sheet.TransformSection.PinY.Formula = "(StartY+EndY)/2"; sheet.TransformSection.LocPinX.Formula = "Width0.5"; sheet.TransformSection.LocPinY.Formula = "Height0.5";

Copy Code

sheet.TransformSection.Width.Formula = "SQRT((EndX-StartX)^2+(EndY-StartY)^2)";
sheet.TransformSection.Height.Value = 193;
sheet.TransformSection.Angle.Formula = "ATAN2(EndY-StartY,EndX-StartX)";
sheet.TransformSection.PinX.Formula = "(StartX+EndX)/2";
sheet.TransformSection.PinY.Formula = "(StartY+EndY)/2";
sheet.TransformSection.LocPinX.Formula = "Width*0.5";
sheet.TransformSection.LocPinY.Formula = "Height*0.5";

Visual Basic	Copy Code
sheet.TransformSection.Width.Formula = "SQRT((EndX-StartX)^2+(EndY-StartY)^2)" sheet.TransformSection.Height.Value = 193 sheet.TransformSection.Angle.Formula = "ATAN2(EndY-StartY,EndX-StartX)" sheet.TransformSection.PinX.Formula = "(StartX+EndX)/2" sheet.TransformSection.PinY.Formula = "(StartY+EndY)/2" sheet.TransformSection.LocPinX.Formula = "Width0.5" sheet.TransformSection.LocPinY.Formula = "Height0.5"

Visual Basic

Copy Code

sheet.TransformSection.Width.Formula = "SQRT((EndX-StartX)^2+(EndY-StartY)^2)"
sheet.TransformSection.Height.Value = 193
sheet.TransformSection.Angle.Formula = "ATAN2(EndY-StartY,EndX-StartX)"
sheet.TransformSection.PinX.Formula = "(StartX+EndX)/2"
sheet.TransformSection.PinY.Formula = "(StartY+EndY)/2"
sheet.TransformSection.LocPinX.Formula = "Width*0.5"
sheet.TransformSection.LocPinY.Formula = "Height*0.5"