| FarPoint.Web.Spread Assembly > FarPoint.Web.Spread Namespace > SheetView Class : MoveColumn Method |
| Overload | Description |
|---|---|
| MoveColumn | Moves the column or columns to a specified location. |
Use this method to move the data and formatting in a range of columns in the sheet. It cuts and moves all contents to the column in front of the specifed destination column.
Moving a range of columns with this method moves the data and formatting, including formulas and cell notes.
Moving a range of columns with this method cuts the columns and pastes them in front of the specified location. The pasted columns are inserted before the specified column. For example, moving columns B and C to column F cuts columns B and C and pastes them in front of column F.
FarPoint.Web.Spread.SheetView sv; sv = FpSpread1.ActiveSheetView; sv.SetValue(0, 0, 1); sv.SetValue(0, 1, 2); sv.SetValue(0, 2, 3); sv.SetValue(0, 3, 4); sv.MoveColumn(0, 1, 2);
Dim sv As FarPoint.Web.Spread.SheetView sv = FpSpread1.ActiveSheetView sv.SetValue(0, 0, "One") sv.SetValue(0, 1, "Two") sv.SetValue(0, 2, "Three") sv.SetValue(0, 3, "Four") sv.MoveColumn(0, 1, 2)
Target Platforms: Windows 7, Windows 8, Windows Vista, Windows Server 2000, Windows 2000 Professional, Windows XP Professional, Windows NT 4.0 Workstation, SP6, Windows NT 4.0 Server, SP6