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

    Hi,


    In VB6 using Spread 6, I would sort all of the rows and have multiple
    sort columns by doing the following:

     ssCalls.Sort -1, -1, -1, -1, SortByRow, Array(COL_SM, COL_SUB_DATE), Array(1, 1)
     Is there an equivalent to this in Spread for Windows 3.0 using VS2005?

    -Justin

  • Replied 8 September 2017, 1:00 pm EST

    Justin,


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

     
        Dim si() As FarPoint.Win.Spread.SortInfo = New FarPoint.Win.Spread.SortInfo() {New FarPoint.Win.Spread.SortInfo(0, True), New FarPoint.Win.Spread.SortInfo(1, True)}
    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