Resizing Columns and Rows

In This Topic

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.

Resizing column by dragging its border in a spreadsheet

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(); }

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

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