I'm using Aspose.Cells to open a workbook, then copy a worksheet (using Worksheets.AddCopy) many times, each time adding data to the copy. It works beautifully.
However, when I save my new workbook, I want it to be positioned on the first worksheet (index 0). So, I set the active worksheet to 0 using Worksheets.ActiveSheetIndex=0. That, too, works fine.
However, the worksheet tabs at the bottom of my workbook are scrolled all the way over to the right, even though the left-most worksheet is the active one. Is there a way for me to set that tab scrolling area so that the left-most worksheets are visible rather than the right-most.