Remove Child Scroll Bars

Posted by: sathish-kumara on 8 September 2017, 1:21 pm EST

  • Posted 8 September 2017, 1:21 pm EST

    Hi,


    How to turn on/off scrollbars in the child sheet?


    Thanks,
    Sathish Kumar A

  • Replied 8 September 2017, 1:21 pm EST

    See if this works for you...

    Private Sub FpSpread1_ChildViewCreated(ByVal sender As Object, ByVal e
    As FarPoint.Win.Spread.ChildViewCreatedEventArgs) Handles
    FpSpread1.ChildViewCreated
    Dim sv As FarPoint.Win.Spread.SpreadView
    sv = FpSpread1.GetRootWorkbook.GetSpreadView(e.SheetView, 0, 0)
    sv.HorizontalScrollBarPolicy = FarPoint.Win.Spread.ScrollBarPolicy.Never
    sv.VerticalScrollBarPolicy = FarPoint.Win.Spread.ScrollBarPolicy.Never
    End Sub

  • Replied 8 September 2017, 1:21 pm EST

    I dont think this code posted by Bob works... Can some one please confirm that ? I tried it and it gives me a error


    Harish

  • Replied 8 September 2017, 1:21 pm EST

    Harish,

    You can use the ChildWorkbookCreated event to remove the verical scroll bar from the child sheet.This can be done as follows:

     Private Sub FpSpread1_ChildWorkbookCreated(ByVal sender As Object, ByVal e As FarPoint.Win.Spread.ChildWorkbookCreatedEventArgs) Handles FpSpread1.ChildWorkbookCreated
            e.Workbook.VerticalScrollBarPolicy = FarPoint.Win.Spread.ScrollBarPolicy.Never
    End Sub

    Thanks

Need extra support?

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

Learn More

Forum Channels