SpreadsheetGear The Performance Spreadsheet Component Company 
Insert(InsertShiftDirection) Method
See Also  Example
SpreadsheetGear Namespace > IRange Interface > Insert Method : Insert(InsertShiftDirection) Method
shiftDirection
Specifies whether to shift cells right or down.
Inserts cells, rows or columns by shifting cells right or down and fixing up formulas and formats.

Syntax

C# 
virtual void Insert( 
   InsertShiftDirection shiftDirection
)

Parameters

shiftDirection
Specifies whether to shift cells right or down.

Example

C#Copy Code
using System; 
using SpreadsheetGear; 
using System.Diagnostics; 
 
namespace SpreadsheetGear.InsertExample 
{ 
    class Program 
    { 
        static void Main() 
        { 
            // Create a workbook. 
            IWorkbook workbook = Factory.GetWorkbook(); 
            IWorksheet worksheet = workbook.Worksheets[0]; 
            IRange cells = worksheet.Cells; 
 
            // Set some text in A1:B2. 
            cells["A1"].Formula = "A1"; 
            cells["A2"].Formula = "A2"; 
            cells["B1"].Formula = "B1"; 
            cells["B2"].Formula = "B2"; 
 
            // Insert two rows before row 2. 
            cells["2:3"].Insert(); 
 
            // Insert three columns before column 'B'. 
            cells["B:D"].Insert(); 
 
            // Verify new locations - A1 has not moved. 
            Debug.Assert(cells["A1"].Formula.Equals("A1")); 
            // A2 has been moved down two rows. 
            Debug.Assert(cells["A4"].Formula.Equals("A2")); 
            // B1 has been moved right three columns. 
            Debug.Assert(cells["E1"].Formula.Equals("B1")); 
            // B2 has been moved down two rows and right three columns. 
            Debug.Assert(cells["E4"].Formula.Equals("B2")); 
 
            // Insert one cell before E4 shifting E4 down to E5. 
            cells["E4"].Insert(InsertShiftDirection.Down); 
            Debug.Assert(cells["E5"].Formula.Equals("B2")); 
 
            // Insert one cell before E5 shifting E5 right to F5. 
            cells["E5"].Insert(InsertShiftDirection.Right); 
            Debug.Assert(cells["F5"].Formula.Equals("B2")); 
        } 
    } 
} 
    
Visual BasicCopy Code
Imports System
Imports SpreadsheetGear
Imports System.Diagnostics


Namespace SpreadsheetGear.InsertExample

    Class Program

        Shared Sub Main()
            ' Create a workbook.
            Dim workbook As IWorkbook = Factory.GetWorkbook()
            Dim worksheet As IWorksheet = workbook.Worksheets(0)
            Dim cells As IRange = worksheet.Cells

            ' Set some text in A1:B2.
            cells("A1").Formula = "A1"
            cells("A2").Formula = "A2"
            cells("B1").Formula = "B1"
            cells("B2").Formula = "B2"

            ' Insert two rows before row 2.
            cells("2:3").Insert()

            ' Insert three columns before column 'B'.
            cells("B:D").Insert()

            ' Verify new locations - A1 has not moved.
            Debug.Assert(cells("A1").Formula.Equals("A1"))
            ' A2 has been moved down two rows.
            Debug.Assert(cells("A4").Formula.Equals("A2"))
            ' B1 has been moved right three columns.
            Debug.Assert(cells("E1").Formula.Equals("B1"))
            ' B2 has been moved down two rows and right three columns.
            Debug.Assert(cells("E4").Formula.Equals("B2"))

            ' Insert one cell before E4 shifting E4 down to E5.
            cells("E4").Insert(InsertShiftDirection.Down)
            Debug.Assert(cells("E5").Formula.Equals("B2"))

            ' Insert one cell before E5 shifting E5 right to F5.
            cells("E5").Insert(InsertShiftDirection.Right)
            Debug.Assert(cells("F5").Formula.Equals("B2"))
        End Sub 'Main
    End Class 'Program
End Namespace 'SpreadsheetGear.InsertExample

Requirements

Platforms: Windows 98, Windows Millennium Edition, Windows 2000, Windows XP Home Edition, Windows XP Professional, Windows Server 2003 family. SpreadsheetGear for .NET 1.x requires the Microsoft .NET Framework 1.1 or .NET 2.0. SpreadsheetGear for .NET 2006 requires the Microsoft .NET Framework 2.0.

See Also