Syntax
| Visual Basic (Declaration) | |
|---|---|
Public Function New( _ ByVal left As Integer, _ ByVal top As Integer, _ ByVal right As Integer, _ ByVal bottom As Integer _ ) | |
| Visual Basic (Usage) |  Copy Code |
|---|---|
Dim left As Integer Dim top As Integer Dim right As Integer Dim bottom As Integer Dim instance As New Inset(left, top, right, bottom) | |
Parameters
- left
- Left inset (margin)
- top
- Top inset (margin)
- right
- Right inset (margin)
- bottom
- Bottom inset (margin)
Remarks
This method initializes an instance of the Inset class with the specified values of insets (margins).
Example
This example creates three alternating rows, adjusts the height of the rows and sets up an Inset, which allows the text in the cell to be indented to the specified margin.
| C# | Copy Code |
|---|---|
FarPoint.Web.Spread.Inset inset=new FarPoint.Web.Spread.Inset(35,5,5,35); FpSpread1.Sheets[0].AlternatingRows.Count=3; FpSpread1.Sheets[0].Rows[0].Height=80; FpSpread1.Sheets[0].Rows[1].Height=80; FpSpread1.Sheets[0].Rows[2].Height=80; FpSpread1.Sheets[0].SetValue(0,0,"Test"); FpSpread1.Sheets[0].SetValue(1,0,"For"); FpSpread1.Sheets[0].SetValue(2,0,"Margin"); FpSpread1.Sheets[0].AlternatingRows[0].Margin=inset; FpSpread1.Sheets[0].AlternatingRows[1].Margin=inset; FpSpread1.Sheets[0].AlternatingRows[2].Margin=inset; | |
| Visual Basic | Copy Code |
|---|---|
Dim inset As New FarPoint.Web.Spread.Inset(35,5,5,35) FpSpread1.Sheets(0).AlternatingRows.Count=3 FpSpread1.Sheets(0).Rows(0).Height=80 FpSpread1.Sheets(0).Rows(1).Height=80 FpSpread1.Sheets(0).Rows(2).Height=80 FpSpread1.Sheets(0).SetValue(0,0,"Test") FpSpread1.Sheets(0).SetValue(1,0,"For") FpSpread1.Sheets(0).SetValue(2,0,"Margin") FpSpread1.Sheets(0).AlternatingRows(0).Margin=inset FpSpread1.Sheets(0).AlternatingRows(1).Margin=inset FpSpread1.Sheets(0).AlternatingRows(2).Margin=inset | |
Requirements
Target Platforms: Windows 7, Windows 8, Windows Vista, Windows Server 2000, Windows 2000 Professional, Windows XP Professional, Windows NT 4.0 Workstation, SP6, Windows NT 4.0 Server, SP6