sheet focus

Posted by: tthogan3 on 8 September 2017, 1:17 pm EST

  • Posted 8 September 2017, 1:17 pm EST

    My company is using Winforms v. 2.5.2008.   I need to know which sheet has focus, especially when there's a hierarchical sheet.  Is there some way to do that?
  • Replied 8 September 2017, 1:17 pm EST

    You should be able to use the ActiveSheetIndex to return which sheet is active and has focus.
  • Replied 8 September 2017, 1:17 pm EST

    What if a hierarchical sheet has focus?
  • Replied 8 September 2017, 1:17 pm EST

    Hello,


    You can use the GetActgiveWorkBook method to get the active SpreadView object and then query it's Sheets(0) property to get the SheetView object in that SpreadView.


       FpSpread1.GetRootWorkBook.GetActiveWorkBook.Sheets(0)

  • Replied 8 September 2017, 1:17 pm EST

    That worked.  Thanks, Scott.
Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels