Select visible only cells

Select visible only cells

Posted by: davide.vago on 7 August 2019, 7:02 am EST

• 

  davide.vago

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 7 August 2019, 7:02 am EST

  Good morning/afternoon

  I’m currently working on a Spreadjs sheet instance where the set of data injected is filtered via functions like: setColumnsVisibility, setRowVisible and I have a function attached to the event SelectionChanged.

  On SelectionChanged I basically update areas of the interface based on the values of the selected cells. At the stage of the event being triggered I’ve access to the info.newSelections object which gives me parameters like row, rowCount, col and colCount.

  The problem comes when (as user) I select the whole row/column using the axis indexes (e.g. A or 4). At this stage the selection returns me all the items of the row/column even when the items are hidden.

  Do you have anything to filter out the list based on visibility?

  ---

  refs.

  • SelectionChanged
    
    https://help.grapecity.com/spread/SpreadSheets11/webframe.html#SpreadJS~GC.Spread.Sheets.Events~SelectionChanged_EV.html
• 

  sharad.tomer

  

  • Post Options:
  • Link
    Copy

  Posted 8 August 2019, 1:08 am EST

  Hi Davide,

  We could use the getRowVisble()/getColumnVisible() to check if the given row is visible or not. Please refer to the following code snippet:

  function isCellVisible(sheet, rowIndex, colIndex) {
    return sheet.getRowVisible(rowIndex) && sheet.getColumnVisible(colIndex);
  }
  

  API referenses:
  
  • getRowVisible: http://help.grapecity.com/spread/SpreadSheets11/webframe.html#SpreadJS~GC.Spread.Sheets.Worksheet~getRowVisible.html
  
  • getColumnVisible: http://help.grapecity.com/spread/SpreadSheets11/webframe.html#SpreadJS~GC.Spread.Sheets.Worksheet~getColumnVisible.html

  Regards

• 

  davide.vago

  • Post Options:
  • Link
    Copy

  Posted 9 August 2019, 7:26 am EST

  Thanks Sharad,

  The 2 methods mentioned are perfectly fine for what I needed.