7. Manipulate rows and columns

Selecting, adding, copying, moving, deleting, hiding, expanding and saving

• Changes in this sample are not saved, they are just printed to browser console and accepted!
  It is done by setting SaveUrl: { Debug:2 }

• Manipulate rows

  
  Manipulating rows is permitted by default. Moving is permitted only inside the same row part.
  To control manipulating rows set Cfg attributes

  AddingRows

  ,

  DeletingRows

  ,

  DraggingRows

  ,

  HidingRows

  .
  To permit row tree set

  Tree

  attribute in the row parts where to show the tree.
  

• Manipulate columns

  
  Adding and deleting columns is restricted by default. Only moving and hiding columns is permitted by default.
  To control manipulating columns set Cfg attributes

  AddingCols

  ,

  DeletingCols

  ,

  DraggingCols

  ,

  HidingCols

  .
  To permit column tree set Cfg

  ColTree

  .
  

• Selecting

  
  Selecting rows is permitted by default, but selecting columns is restricted by default.
  To control selecting set Cfg attributes

  SelectingRows

  ,

  SelectingCols

  .
  If the selecting is restricted, it is possible to manipulate focused rows and columns. To permit focusing more cells, set Cfg attribute

  Focus

  to 2 or 3.
  To control what is shown in row (usually header) icon SelectAll, set Cfg attribute

  SelectAllType

  .
  

• Column icons for row manipulation

  
  The icons can be placed to any cell in any icons, but usually are placed to column with D:"Panel" in

  LeftIcons

  
  The icons are: SelectRow, DeleteRow, HideRow, AddRow to manipulate the row where the icons are placed in.
  And SelectRows, DeleteRows, HideRows, AddRows placed usually in Header row in the Panel column to manipulate all rows in grid.
  

• Row icons for column manipulation

  
  The icons can be placed to any cell in any icons, but usually are placed to row with D:"Panel" in

  LeftIcons

  
  The icons are: SelectCol, DeleteCol, HideCol, AddCol to manipulate the column where the icons are placed in.
  And SelectCols, DeleteCols, HideCols, AddCols placed usually in Header column in the Panel row to manipulate all columns in grid.
  

• Toolbar icons for row / column manipulation

  
  The icons can be placed to any toolbar in any order.
  The icons that show popup menu to manipulate row(s) or column(s): Select, Delete, Hide, Add, Collapse, Indent.
  The icons for row(s) manipulation: SelectRows, DeleteRows, HideRows, AddRows, CopyRows, AddRowEnd, ExpandRows, CollapseRows, IndentRows, OutdentRows
  The icons for column(s) manipulation: SelectCols, DeleteCols, HideCols, AddCols, CopyCols, AddColEnd, ExpandCols, CollapseCols, IndentCols, OutdentCols
  

• Tracking changes

  
  The row and cell changes are tracked, colored and saved by default, except expand & select.
  The column and toolbar changes are not tracked, colored and saved by default.
  To control what changes will be tracked, use Cfg attributes

  RowChanges

  ,

  ColChanges

  ,

  CellChanges

  ,

  ToolChanges

  .
  

• Saving changes

  
  Saving changes can be done by toolbar icon Save or calling action Save().
  There must be defined Cfg

  SaveUrl

  to display the Save icon. If the SaveUrl is an object, it must have defined Url or Data attribute, or Debug = 2 for testing.
  What changes will be saved is controlled by Cfg attribute

  SaveFlags

  .