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 row.
Syntax
| Visual Basic (Declaration) | |
|---|
Public Property Margin As Inset |
| Visual Basic (Usage) |  Copy Code |
|---|
Dim instance As Row
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 row
Remarks
Example
This example creates a Row object and adjusts the alignment of the text in the row via an Inset object. The width of the column is changed so that the alignment changes can be easily seen.
| C# | Copy Code |
|---|
FpSpread1.ActiveSheetView.ColumnCount=10;
FpSpread1.ActiveSheetView.PageSize=20;
FpSpread1.ActiveSheetView.RowCount=20;
FarPoint.Web.Spread.Row myrow;
FarPoint.Web.Spread.Inset inset=new FarPoint.Web.Spread.Inset(20,50,80,20);
myrow=FpSpread1.ActiveSheetView.Rows[1];
myrow.Margin=inset;
FpSpread1.ActiveSheetView.Columns[1].Width=140;
for(int i=0;i<FpSpread1.ActiveSheetView.RowCount;i++)
{
FpSpread1.ActiveSheetView.SetValue(i,1,"Alignment");
} |
| Visual Basic | Copy Code |
|---|
FpSpread1.ActiveSheetView.ColumnCount=10
FpSpread1.ActiveSheetView.PageSize=20
FpSpread1.ActiveSheetView.RowCount=20
Dim myrow As FarPoint.Web.Spread.Row
Dim inset As New FarPoint.Web.Spread.Inset(20,50,80,20)
Dim row,i As Integer
row=1
myrow=FpSpread1.ActiveSheetView.Rows(row)
myrow.Margin=inset
FpSpread1.ActiveSheetView.Columns(1).Width=140
For i=0 To FpSpread1.ActiveSheetView.RowCount-1
FpSpread1.ActiveSheetView.SetValue(i,1,"Alignment")
Next i |
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
See Also
