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

    Hi,<br><br>I have got a unique requirement of fixing a couple of columns while using horizontal scrollbar of a grid. <br><br>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.<br><br>Thanks in advance.<br>Sagar.<br>
  • Replied 8 September 2017, 12:31 pm EST

    Hello Sagar,<br><br>Setting FrozenColumnCount to two should work for you:<br> FpSpread1.Sheets(0).FrozenColumnCount = 2 <br><br>More information on freezing rows and columns can be found in your help.<br>
Need extra support?

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

Learn More

Forum Channels