FarPoint.Win.Spread Assembly > FarPoint.Win.Spread Namespace > SpreadView Class : GetColumnRangeGroupHeight() Method |
'Declaration Public Function GetColumnRangeGroupHeight() As Integer
'Usage Dim instance As SpreadView Dim value As Integer value = instance.GetColumnRangeGroupHeight()
public int GetColumnRangeGroupHeight()
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
Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows Server 2012 R2, Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8, Windows 8.1, Windows 10