How to search cell's formula

Posted by: xgsoftware on 8 September 2017, 2:41 pm EST

  • Posted 8 September 2017, 2:41 pm EST

    <P>Farpoint Spread for windows form  provide a search function like this:</P>
    <P>public SearchFoundFlags Search( <BR>   int startSheetIndex, <BR>   int endSheetIndex, <BR>   string searchString, <BR>   bool caseSensitive, <BR>   bool exactMatch, <BR>   bool alternateSearch, <BR>   bool useWildcards, <BR>   bool includeCellText, <BR>   bool includeNotes, <BR>   bool includeTags, <BR>   int startRowIndex, <BR>   int startColumnIndex, <BR>   int endRowIndex, <BR>   int endColumnIndex, <BR>   ref int foundSheetIndex, <BR>   ref int foundRowIndex, <BR>   ref int foundColumnIndex <BR>) <BR>however,this function can't search the cell's formula (if  the A1 Cell has a formul equals Sum(1,2)), I input the string "Sum", the search function can not search this formula, can anybody tell me how to search formula  or  can this spread search function provide additional parameter may like "bool includeFormula"</P>
    <P>best regards</P>
  • Replied 8 September 2017, 2:41 pm EST

    <p>Hello,</p><p>Our Search method does not search for formulas. You would need to implement the search for formulas as follows</p><p> Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
    <br>        Dim dataModel As FarPoint.Win.Spread.Model.DefaultSheetDataModel
    <br>        dataModel = FpSpread1.ActiveSheet.Models.Data
    <br>        Dim en As FarPoint.Win.Spread.Model.DefaultSheetDataModel.DefaultSheetDataModelEnumerator
    <br>        en = dataModel.EnumFormulas
    <br>        MsgBox(en.NextNonEmptyRow(-1))
    <br> End Sub</p><p> </p><p>Thanks, <br></p>
Need extra support?

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

Learn More

Forum Channels