Search text in Upward

Posted by: mohanmuthusamy on 8 September 2017, 1:12 pm EST

  • Posted 8 September 2017, 1:12 pm EST

    Dear Sir,
                  I write coding to find the text downward and return the row index. but i want to know to search text upward... to search text funtion in Downward as given below


    public int FindTextDownward(FarPoint.Win.Spread.FpSpread fpSpread,string FindString,bool CompleteSearch)
    {
    int RowIndex=0,ColIndex=0,SheetIndex=fpSpread.ActiveSheetIndex;
    if (CompleteSearch)
    {
    SearchFlag=fpSpread.Search(SheetIndex,SheetIndex,FindString,false,false,false,true,true,false,false,0,0,fpSpread.ActiveSheet.RowCount-1,0,ref SheetIndex,ref RowIndex,ref ColIndex);
    if (SearchFlag==FarPoint.Win.Spread.SearchFoundFlags.CellText)

    return RowIndex;

    return RowIndex;
    }
    else
    {
    SearchFlag=fpSpread.Search(SheetIndex,SheetIndex,FindString,false,false,false,true,true,false,false,fpSpread.ActiveSheet.ActiveRowIndex,0,fpSpread.ActiveSheet.RowCount-1,0,ref SheetIndex,ref RowIndex,ref ColIndex);
    if (SearchFlag==FarPoint.Win.Spread.SearchFoundFlags.CellText)
    return RowIndex;
    return RowIndex;
    }
    }
     
  • Replied 8 September 2017, 1:12 pm EST

    It is not possible at this time to do a bottom to top search.  I have asked the developer to add it as an enhancement for a future version.
Need extra support?

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

Learn More

Forum Channels