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

    <SPAN id=result_box class=short_text><SPAN style="BACKGROUND-COLOR:#fff;">Hi,</SPAN></SPAN>


    <SPAN class=short_text><SPAN style="BACKGROUND-COLOR:#fff;">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?</SPAN></SPAN>


    <SPAN class=short_text><SPAN style="BACKGROUND-COLOR:#fff;">Without this, always I must to use the scroll bar to arrive to this column.</SPAN></SPAN>


    <SPAN class=short_text><SPAN style="BACKGROUND-COLOR:#fff;">Could anybody help me please?</SPAN></SPAN>


    <SPAN class=short_text><SPAN style="BACKGROUND-COLOR:#fff;">Thanks in advance,</SPAN></SPAN>


    <SPAN class=short_text><SPAN style="BACKGROUND-COLOR:#fff;"></SPAN></SPAN> 


    <SPAN class=short_text><SPAN style="BACKGROUND-COLOR:#fff;"></SPAN></SPAN> 

  • 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