Gets the index of the next column in a specified row that contains style settings.
Syntax
Parameters
- row
- Row index
- column
- Column index before the column to start looking (-1 to start at column 0)
Return Value
Integer column index for the next cell in the row containing a value, or -1 if no columns contain a value
Example
This example returns the index of the next column in a specified row that contains style settings.
| C# |  Copy Code |
|---|
FarPoint.Win.Spread.Model.BaseSheetStyleModel styleModel;
FarPoint.Win.Spread.StyleInfo sInfo = new FarPoint.Win.Spread.StyleInfo();
int i;
sInfo.BackColor = Color.Red;
fpSpread1.ActiveSheet.Models.Style.SetDirectInfo(0, 0, sInfo);
styleModel = (FarPoint.Win.Spread.Model.BaseSheetStyleModel)fpSpread1.ActiveSheet.Models.Style;
i = styleModel.NextNonEmptyColumnInRow(0, -1)
MessageBox.Show("The next non-empty column is " + i.ToString())
|
| Visual Basic | Copy Code |
|---|
Dim styleModel As FarPoint.Win.Spread.Model.BaseSheetStyleModel
Dim sInfo As New FarPoint.Win.Spread.StyleInfo
Dim i As Integer
sInfo.BackColor = Color.Red
styleModel = FpSpread1.ActiveSheet.Models.Style
FpSpread1.ActiveSheet.Models.Style.SetDirectInfo(0, 0, sInfo)
i = styleModel.NextNonEmptyColumnInRow(0, -1)
MessageBox.Show("The next non-empty column is " & i.ToString()) |
Requirements
Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2
See Also
