Scrolling behavior question

Scrolling behavior question

Posted by: kwallace on 30 June 2021, 3:48 pm EST

• 

  kwallace

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 30 June 2021, 3:48 pm EST

  Hello,
  
  Out of curiosity is there a known way to get the scroll bars in the editor to behave similar to excel where there is an ‘infinite’ scroll / dynamic scroll bar type of feel where if you keep scrolling the canvas expands and the scroll bar starts large and shrinks as you scroll and the canvas gets bigger? Or is this something we’d have to implement on our side? And is it something we are even capable of implementing on our side?

  Thanks,
  
  Keith

• 

  avinash.pathak

  • Post Options:
  • Link
    Copy

  Posted 1 July 2021, 8:35 am EST

  Hi,

  You may implement this functionality using the TopRowChanged event. Please refer to the following code snippet and attached sample that demonstrates the same.

  
    sheet.bind(GC.Spread.Sheets.Events.TopRowChanged, (e, args) => {
      let sheet = args.sheet;
      let rowCount = sheet.getRowCount();
      if (rowCount < sheet.getViewportBottomRow(1) + 15) {
        args.sheet.addRows(rowCount, 10);
      }
    });
  
  

  sample: https://codesandbox.io/s/xenodochial-sky-bvxvx?file=/src/index.js

  API References:

  addRows: https://www.grapecity.com/spreadjs/docs/v14/online/SpreadJS~GC.Spread.Sheets.Worksheet~addRows.html

  TopRowChanged: https://www.grapecity.com/spreadjs/docs/v14/online/SpreadJS~GC.Spread.Sheets.Events~TopRowChanged_EV.html

  Regards,
  
  Avinash