You can allow the user to resize columns and rows or specific columns or rows. Multiple selected columns or rows can also be resized.
Move the mouse pointer over the border between the column or row header. The mouse pointer will change to a double arrow. Click and drag to the right or left to resize the column and row and release the mouse to change the column width or row height. A preview line is displayed when dragging.
You can make a column or row resizable in code with the SetColumnResizable or SetRowResizable method.
Using Code
The following example allows the column and row to be resized.
| CS |
Copy Code
|
|
gcSpreadSheet1.Sheets[0].ColumnCount = 7;
gcSpreadSheet1.Sheets[0].RowCount = 10;
gcSpreadSheet1.Sheets[0].Cells[0, 0].Text = "Western";
gcSpreadSheet1.Sheets[0].Cells[0, 1].Text = "Western";
gcSpreadSheet1.Sheets[0].Cells[0, 2].Text = "Western";
gcSpreadSheet1.Sheets[0].Cells[1, 0].Text = "A";
gcSpreadSheet1.Sheets[0].Cells[1, 1].Text = "B";
gcSpreadSheet1.Sheets[0].Cells[1, 2].Text = "C";
gcSpreadSheet1.Sheets[0].SetColumnResizable(0, GrapeCity.Windows.SpreadSheet.Data.SheetArea.ColumnHeader, true);
gcSpreadSheet1.Sheets[0].SetRowResizable(0, GrapeCity.Windows.SpreadSheet.Data.SheetArea.RowHeader, true);
gcSpreadSheet1.Invalidate();
private void button1_Click(object sender, RoutedEventArgs e)
{
listBox1.Items.Add(gcSpreadSheet1.Sheets[0].GetColumnResizable(0).ToString());
//ListBox1.Items.Add(gcSpreadSheet1.Sheets[0].GetColumnResizable(0, GrapeCity.Windows.SpreadSheet.Data.SheetArea.ColumnHeader).ToString());
//ListBox1.Items.Add(gcSpreadSheet1.Sheets[0].GetRowResizable(0).ToString());
listBox1.Items.Add(gcSpreadSheet1.Sheets[0].GetRowResizable(0, GrapeCity.Windows.SpreadSheet.Data.SheetArea.RowHeader).ToString
());
gcSpreadSheet1.Invalidate();
}
|
| VB.NET |
Copy Code
|
|
GcSpreadSheet1.Sheets(0).ColumnCount = 7
GcSpreadSheet1.Sheets(0).RowCount = 10
GcSpreadSheet1.Sheets(0).Cells(0, 0).Text = "Western"
GcSpreadSheet1.Sheets(0).Cells(0, 1).Text = "Western"
GcSpreadSheet1.Sheets(0).Cells(0, 2).Text = "Western"
GcSpreadSheet1.Sheets(0).Cells(1, 0).Text = "A"
GcSpreadSheet1.Sheets(0).Cells(1, 1).Text = "B"
GcSpreadSheet1.Sheets(0).Cells(1, 2).Text = "C"
GcSpreadSheet1.Sheets(0).SetColumnResizable(0, GrapeCity.Windows.SpreadSheet.Data.SheetArea.ColumnHeader, True)
GcSpreadSheet1.Sheets(0).SetRowResizable(0, GrapeCity.Windows.SpreadSheet.Data.SheetArea.RowHeader, True)
GcSpreadSheet1.Invalidate()
Private Sub Button1_Click(sender As System.Object, e As System.Windows.RoutedEventArgs) Handles Button1.Click
ListBox1.Items.Add(GcSpreadSheet1.Sheets(0).GetColumnResizable(0).ToString())
'ListBox1.Items.Add(GcSpreadSheet1.Sheets(0).GetColumnResizable(0,
GrapeCity.Windows.SpreadSheet.Data.SheetArea.ColumnHeader).ToString())
'ListBox1.Items.Add(GcSpreadSheet1.Sheets(0).GetRowResizable(0).ToString())
ListBox1.Items.Add(GcSpreadSheet1.Sheets(0).GetRowResizable(0,
GrapeCity.Windows.SpreadSheet.Data.SheetArea.RowHeader).ToString())
GcSpreadSheet1.Invalidate()
End Sub
|
See Also