Class GridView.ADD_REM_ROW_COL

ADD_REM_ROW_COL

Class Summary
Constructor Attributes Constructor Name and Description
 
GridView Add or Remove Row or Column based functions comes under this Sub Class

Method Summary

Class Detail

GridView.ADD_REM_ROW_COL()
GridView Add or Remove Row or Column based functions comes under this Sub Class
require('GridView').ADD_REM_ROW_COL

Method Detail

  • <static> GridView.ADD_REM_ROW_COL.addColumnFieldInFormulaForColumnAdd(sheetId, columns)
    Once a new column is added, if it breaks any group which is reffered by any nexcel expression, a new column in expression need to be added so that it will not effect the result already generated.
    Parameters:
    {Integer} sheetId
    The sheet in which the row or column added
    {Integer} columns
  • <static> GridView.ADD_REM_ROW_COL.addColumnLeft()
    This method will add a column left to the current selection column, It will validate whether a row can be inserted or not.If it will add a row in a group with formula, then the group value will be filtered to avoid the blank values in group result. As the row added, then the refering expressions row and column will be calculated and updated with relative formula.
  • <static> GridView.ADD_REM_ROW_COL.addColumnRight()
    This method will add a column right to the current selection column, It will validate whether a row can be inserted or not.If it will add a row in a group with formula, then the group value will be filtered to avoid the blank values in group result. As the row added, then the refering expressions row and column will be calculated and updated with relative formula.
  • <static> GridView.ADD_REM_ROW_COL.addRowAbove()
    This method will add a row above the current selection row, It will validate whether a row can be inserted or not.If it will add a row in a group with formula, then the group value will be filtered to avoid the blank values in group result. As the row added, then the refering expressions row and column will be calculated and updated with relative formula.
  • <static> GridView.ADD_REM_ROW_COL.addRowBelow()
    This method will add a row below the current selection row, It will validate whether a row can be inserted or not.If it will add a row in a group with formula, then the group value will be filtered to avoid the blank values in group result. As the row added, then the refering expressions row and column will be calculated and updated with relative formula.
  • <static> {boolean} GridView.ADD_REM_ROW_COL.checkForRowInsert(sheetId, row)
    It will check whether a row can be inserted on the provided row of the sheetId provided.It will deny if try to insert a row between Group name and column names.
    Parameters:
    {Integer} sheetId
    {Integer} row
    Returns:
    {boolean} whether a row can be inserted
  • <static> GridView.ADD_REM_ROW_COL.moveGroupOnColAdd(sheetId, pos, columns)
    This method simply reposition group position. Columns can be -ve value -> -2 means two columns deleted +2 means added 2 columns
    Parameters:
    {Integer} sheetId
    {Integer} pos
    which position the row is inserted or deleted.
    {Integer} columns
    Number of columns, if deleted, then the value will be negative.
  • <static> GridView.ADD_REM_ROW_COL.moveGroupOnRowAdd(sheetId, pos, rows)
    This method simply reposition group position values in group Object
    Parameters:
    {Integer} sheetId
    {Integer} pos
    which position the row is inserted or deleted.
    {Integer} rows
    Number of rows, if deleted, then the value will be negative.
  • <static> GridView.ADD_REM_ROW_COL.removeEmptyRowsInGroupWithFormulaOnRowAdd(sheetId, startRow, endRow)
    The method will remove empty rows in the Group with formula while a row is added in the group.
    Parameters:
    {Integer} sheetId
    The sheet in which the row or column added
    {Integer} startRow
    {Integer} endRow
  • <static> GridView.ADD_REM_ROW_COL.updateCellFormulaOnRowColAdd(cellList, startCell, rows, columns)
    This method will iterate through the cellList provided, and update the cell formula with the relative formula using @RelativeFormulaController.
    Parameters:
    {Collection.ArrayList} cellList
    The list of cell with the formula
    {String} startCell
    @example A1 or C10 etc..
    {Integer} rows
    number of rows added.
    {Integer} columns
    Number of columns added
  • <static> GridView.ADD_REM_ROW_COL.updateGroupFormulaOnRowColAdd(sheetId, startCell, rows, columns)
    This method will iterate through the groups in the Sheet provided and update the group formula with the relative formula using @RelativeFormulaController.
    Parameters:
    {Integer} sheetId
    The sheet in which the row or column added
    {String} startCell
    @example A1 or C10 etc..
    {Integer} rows
    number of rows added.
    {Integer} columns
    Number of columns added