How can I set a column to be the most left column of the sheet?

Posted by: luigggye-fp on 8 September 2017, 2:10 pm EST

  • Posted 8 September 2017, 2:10 pm EST

    Hi,


    After load a sheet manually (100 columns and 1000 rows for example), I must to be able to set a specific column as the most left column of the sheet?


    Without this, always I must to use the scroll bar to arrive to this column.


    Could anybody help me please?


    Thanks in advance,


     


     

  • Replied 8 September 2017, 2:10 pm EST

    Hi, this can be achieved by using the ShowColumn method of the FpSpread class.

    [Code]

    this.fpSpread1.ActiveSheet.ActiveColumnIndex = 5;

    this.fpSpread1.ShowColumn(0, 5, FarPoint.Win.Spread.HorizontalPosition.Left);

    [End of Code] 

    The above code will set the Column 5 as ActiveColumn, as well scroll to it by the ShowColumn method.

    Thanks,

    ~Jacob 

Need extra support?

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

Learn More

Forum Channels