Strange Horizontal scroll bar

Posted by: phillip-fp on 8 September 2017, 1:49 pm EST

  • Posted 8 September 2017, 1:49 pm EST

    Hi


    Whenever scrollbars appear on my grid, the horizontal scrollbar hides the last row of the grid.


    Could you please tell me how to fix the problem detailed on my attachment?


    Horizontal scroll bar is hidding the last row on a child view.


    Please advice



  • Replied 8 September 2017, 1:49 pm EST

    Hello Suresh,


     I am using spread vesion of  4.0 2009.2005 .net 2.0  and C#


    I tried your solution but it didn't work for me.


            private void spdDataIn_ColumnWidthChanged(object sender, FarPoint.Win.Spread.ColumnWidthChangedEventArgs e)
            {
                spdDataIn.Refresh();
            }


    and I give event to spdDataIn that is spread I am using


    so Any solution for this problem.


    Regards,


     Phillip

  • Replied 8 September 2017, 1:49 pm EST

    Hello Phillip,

    Regarding the reported issue, it was reported as a bug in the older version of the control reference. I have also tested the HierarchyVB sample and it seems to be working as expected, hence you may try updating to the latest build of the control. In addition to this, you may also try the suggested step to refresh the Spread control from the ColumnWIdthChanged event as follows:

    Private Sub fpssMain_ColumnWidthChanged(ByVal sender As Object, ByVal e As FarPoint.Win.Spread.ColumnWidthChangedEventArgs)
        fpSpread1.Refresh()
    End Sub
    Thanks
  • Replied 8 September 2017, 1:49 pm EST

    Scott,


     I will find way to provide code but it need to have some time.


    We use dataset and put datatable to childview.


    one level is ok but if we created childview many times as needed.


    It can't calculate area of scrollbar. it is what i guess now.


    and we are using latest version of spread. 12.22.2008 release


    Regards,


    Daniel

  • Replied 8 September 2017, 1:49 pm EST

    Philip,


    I was not able to reproduce this issue. Could you post a small zipped project reproducing this issue for us to debug?

  • Replied 8 September 2017, 1:49 pm EST

    Daniel,


    I understand the issue you are having based on the picture in the last post. However, I am not able to reproduce this issue. When I add more columns to the child or increase the width of a column such that the horizontal scrollbar is needed, the child SpreadView increases the height automatically to accomodate the area for the horizontal scrollbar. That is why I suggested a small zipped project reproducing the issue, so I can debug what you are seeing. Also make sure you are using the latest maintenance release of Spread for Windows Forms.

  • Replied 8 September 2017, 1:49 pm EST

    Hello  Scott,


     I am daniel. I am working with phillip.


     The problem is scrollbar of childview cover the area of childview data input. so we can't see that area and input data.


    you can reproduce that problem if you add  columns of childview more than screen can display.


    any possibility of increasing area of childview area.


     Regards,


     Daniel

  • Replied 8 September 2017, 1:49 pm EST

    I tried new version of spread.


    but, It has same problem.

  • Replied 8 September 2017, 1:49 pm EST

    There is a new Spread Win 4 patch on the updates page of the web site.
  • Replied 8 September 2017, 1:49 pm EST

    Did anyone ever find a work around for this?  We are experiencing same problem.  Very frustrating.
  • Replied 8 September 2017, 1:49 pm EST

    Well I was trying to keep it simple.  I have modified it to show what ours is doing.  There is one parentrow, one child row, and one grandchild row.  You will see in this new example that you can't see the grandchild and you can't scroll any of the vertical scrollbars to see it.


    Thanks


     


    2011/04/Sample-2.zip
  • Replied 8 September 2017, 1:49 pm EST

    Hello,


    We never was able to reproduce this issue and the customer did not send anything for us to debug. If you could send a small zipped project we could debug the issue to see what is causing this painting problem.

  • Replied 8 September 2017, 1:49 pm EST

    Hello,


    This is correct behavior since the viewport of the Spread is not large enough to show that last row. You would need to use the vertical scrollbar for the parent Spread to scroll down to see the last row.

  • Replied 8 September 2017, 1:49 pm EST

    Well I was able to get the problem to reproduce in a small project.  I have attached the project.  Run the project, then hit the button, then on bottom spread, expand the first row, then expand the 2nd child row and you will see that the row below is covered by scrollbar.
    2011/04/Sample.zip
  • Replied 8 September 2017, 1:49 pm EST

    Hello,


    Could you post a small zipped project reproducing this behavior for us to debug?

  • Replied 8 September 2017, 1:49 pm EST

    Hello,


    The scrollbar you need to scroll is from the parent Spread. This is working just like the last one you sent. Make sure you are using the latest maintenance release (version 5.0.2018.2008) for Spread for Windows Forms.

  • Replied 8 September 2017, 1:49 pm EST

    Hello,


    That is not what I see. I hae attached two screenshots. The normal.png is the size of the form when it is opened by the project. This one you will see the bottom row clipped a little. If I scroll the parent sheet scrollbar, then I am able to see the entirity of the row. The maximized.png is with the form maximized before clicking the button, since this looks more like your screenshot. With this view, I see all rows with no issues.


    2011/04/normal.PNG
  • Replied 8 September 2017, 1:49 pm EST

    Hello,


    This is a bug in the version 5.0.2014 release that you are using. I installed this version and retested your application and was able to reproduce the same issue. I then upgraded the project to the latest release (5.0.2018) and the Spread worked correctly.

  • Replied 8 September 2017, 1:49 pm EST

    Well I see that it is working in your application.  But I assure you I have my screen maximized, there is plenty of room at the bottom of the spread, and it still is cutting off the row, even if i turn the vertical scrollbars off still it does the same behavior.  I really do not want to be the deal breaker yet again for not upgrading. You will see by this thread http://www.clubfarpoint.com/Forums/forums/3/78124/ShowThread.aspx that was finally the reason we just did not upgrade to version 4 and lived with what we had.  We really want to get this upgraded this time.  So any suggestions you have for dealing with this please send them.  I can't believe there is not some issue causing this because I clearly have enough room at the bottom of the spread, The scrollbar should be underneath the row and there should be no vertical scrollbar because it is not needed.  Please help. Also we are running XP and I noticed you are running Windows 7, could that be an issue?

  • Replied 8 September 2017, 1:49 pm EST

    Here is the second screenshot, since it was to large to add to the last post.

  • Replied 8 September 2017, 1:49 pm EST

    I have attached a picture of what it looks like when I run it.  I am unable to scroll up or down with either of the scrollbars on the right, therefore I can not see the data.  I am usuing 5.0.2014 but this has been a problem since we tried to upgrade to version 4 so I doubt that it was fixed in 5.0.2018.  I am just curious if this is what you see when you run it.


    Thanks


    2011/04/ProblemSpread.JPG
Need extra support?

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

Learn More

Forum Channels