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,<br></font>

    <p class="MsoNormal"><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:<br><o:p></o:p></font>
    </p><pre class="coloredcode"><font color="#000000" face="Arial"> ssCalls.Sort -1, -1, -1, -1, SortByRow, Array(COL_SM, COL_SUB_DATE), Array(1, 1)</font></pre><font color="#000000" face="Arial"> Is there an <span>equivalent </span>to this in Spread for Windows 3.0 using VS2005?<br><br>-Justin</font><br>
  • Replied 8 September 2017, 1:00 pm EST

    <P>Justin,</P>
    <P>Here is code to do a multiple key sort in Spread for Windows Forms.</P> <PRE class=coloredcode> <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)
    </PRE> 
  • Replied 8 September 2017, 1:00 pm EST

    Thanks Scott, it works great!<br><br>-Justin<br>
  • Replied 8 September 2017, 1:00 pm EST

    <P>hi,</P>
    <P>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.</P>
    <P>so help me on this regard</P>
    <P>thanks</P>
    <P>sridhar</P>
  • Replied 8 September 2017, 1:00 pm EST

    <P>sridhar,</P>
    <P>What issue(s) are you having in you migration project?</P>
  • Replied 8 September 2017, 1:00 pm EST

    <P>sorry scott. i dint look after the previous solution.</P>
    <P>now i tried its working fine</P>
    <P> </P>
    <P>thanks</P>
    <P>sridhar</P>
Need extra support?

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

Learn More

Forum Channels