How to fix a column while using scrollbar?

Posted by: sagar-fp on 8 September 2017, 12:31 pm EST

  • Posted 8 September 2017, 12:31 pm EST


    I have got a unique requirement of fixing a couple of columns while using horizontal scrollbar of a grid.

    Say I have got 30 columns in a grid and horizontal scrollbar is enabled. Whenever I use the horizontal scrollbar, the first 2 columns should be fixed and the other columns should start scrolling.

    Thanks in advance.
  • Replied 8 September 2017, 12:31 pm EST

    Hello Sagar,

    Setting FrozenColumnCount to two should work for you:
     FpSpread1.Sheets(0).FrozenColumnCount = 2

    More information on freezing rows and columns can be found in your help.
Need extra support?

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

Learn More

Forum Channels