Creates an empty set of margins (Inset object).
Syntax
| Visual Basic (Declaration) | |
|---|
Public Function New() |
| Visual Basic (Usage) |  Copy Code |
|---|
Dim instance As New Inset() |
Remarks
Example
This example creates a new instance of an inset.
| C# | Copy Code |
|---|
FarPoint.Web.Spread.Inset inset = New FarPoint.Web.Spread.Inset();
inset.Left = 35;
inset.Top = 5;
inset.Right = 5;
inset.Bottom = 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()
inset.Left = 35
inset.Top = 5
inset.Right = 5
inset.Bottom = 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 98, Windows NT 4.0, Windows Millennium Edition, Windows 2000, Windows XP Home Edition, Windows XP Professional, Windows Server 2003 family, Windows Vista, Windows Server 2008 family
See Also
