Filtering And Table Summary Rows Not working when sfdatagrid has preview rows

[mahendra]

Hi,

I was using preview rows in sfdatagrid and when i tried filtering i throws index out of bound error.

Same Error with the summary rows for columns.

arameter name: index</Message><StackTrace>   at System.ThrowHelper.ThrowArgumentOutOfRangeException(ExceptionArgument argument, ExceptionResource resource)
   at System.Collections.Generic.List`1.get_Item(Int32 index)
   at Syncfusion.WinForms.DataGrid.SpannedDataRow.CreateColumn(Int32 index, Int32 widthIncrementation)
   at Syncfusion.WinForms.DataGrid.SpannedDataRow.OnGenerateVisibleColumns(VisibleLinesCollection visibleColumnLines)
   at Syncfusion.WinForms.DataGrid.RowGenerator.CreateTableSummaryRow(Int32 rowIndex, VisibleLinesCollection visibleColumns, VerticalPosition position)
   at Syncfusion.WinForms.DataGrid.RowGenerator.UpdateRow(IEnumerable`1 rows, Int32 rowIndex)
   at Syncfusion.WinForms.DataGrid.RowGenerator.EnsureRows(VisibleLinesCollection visibleRows)
   at Syncfusion.WinForms.DataGrid.GridPainter.EnsureItems(Boolean ensureColumns)
   at Syncfusion.WinForms.DataGrid.GridPainter.OnPaint(PaintEventArgs e, Size clientSize)
   at Syncfusion.WinForms.DataGrid.TableControl.OnPaint(PaintEventArgs e)
   at System.Windows.Forms.Control.PaintWithErrorHandling(PaintEventArgs e, Int16 layer)
   at System.Windows.Forms.Control.WmPaint(Message&amp;amp; m)
   at System.Windows.Forms.Control.WndProc(Message&amp;amp; m)
   at Syncfusion.WinForms.Controls.SfScrollControl.WndProc(Message&amp;amp; msg)
   at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message&amp;amp; m)
   at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message&amp;amp; m)

Parameter name: index
   at System.ThrowHelper.ThrowArgumentOutOfRangeException(ExceptionArgument argument, ExceptionResource resource)
   at System.Collections.Generic.List`1.get_Item(Int32 index)
   at Syncfusion.WinForms.DataGrid.SpannedDataRow.CreateColumn(Int32 index, Int32 widthIncrementation)
   at Syncfusion.WinForms.DataGrid.SpannedDataRow.OnGenerateVisibleColumns(VisibleLinesCollection visibleColumnLines)
   at Syncfusion.WinForms.DataGrid.RowGenerator.CreateTableSummaryRow(Int32 rowIndex, VisibleLinesCollection visibleColumns, VerticalPosition position)
   at Syncfusion.WinForms.DataGrid.RowGenerator.UpdateRow(IEnumerable`1 rows, Int32 rowIndex)
   at Syncfusion.WinForms.DataGrid.RowGenerator.EnsureRows(VisibleLinesCollection visibleRows)
   at Syncfusion.WinForms.DataGrid.GridPainter.EnsureItems(Boolean ensureColumns)
   at Syncfusion.WinForms.DataGrid.GridPainter.OnPaint(PaintEventArgs e, Size clientSize)
   at Syncfusion.WinForms.DataGrid.TableControl.OnPaint(PaintEventArgs e)
   at System.Windows.Forms.Control.PaintWithErrorHandling(PaintEventArgs e, Int16 layer)
   at System.Windows.Forms.Control.WmPaint(Message&amp;amp; m)
   at System.Windows.Forms.Control.WndProc(Message&amp;amp; m)
   at Syncfusion.WinForms.Controls.SfScrollControl.WndProc(Message&amp;amp; msg)
   at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message&amp;amp; m)
   at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message&amp;amp; m)
   at System.Windows.Forms.NativeWindow.DebuggableCallback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
An unhandled exception of type 'System.ArgumentOutOfRangeException' occurred in mscorlib.dll
Index was out of range. Must be non-negative and less than the size of the collection.

[Saravanan Ayyanar]

Hi Mahendra, 

 

Thank you for using Syncfusion controls. 

 

Query 1: 

 

We have checked your reported scenario “Filtering not worked when SfDataGrid has preview rows” with provided your call stack on our end, but the issue is not reproduced and its work as expected on our end. Please find the below sample link. 

 

Sample Link: 

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

 

Note : We have tested this sample in our Syncfusion version 17.4.0.39. 

 

Please check the sample and let us know if you still facing the same issue? If not, please modify the sample based on your scenario and revert us back. It will help us to investigate further and provide earlier prompt solution. 

 

Query 2: 

 

We can replicate the reported issue “Table summary row with ShowSummaryInRow as false not worked SfDataGrid has preview rows” with provided your both call stack on our end 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. 

[mahendra]

Thanks for the sample code,

As I have tested given demo and it is working fine with filters.

Currently I am using 17.2.0.34 version.

Can I get a patch for this version. because updating to latest version is quite tough.

Filters with 17.2.0.34 is Not Working

Thank You

[mahendra]

And It seems i have found another problem .

Then Sfdatagrid has more than one table summary rows and table has preview rows .

Filters throws index out of bound.

Can You please help me out with this.

[Saravanan Ayyanar]

Hi Mahendra, 

 

Thank you for your update. 

 

Query 1: 

We have checked your reported scenario “Filtering not worked when SfDataGrid has preview rows” on our end, but the issue not reproduced and its works as expected on our end. Please find the below sample link. 

 

Sample Link: 

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

 

NOTE: We have checked Syncfusion version as 17.2.0.34. 

 

Please check the sample and let us know if you still facing the same issue? If not, please modify the sample based on your scenario and revert us back. It will help us to investigate further and provide earlier prompt solution. 

 

Query 2: 

 

We can replicate the reported issue “More than one Table Summary row with ShowSummaryInRow as true not worked SfDataGrid has preview rows” on our end and created bug report for the same. 

 

We will fix both reported issue “More than one Table Summary row with ShowSummaryInRow as true not worked SfDataGrid has preview rows” and “Table summary row with ShowSummaryInRow as false not worked SfDataGrid has preview rows” and provide the patch for this issue in your version 17.2.0.34 on February 7^th, 2020. 

 

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

 

Feedback Link:  

https://www.syncfusion.com/feedback/11463/argumentoutofrangeexception-is-occurred-when-loaded-table-summary-for-column-with 

     

We appreciate your patience until then. 

Regards, 

Saravanan A.   

[Saravanan Ayyanar]

Hi Mahendra, 

 

Query 2: 

 

Thanks for your patience. 

 

The issue with "ArgumentOutOfRangeException is thrown when preview row and table summary are added" has been fixed and the patch for this fix can be downloaded from the following location.  

 

Recommended approach - exe will perform automatic configuration 

Please find the patch setup from below location: 

http://syncfusion.com/Installs/support/patch/17.2.0.34/1088680/F150853/SyncfusionPatch_17.2.0.34_1088680_2072020082602848_F150853.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 below location: 

http://syncfusion.com/Installs/support/patch/17.2.0.34/1088680/F150853/SyncfusionPatch_17.2.0.34_1088680_2072020082602848_F150853.zip 

 

Assembly Version: 17.2.0.34 

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.6 

Eg : $system drive:\Program Files\Syncfusion\Essential Studio\17.2.0.34\precompiledassemblies\17.2.0.34\4.6 

 

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 :  

You can change how you receive bug fixes by navigating to the following link and updating your preferences. 

 

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

 

Disclaimer :  

Please note that we have created this patch for version 17.2.0.34 specifically to resolve the following issue reported in this Forum 150853. 

 

If you have received other patches for the same version for other products, please apply all patches in the order received. 

 

Regards, 

Saravanan A.