Remove Child Scroll Bars

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

  • Posted 8 September 2017, 1:21 pm EST

    <P><FONT face=verdana,geneva>Hi,</FONT></P>
    <P><FONT face=verdana,geneva>How to turn on/off scrollbars in the child sheet?</FONT></P>
    <P><FONT face=verdana,geneva>Thanks,<BR>Sathish Kumar A</FONT></P>
  • Replied 8 September 2017, 1:21 pm EST

    <p>See if this works for you...</p><p>Private Sub FpSpread1_ChildViewCreated(ByVal sender As Object, ByVal e
    As FarPoint.Win.Spread.ChildViewCreatedEventArgs) Handles
    FpSpread1.ChildViewCreated<br>Dim sv As FarPoint.Win.Spread.SpreadView<br>sv = FpSpread1.GetRootWorkbook.GetSpreadView(e.SheetView, 0, 0)<br>sv.HorizontalScrollBarPolicy = FarPoint.Win.Spread.ScrollBarPolicy.Never<br>sv.VerticalScrollBarPolicy = FarPoint.Win.Spread.ScrollBarPolicy.Never<br>End Sub <br></p>
  • Replied 8 September 2017, 1:21 pm EST

    <P>I dont think this code posted by Bob works... Can some one please confirm that ? I tried it and it gives me a error</P>
  • Replied 8 September 2017, 1:21 pm EST

    <p>Harish,</p><p>You can use the <b>ChildWorkbookCreated </b>event to remove the verical scroll bar from the child sheet.This can be done as follows:</p><blockquote><p> Private Sub FpSpread1_ChildWorkbookCreated(ByVal sender As Object, ByVal e As FarPoint.Win.Spread.ChildWorkbookCreatedEventArgs) Handles FpSpread1.ChildWorkbookCreated<br>        e.Workbook.VerticalScrollBarPolicy = FarPoint.Win.Spread.ScrollBarPolicy.Never<br>End Sub</p></blockquote><p>Thanks<br></p>
Need extra support?

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

Learn More

Forum Channels