Sorting with Spread for Windows 3.0 VS2005

Posted by: smiley-fp on 8 September 2017, 1:00 pm EST

  • Posted 8 September 2017, 1:00 pm EST

    <font color="#000000" face="Arial">Hi,
    </font>

    <font color="#000000" face="Arial">In VB6 using Spread 6, I would sort all of the rows and have multiple
    sort columns by doing the following:
    <o:p></o:p></font>

    <font color="#000000" face="Arial"> ssCalls.Sort -1, -1, -1, -1, SortByRow, Array(COL_SM, COL_SUB_DATE), Array(1, 1)</font>
    <font color="#000000" face="Arial"> Is there an <span>equivalent </span>to this in Spread for Windows 3.0 using VS2005?

    -Justin</font>
  • Replied 8 September 2017, 1:00 pm EST

    Justin,


    Here is code to do a multiple key sort in Spread for Windows Forms.

     
        <SPAN class=kwd>Dim</SPAN> si() <SPAN class=kwd>As</SPAN> FarPoint.Win.Spread.SortInfo = <SPAN class=kwd>New</SPAN> FarPoint.Win.Spread.SortInfo() {<SPAN class=kwd>New</SPAN> FarPoint.Win.Spread.SortInfo(0, <SPAN class=kwd>True</SPAN>), <SPAN class=kwd>New</SPAN> FarPoint.Win.Spread.SortInfo(1, <SPAN class=kwd>True</SPAN>)}
    FpSpread1.Sheets(0).SortRows(0, FpSpread1.Sheets(0).RowCount, si)
     
  • Replied 8 September 2017, 1:00 pm EST

    Thanks Scott, it works great!

    -Justin
  • Replied 8 September 2017, 1:00 pm EST

    hi,


    iam working on a migration project from vb6 to vb.net 2005. in vb.net 2005 iam using the control farpoint spread for windows3.0 in my application.


    so help me on this regard


    thanks


    sridhar

  • Replied 8 September 2017, 1:00 pm EST

    sridhar,


    What issue(s) are you having in you migration project?

  • Replied 8 September 2017, 1:00 pm EST

    sorry scott. i dint look after the previous solution.


    now i tried its working fine


     


    thanks


    sridhar

Need extra support?

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

Learn More

Forum Channels