The tab of active sheet was covered by scrollbar although I used setActiveSheet

The tab of active sheet was covered by scrollbar although I used setActiveSheet

Posted by: timzod on 7 November 2017, 6:21 pm EST

• 

  timzod

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 7 November 2017, 6:21 pm EST

  Hi,
  
  The function spread.setActiveSheetIndex() seems not work when the tab of target sheet has been covered by scrollbar already.
  
  I want to show the hidden tab, but it still invisiable unless click tab navigation by manual.

  recreate step

  1. goto https://www.grapecity.com/en/demos/spread/JS/TutorialSample/#/demos/basicSearch
  2. input ‘AAA’ to some cell of Sheet3
     
     3.move scrollbar to left and cover the tab of Sheet3
  3. input ‘AAA’ in the find what field and choose within ‘workbook’
  4. click find button
     
     then the active sheet changed to Sheet3, but the tab still invisible

  Anyone can tell me how to display the tab, I could not found any funtion to trigger tab navigation by code.

  Thanks very much!

• 

  deepak.sharma

  

  • Post Options:
  • Link
    Copy

  Posted 8 November 2017, 9:28 pm EST

  Hello,

  I do not understand the need of stretching the scrollbar all the way to the left, it will hide all the sheet tabs.
  
  However you can set the StartSheetIndex in code to make the sheet tab visible:

  
  var index= 2;
   if (0 <= index && index < spread.getSheetCount()) {
                          spread.startSheetIndex(index);
                      }
  
  

  Thanks,
  
  Deepak Sharma

• 

  timzod

  • Post Options:
  • Link
    Copy

  Posted 9 November 2017, 2:02 pm EST

  It works , now it looks much better when I try to find something within a workbook which has tooooo many sheets.

  Thank you very much!