Spread Windows Forms 12.0 Product Documentation
GetColumnRangeGroupHeight() Method
Example 


FarPoint.Win.Spread Assembly > FarPoint.Win.Spread Namespace > SpreadView Class : GetColumnRangeGroupHeight() Method
Gets the height of the column range group.
Syntax
'Declaration
 
Public Function GetColumnRangeGroupHeight() As Integer
'Usage
 
Dim instance As SpreadView
Dim value As Integer
 
value = instance.GetColumnRangeGroupHeight()
public int GetColumnRangeGroupHeight()

Return Value

Height of the column range group.
Example
This example uses the GetColumnRangeGroupHeight method.
fpSpread1.ActiveSheet.Rows.Count = 11;
fpSpread1.ActiveSheet.Columns.Count = 6;
fpSpread1.InterfaceRenderer = null;
fpSpread1.ActiveSheet.RangeGroupBackgroundColor = Color.LightGreen;
fpSpread1.ActiveSheet.RangeGroupButtonStyle = FarPoint.Win.Spread.RangeGroupButtonStyle.Enhanced;
fpSpread1.ActiveSheet.AddRangeGroup(0, 8, true);
fpSpread1.ActiveSheet.AddRangeGroup(0, 5, true);
fpSpread1.ActiveSheet.AddRangeGroup(1, 3, false);
fpSpread1.ActiveSheet.AddRangeGroup(1, 2, false);

private void button1_Click(object sender, EventArgs e)
{
FarPoint.Win.Spread.SpreadView sv;
sv = fpSpread1.GetRootWorkbook();
listBox1.Items.Add(sv.GetColumnRangeGroupHeight());
}
fpSpread1.ActiveSheet.Rows.Count = 11
fpSpread1.ActiveSheet.Columns.Count = 6
fpSpread1.InterfaceRenderer = Nothing
fpSpread1.ActiveSheet.RangeGroupBackgroundColor = Color.LightGreen
fpSpread1.ActiveSheet.RangeGroupButtonStyle = FarPoint.Win.Spread.RangeGroupButtonStyle.Enhanced
fpSpread1.ActiveSheet.AddRangeGroup(0, 8, True)
fpSpread1.ActiveSheet.AddRangeGroup(0, 5, True)
fpSpread1.ActiveSheet.AddRangeGroup(1, 3, False)
fpSpread1.ActiveSheet.AddRangeGroup(1, 2, False)

Private Sub Button1_Click(sender As Object, e As EventArgs) Handles Button1.Click
Dim sv As FarPoint.Win.Spread.SpreadView
sv = fpSpread1.GetRootWorkbook()
ListBox1.Items.Add(sv.GetColumnRangeGroupHeight())
End Sub
See Also

Reference

SpreadView Class
SpreadView Members