Minimum length of scroll box

Minimum length of scroll box

Posted by: serdarhoja on 17 April 2023, 6:47 am EST

• 

  serdarhoja

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 17 April 2023, 6:47 am EST - Updated 17 April 2023, 6:52 am EST

  Hello, GrapeCity team.

  Can I put a minimum length of scroll box. I have sheet with 1000 rows and 1000 columns. When count of columns increase length of scroll box decreasing. I understand that it is normal, but is there some variants or formula for changing the length of scroll box

  

  716×240 9.98 KB

  

  3344×1488 301 KB

  Thank you for your help

• 

  ankit.kumar

  

  • Post Options:
  • Link
    Copy

  Posted 18 April 2023, 3:22 am EST

  Hello Serdar,

  As I can understand, you want to set the minimum length of scroll bar thumb when rows and columns are increased and scroll bar length decreases.

  We are sorry for the inconvenience caused. Currently, you can not set a minimum length for the scroll bar thumb. The length of the scroll bar thumbs is internally calculated based on the number of rows/columns in the active worksheet. There is already a default minimum length of the vertical and horizontal scroll bar thumbs in SpreadJS. This is by design.

  Additionally, you can utilize the workbook.options.tabStripRatio property of workbook to change the tab strip ratio and increase or decrease the size of horizontal scroll bar.
  
  Please refer to code snippet and attached sample.

  
  // changes tab strip ratio
  spread.options.tabStripRatio = 0.4;

  Sample: https://jscodemine.grapecity.com/share/FBNP7TGJ3E6o96-h4VIjCA/?defaultOpen={"OpenedFileName"%3A["%2Findex.html"%2C"%2Fsrc%2Fapp.js"]%2C"ActiveFile"%3A"%2Fsrc%2Fapp.js"}

  Please refer to https://www.grapecity.com/spreadjs/api/v16/interfaces/GC.Spread.Sheets.IWorkbookOptions#tabstripratio for more information.

  Regards,

  Ankit

• 

  serdarhoja

  • Post Options:
  • Link
    Copy

  Posted 19 April 2023, 5:00 pm EST

  Hello, Ankit
  
  Thank you very much