Set the Vertical scrollbar postion on top

Set the Vertical scrollbar postion on top

Posted by: johina.olla on 23 November 2020, 7:57 am EST

• 

  johina.olla

  • Post Options:
  • Link
    Copy

  Posted 23 November 2020, 7:57 am EST - Updated 3 October 2022, 10:06 am EST

  As we four(1,2,3,4) grouping button in spread, currently we have selected button 4 then grouping is in expaned form as in screenshot1. Now we click on button 1 then grouping button is in collaspe form and vertical scrollbar is set to bottom as shown in screenshot2, Now we click again on button 4 then grouping is expanded form but no row is visible due to scrollbar which set at bottom as shown in screenshot3. So please provide a work around to set/reset the vertical scrollbar at top position everytime when any grouping button is clicked.

  

  1522×621 211 KB

  

  1521×633 85.1 KB

  

  1524×640 102 KB

• 

  johina.olla

  • Post Options:
  • Link
    Copy

  Posted 24 November 2020, 5:35 am EST

  We are using wijmo spreadjs12/13. for web

• 

  avinash.pathak

  • Post Options:
  • Link
    Copy

  Posted 24 November 2020, 5:51 am EST

  Hi,

  You may use RangeGroupStateChanged Event and show the specific row when the group expanded. Please refer to the following code snippet and attached sample that demonstrates the same.

  
   sheet.bind(GC.Spread.Sheets.Events.RangeGroupStateChanged, function (
      e,
      info
    ) {
      if (info.isRowGroup && !info.sheet.rowOutlines.isCollapsed(10)) {
        info.sheet.showRow(10, GC.Spread.Sheets.VerticalPosition.top);
      }
    });
  
  

  sample: https://codesandbox.io/s/vigilant-tree-e6mwd?file=/src/index.js:506-749

  API References:

  showRow: https://www.grapecity.com/spreadjs/docs/v14/online/SpreadJS~GC.Spread.Sheets.Worksheet~showRow.html?highlight=showrow%2C

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

  Regards
  
  Avinash