Spread WPF Documentation
ColumnSplitBoxAlignment Property (GcSpreadSheet)
Example 


Gets or sets the column split box alignment.
Syntax
'Declaration
 
<System.ComponentModel.DefaultValueAttribute()>
<System.ComponentModel.CategoryAttribute("Spread Workbook")>
Public Property ColumnSplitBoxAlignment As SplitBoxAlignment
'Usage
 
Dim instance As GcSpreadSheet
Dim value As SplitBoxAlignment
 
instance.ColumnSplitBoxAlignment = value
 
value = instance.ColumnSplitBoxAlignment
[System.ComponentModel.DefaultValue()]
[System.ComponentModel.Category("Spread Workbook")]
public SplitBoxAlignment ColumnSplitBoxAlignment {get; set;}
Example
This example uses the ColumnSplitBoxAlignment property.
    gcSpreadSheet1.AddColumnViewport(0, 100);
    gcSpreadSheet1.AddRowViewport(0, 80);
    gcSpreadSheet1.RowSplitBoxAlignment = GrapeCity.Windows.SpreadSheet.UI.SplitBoxAlignment.Leading;
    gcSpreadSheet1.ColumnSplitBoxAlignment = GrapeCity.Windows.SpreadSheet.UI.SplitBoxAlignment.Trailing;
    gcSpreadSheet1.Sheets[0].SetViewportHeight(0, 100);
    gcSpreadSheet1.Sheets[0].SetViewportWidth(0, 100);
    gcSpreadSheet1.Invalidate();           
      
private void button1_Click(object sender, RoutedEventArgs e)
{
    gcSpreadSheet1.RemoveColumnViewport(0);
    gcSpreadSheet1.RemoveRowViewport(0);
    gcSpreadSheet1.Invalidate();
}
            GcSpreadSheet1.AddColumnViewport(0, 100)
            GcSpreadSheet1.AddRowViewport(0, 80)
            GcSpreadSheet1.RowSplitBoxAlignment = GrapeCity.Windows.SpreadSheet.UI.SplitBoxAlignment.Leading
            GcSpreadSheet1.ColumnSplitBoxAlignment = GrapeCity.Windows.SpreadSheet.UI.SplitBoxAlignment.Trailing
            GcSpreadSheet1.Sheets[0].SetViewportHeight(0, 100)
            GcSpreadSheet1.Sheets[0].SetViewportWidth(0, 100)
            GcSpreadSheet1.Invalidate()    

Private Sub Button1_Click(sender As System.Object, e As System.Windows.RoutedEventArgs) Handles Button1.Click
      GcSpreadSheet1.RemoveColumnViewport(0)
      GcSpreadSheet1.RemoveRowViewport(0)
      GcSpreadSheet1.Invalidate()
End Sub
Requirements

Target Platforms: Windows 7, Windows 8 Desktop, Windows Vista SP1 or later, Windows Server 2000, Windows 2000 Professional (SP4), Windows XP (SP2), Windows 2008, Windows 2003 Server (SP1)

See Also

Reference

GcSpreadSheet Class
GcSpreadSheet Members

 

 


Copyright © GrapeCity, inc. All rights reserved.