MULTI-LEVEL SORTING IN FARPOINT

Posted by: sourav-agarawal on 8 September 2017, 1:57 pm EST

  • Posted 8 September 2017, 1:57 pm EST

    <P><FONT color=#000000>Does FARPOINT have any Limitation in performing multi-level sort</FONT><FONT color=#000000><SPAN style="FONT-SIZE:10pt;COLOR:red;FONT-FAMILY:Verdana;mso-bidi-font-size:12.0pt;mso-fareast-font-family:'Times New Roman';mso-bidi-font-family:'Times New Roman';mso-ansi-language:EN-US;mso-fareast-language:EN-US;mso-bidi-language:AR-SA;mso-bidi-font-style:italic;">?</SPAN></FONT></P>
    <P><SPAN style="FONT-SIZE:10pt;COLOR:red;FONT-FAMILY:Verdana;mso-bidi-font-size:12.0pt;mso-fareast-font-family:'Times New Roman';mso-bidi-font-family:'Times New Roman';mso-ansi-language:EN-US;mso-fareast-language:EN-US;mso-bidi-language:AR-SA;mso-bidi-font-style:italic;"><FONT color=#000000>According to my knowledge, FARPOINT default sorting allows upto a max of 2 levels Multi-sort.</FONT></SPAN></P>
    <P><SPAN style="FONT-SIZE:10pt;COLOR:red;FONT-FAMILY:Verdana;mso-bidi-font-size:12.0pt;mso-fareast-font-family:'Times New Roman';mso-bidi-font-family:'Times New Roman';mso-ansi-language:EN-US;mso-fareast-language:EN-US;mso-bidi-language:AR-SA;mso-bidi-font-style:italic;"><FONT color=#000000>Kindly respond...<img src="/emoticons/emotion-1.gif" alt="Smile" /></FONT></SPAN></P>
  • Replied 8 September 2017, 1:57 pm EST

    <P>Yes u r right. Farpoint has some limitations multilevel sort is one of these.</P>
    <P>farpoint support upto max 2 level of sort.</P>
    <P> </P>
  • Replied 8 September 2017, 1:57 pm EST

    <P>If you are asking about multi key sorting you CAN do this in Spread and have as many levels as you wish. For instance,</P>
    <P> </P><FONT size=2>
    <P></FONT><FONT color=#0000ff size=2><FONT color=#0000ff size=2>Dim</FONT></FONT><FONT size=2> si() </FONT><FONT color=#0000ff size=2><FONT color=#0000ff size=2>As</FONT></FONT><FONT size=2> FarPoint.Win.Spread.SortInfo = {</FONT><FONT color=#0000ff size=2><FONT color=#0000ff size=2>New</FONT></FONT><FONT size=2> FarPoint.Win.Spread.SortInfo(0, </FONT><FONT color=#0000ff size=2><FONT color=#0000ff size=2>True</FONT></FONT><FONT size=2>), </FONT><FONT color=#0000ff size=2><FONT color=#0000ff size=2>New</FONT></FONT><FONT size=2> FarPoint.Win.Spread.SortInfo(1, </FONT><FONT color=#0000ff size=2><FONT color=#0000ff size=2>False</FONT></FONT><FONT size=2>), </FONT><FONT color=#0000ff size=2><FONT color=#0000ff size=2>New</FONT></FONT><FONT size=2> FarPoint.Win.Spread.SortInfo(2, </FONT><FONT color=#0000ff size=2><FONT color=#0000ff size=2>True</FONT></FONT><FONT size=2>)}</P>
    <P> </P>
    <P>FpSpread1.ActiveSheet.SortRows(0, 16, si)</P>
    <P> </P>
    <P>This code will sort the first 16 rows in the first 3 columns. Matching values in the A column will be sorted in descending order based on values in the B column and if values in the B column match they will be sorted in ascending order based on values in the C column.</P>
    <P> </P>
    <P> </P></FONT>
  • Replied 8 September 2017, 1:57 pm EST

    <p>This does not seem to work for me.  I have this code:</p><p> </p><p> Dim si() As FarPoint.Win.Spread.SortInfo = New FarPoint.Win.Spread.SortInfo() {New FarPoint.Win.Spread.SortInfo(0, False), New FarPoint.Win.Spread.SortInfo(5, False)}<br><br>    grdHistory.Sheets(0).SortRows(0, grdHistory.Sheets(0).RowCount, si) </p><p> </p><p>Seems like it should sort by column 0 first, the order date, then column 5, the ticket number.  However it seems to just ignore and sort by column 0.  And only shows the sort indicator on col. 0.</p><p>Note that col. 4 is hidden, ticket # is col 5.</p><p> 414835 and 2 are not sorting right.  Ticket number is in the value.<br></p><p> </p><p> </p><p><img src="http://www.imperialsoftware.com/shot1.jpg" title="shot of sorting issue" alt="shot of sorting issue" width="757" height="344"> </p><p><img alt=""><img alt=""> </p><p> </p><p> </p>
  • Replied 8 September 2017, 1:57 pm EST

    <P>Hello,</P>
    <P>We are unable to replicate the issue at out end using spread's version 4.0.3512.2008 as on setting the sortInfo array, we are able to specify multiple criteria for sorting the data.</P>
    <P>Please find attached sample for the same and put values in spread and press button1 to sort them on the basis of sortInfo array . However, after sorting hide the 1st column by pressing button2, then also you will be able to see correct sorted data.</P>
    <P>As far as SortIndicator is concerned, are you setting it using the SortIndicator property of Column set to descending because on sorting data using sortInfo, we never get the sortIndicator.</P>
    <P>Please share your observations regarding the same and also let us know which version of fpSpread are you using? And if possible please attach a zipped sample replicating the issue for us to debug.</P>
    <P>Hope the attached sample will help. Thanks.</P>
    2010/02/sortInfo-Level.zip
Need extra support?

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

Learn More

Forum Channels