Scrolling to Searched text row

[Peter Rutterford]

I am trying to scroll into view the row which contains the data on which I am searching. For some reason the row does not come into view when I move to the current cell - it scrolls the rows but does not display the row with the searched in text.

        myGrid.SearchController.SearchColumns.Add("Description")
        myGrid.SearchController.Search(Search.Text)
        myGrid.SearchController.FindNext(Search.Text)
        Dim temp As Syncfusion.WinForms.GridCommon.ScrollAxis.RowColumnIndex = myGrid.SearchController.CurrentRowColumnIndex
        temp.RowIndex += 2
        temp.ColumnIndex = 1
        myGrid.MoveToCurrentCell(temp)
        temp.RowIndex -= 2
        myGrid.MoveToCurrentCell(temp)

As you can see from my code the workaround is to move beyond the row containing the searched text then moving back to the required row. This obviously will not work if the text being searched for is the last row in the grid.

[Saravanan Ayyanar]

Hi Peter Rutterford, 

 

Thank you for using Syncfusion controls. 

 

We have checked your provided code example. We suspect that, your requirement is that current cell have to move  based on the Find Next Search text. You can achieve this by using the SfDataGrid.SearchController.CurrentRowColumnIndex property. Please refer the below code snippet.   

 

AddHandler button1.Click, AddressOf button1_Click 

 

Private Sub button1_Click(ByVal sender As Object, ByVal e As EventArgs) Handles button1.Click 

                Me.sfDataGrid1.SearchController.SearchColumns.Add("ProductName") 

                Me.sfDataGrid1.SearchController.Search(textBox1.Text) 

                Me.sfDataGrid1.SearchController.FindNext(textBox1.Text) 

                Me.sfDataGrid1.MoveToCurrentCell(Me.sfDataGrid1.SearchController.CurrentRowColumnIndex) 

End Sub 

 

Sample Link: 

https://www.syncfusion.com/downloads/support/directtrac/general/ze/VBDataGrid1098445022 

 

UG Link: 

https://help.syncfusion.com/windowsforms/datagrid/search#move-current-cell-to-the-next-match 

 

If we have misunderstood your requirement, please provide more information regarding the requirement. This would help us to proceed further. 

 

Regards, 

Saravanan A. 

[Peter Rutterford]

Thanks for your reply. I have tried your suggestion and also

        myGrid.TableControl.ScrollRows.ScrollInView(myGrid.SearchController.CurrentRowColumnIndex.RowIndex)
        myGrid.TableControl.UpdateScrollBars()

This does not scroll into view correctly either. It may work on the first text search and possibly the second but fails to bring it into view afterwards for any other occurrences. I do not know if it is relevant but I have text wrapping on the column being searched and use

    Private Sub MatsListGrid_QueryRowHeight(ByVal sender As Object, ByVal e As QueryRowHeightEventArgs) Handles myGrid.QueryRowHeight
        Dim autoFitOptions As New RowAutoFitOptions()
        'To get the calculated height from GetAutoRowHeight method.
        Dim autoHeight As Integer

        If myGrid.AutoSizeController.GetAutoRowHeight(e.RowIndex, autoFitOptions, autoHeight) Then
            If autoHeight > 24 Then
                e.Height = autoHeight
                e.Handled = True
            End If
        End If

    End Sub

to adjust the height of the row.

The search works perfectly in that it finds all occurrences of the text being searched, it just does not display them all in view.

[Saravanan Ayyanar]

Hi Peter Rutterford, 

 

Thank you for your update. 

 

We can replicate the reported issue and created the bug report for the same. Can you please specify your current Syncfusion version so that We will provide a patch for that version.  

 

Regards, 

Saravanan A. 

[Peter Rutterford]

Hi Saravan

Thanks for your reply. I am pleased you have managed to replicate the issue. The version I experienced it in was 17.4.0.39.

Thanks.

Peter

[Saravanan Ayyanar]

Hi Peter Rutterford, 

 

Thank you for your update. 

 

We can replicate the reported issue “Searched text is not displayed in view while clicking on FindNext button two or more time” on our end and created bug report for the same. 

 

We will fix the reported issue and provide the patch for this issue in your version 17.4.0.39 on February 12^th, 2020. 

 

You can track the status of this report through the following feedback link, 

 

Feedback Link:  

https://www.syncfusion.com/feedback/11599/searched-text-not-display-in-view-while-click-findnext-button-two-or-more-time 

     

We appreciate your patience until then. 

 

Regards, 

Saravanan A. 

[Susmitha Sundar]

Hi Peter, 

 

Thank you for your patience. 

 

We have fixed the issue “Searched text is not displayed in view while clicking on FindNext button two or more time” and you can download the patch from following location.  

  v17.4.0.39 

Recommended approach – exe will perform automatic configuration       

Please find the patch setup here:   

  

http://syncfusion.com/Installs/support/patch/17.4.0.39/879468/F150961/SyncfusionPatch_17.4.0.39_879468_2122020082221386_F150961.exe 

               

Advanced approach – use only if you have specific needs and can directly replace existing assemblies for your build environment                        

Please find the patch assemblies alone from:  

http://syncfusion.com/Installs/support/patch/17.4.0.39/879468/F150961/SyncfusionPatch_17.4.0.39_879468_2122020082221386_F150961.zip 

 

Please find the Nugets from the below location:      

http://syncfusion.com/Installs/support/patch/17.4.0.39/879468/F150961/SyncfusionNuget_17.4.0.39_879468_2122020082221386_F150961.zip 

 

  

Assembly Version: 17.4.0.39 

Installation Directions:  

This patch should replace the files “Syncfusion.SfDataGrid.WinForms” under the following folder.  

$system drive:\ Files\Syncfusion\Essential Studio\$Version # \precompiledassemblies\$Version#\4.0  

Eg : $system drive:\Program Files\Syncfusion\Essential Studio\17.4.0.39 

\precompiledassemblies\17.4.0.39 

\4.0  

   

To automatically run the Assembly Manager, please check the Run assembly manager checkbox option while installing the patch. If this option is unchecked, the patch will replace the assemblies in precompiled assemblies’ folder only. Then, you will have to manually copy and paste them to the preferred location, or you will have to run the Syncfusion Assembly Manager application (available from the Syncfusion Dashboard, installed as a shortcut in the Application menu) to re-install assemblies.  

   

Note:  

To change how you receive bug fixes, ask your license management portal admin to change your project’s patch delivery mode.  

   

https://www.syncfusion.com/support/directtrac/patches  

   

Disclaimer:  

If you have received other patches for the same version for other products, please apply all patches in the order received. Please note that we have created this patch for version 17.4.0.39 

specifically, to resolve the following issue reported in the forum 150961. This fix will be included in our Volume 1 release which is expected on end of March 2020.  

 

Regards, 

Susmitha S 

[Peter Rutterford]

Hi Susmitha S

I have installed the patch and it works perfectly. Your service is excellent.

Thank you very much.

Regards

Peter

[Farjana Parveen Ayubb]

 

Hi Peter,  

 

Thanks for the update. 

 

We are glad to know that the reported problem has been resolved at your end. Please let us know if you have any further queries on this. We are happy to help you. 

 

Regards, 

Farjana Parveen A