GrapeCity Forums

is it possible to hide the vertical scroll bars for childviews ?

Harish

Hello Harish,

I don't think it is possible to make ScrollBars disappear for Child SheetView as the ScrollBar is a property  of Spread, it is not available for individual SheetViews.

Thanks,

Harish,

You can use the below to hide the vertical scroll bar from child sheet.

 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

No. The problem with the above code is, it also hides the V scrollbar of the Main SPread control. We dont want that.

Harish

Harish,

What are you referring to by main Spread control? I have also tested the same at my side and the provided snippet hides the V-scrollbar of child sheet and not the parent sheet. Try implementing the provided snippet on the installed Hierarchy sample project, you will observe the v-scrollbar disappearing from child sheet where as parent scroll bar has the v-scroll bar. Let us know, your observations with that.

Thanks

Suresh,

I think you are right. Now, I see the scroll bars of parent but not the childviews. But my vertical scrollbar is not scrolling. Its length is the full height of the spread. So, even when I expand all the child views, the vertical scroll bar is not changing its height. Is there any other property I need to set or something ?

Thanks a ton for your help

Harish

Suresh,

  I think I figured it out. I think its a issue with your spread. Please see attached jpg file. I have a picture of the sample Hierarchy application screen. On that screen, there are 4 more tracks (Songs) under "Woman of the World". please bring up the application and try to make your screen look like my screen in the attached jpg and then try to scroll down to see the songs under "Woman of the World". You will not be able to. Because it will move to "Foreigner" Which is the second one below "AeroSmith".

Let me know your thoughts.

Harish

Harish,

I am not sure about this"it will move to "Foreigner" Which is the second one below "AeroSmith". I have resized the form and then ran the application, on expanding the child view I can see all the record under the "Woman of World". I am attaching a screen shot for your reference.

Thanks

Well, you are not supposed to resize the form. Then It kind of beats the purpose of the vertical scroll bar. Doesn't it ?

I cant resize the form every time my data changes.

Harish

Hello Harish ,

I am able to replicate the behavior described by you and I found that It is still possible to Scroll Horizontally  for the same view.

I have reported this as a bug to our QA team (Bug Number: 27231). This should be fixed in our next maintenance release of Spread for Windows Forms.

Make sure you opt to receive email notifications when someone respond to this thread for further updates on this.

Thanks

Iam confused. You are saying "Horizontally" but I was having issue with the vertical scrollbar ? Not sure of this bug you reported.(27231). Can you please explain the bug ?

Harish

Hello Harish,

I am able to reproduce the Vertical Scroll Bar issue and the reported Bug is about same.

I just wanted to tell you that the Horizontal Scroll is still working where as the Vertical is not.

Thanks,

Hello,

This bug has come back as intended behavior.You might have a look at the explanation provided:

The scrollbar will only scroll the rows for that particular SheetView.Since you have turned off the scrollbar for the child SheetViews, thereis not a way to scroll to see the other rows not visible.

Thanks,