Horizontal scrolling with hidden columns -- Not fixed in 5.0.3511.2008

Posted by: kober on 8 September 2017, 2:24 pm EST

  • Posted 8 September 2017, 2:24 pm EST

    Hi, my application needs to have ScrollBarTrackPolicy on, and it's columns can be hidden/displayed by the user.  When I updated my application to VS 2010 and Spread 5 I noticed that it no longer scrolled smoothly horizontally.  I saw that in the release 5.0.3511.2008 this was supposed to be fixed:

    The horizontal scrollbar now works correctly with hidden columns. [99916581]

    I just updated to the new version and still have the jumping scrolling problem.  I think either the issue was not fixed in this release, or that fix could have addressed a problem when ScrollBarTrackPolicy was off, and this is a new issue to address when ScrollBarTrackPolicy is on.

    Please try to duplicate the issue and let me know if you also experience it.  I am using VS 2010 and 5.0.3511.2008.  Create a new C# project and add an FpSpread control to it, and then add the code below in the constructor after InitializeComponent().  Run the application and scroll to the right.  The jumping is most noticeable when scrolling slowly.


                this.Width = 700;
                this.Height = 500;

                fpSpread1.Dock = DockStyle.Fill;

                fpSpread1.ScrollBarTrackPolicy = FarPoint.Win.Spread.ScrollBarTrackPolicy.Horizontal;

                fpSpread1_Sheet1.Columns.Count = 30;
                fpSpread1_Sheet1.Rows.Count = 100;

                fpSpread1_Sheet1.Columns[0, 29].Width = 100;

                fpSpread1_Sheet1.Columns[2].Visible = false;
                fpSpread1_Sheet1.Columns[5].Visible = false;
                fpSpread1_Sheet1.Columns[7].Visible = false;
                fpSpread1_Sheet1.Columns[9].Visible = false;
                fpSpread1_Sheet1.Columns[14].Visible = false;
                fpSpread1_Sheet1.Columns[17].Visible = false;
                fpSpread1_Sheet1.Columns[21].Visible = false;
                fpSpread1_Sheet1.Columns[25].Visible = false;
                fpSpread1_Sheet1.Columns[27].Visible = false;

                // add some values to make the jumping scrolling more visible
                for (int i = 0; i < 100; i++)
                    fpSpread1_Sheet1.Cells[i, 0].Text = "1000";
                    fpSpread1_Sheet1.Cells[i, 4].Text = "Hello";
                    fpSpread1_Sheet1.Cells[i, 8].Text = "88888";
                    fpSpread1_Sheet1.Cells[i, 12].Text = "55555";
                    fpSpread1_Sheet1.Cells[i, 18].Text = "444444";
                    fpSpread1_Sheet1.Cells[i, 24].Text = "222222";

  • Replied 8 September 2017, 2:24 pm EST


    I am not able to replicate the reported issue with Spread 5.0.3511.2008. I tested the behavior with VS2008 and VS2005 and it is working fine. I could not test this behavior with VS2010. I have attached a video showing you the same. Let me know if I am missing some thing, I used the same code as provided by you. I will again test this with VS2010 and will inform you about the result.

    Please have a look at the attached video.








  • Replied 8 September 2017, 2:24 pm EST

    Hi, thank you for replying.  Please test with VS 2010 when you get a chance.  I uploaded a video to the url below which shows the jumping problem on my computer. Let me know if you have any problems downloading or viewing this video.



  • Replied 8 September 2017, 2:24 pm EST

    I tested this and I can see the problem, you have to drap the thumb bar slowly to see it. I will reopen the bug.


Need extra support?

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

Learn More

Forum Channels