Gets or sets the default settings of the cell margins that define the space between the cell border and the cell contents, for all the cells in this alternating row.
Syntax
| Visual Basic (Declaration) | |
|---|
Public Property Margin As Inset |
| Visual Basic (Usage) |  Copy Code |
|---|
Dim instance As AlternatingRow
Dim value As Inset
instance.Margin = value
value = instance.Margin |
| C# | |
|---|
public Inset Margin {get; set;} |
Property Value
Inset object containing the margins for the contents of the cells in this alternating row
Remarks
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.Insetinset=newFarPoint.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].SetCellValue(0,0,"Test");
FpSpread1.Sheets[0].SetCellValue(1,0,"for");
FpSpread1.Sheets[0].SetCellValue(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 |
|---|
DiminsetAsNewFarPoint.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).SetCellValue(0,0,"Test")
FpSpread1.Sheets(0).SetCellValue(1,0,"for")
FpSpread1.Sheets(0).SetCellValue(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
