Verticle and Horizontal scrollbars should enable only when it overflows

Verticle and Horizontal scrollbars should enable only when it overflows

Posted by: fareed.sheik on 30 September 2021, 8:26 am EST

• 

  fareed.sheik

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 30 September 2021, 8:26 am EST

  HI,

  Currently I see that, irrespective of number of rows and columns, both horizontal and vertical scrolls are enabled.But Am looking for,
  
  Vertical scroll should enable only when it overflows the number of rows
  
  and similarly for horizontal, it should enable when it overflows the number of columns.

• 

  avinash.pathak

  • Post Options:
  • Link
    Copy

  Posted 1 October 2021, 5:58 am EST - Updated 3 October 2022, 9:37 am EST

  Hi,

  For this, you may use scrollBarMaxAlign option. Please refer to the following code snippet and let us know if you face any issues.

  
  spread.options.scrollbarMaxAlign = true
  
  

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

  Regards
  
  Avinash