Table Summary abnormal

[yu ma]

• Table Summary – Used to display summary information of table either at top or bottom of SfDataGrid.

 

A single line of content, when each individual input does not press the enter key and clicks on adjacent cells with the mouse, it will not sum up

[yu ma]

A single line of content, when each individual input does not press the enter key and clicks on adjacent cells with the mouse, it will not sum up

demo 

Attachment: WindowsFormsApp6_cdec4060.7z

[Santhosh Govindasamy]

Hi yu ma,

We are currently analyzing the scenario you reported. We need time to validate it, and we will provide an update on or before October 07, 2024.

Regards,
Santhosh.G

[yu ma]

hi Santhosh Govindasamy  

May I ask if you have reproduced my problem

[Santhosh Govindasamy]

Hi yu ma,

Thank you for your response.

 

Yes, we have reproduced the problem on our end. As per our understanding Your reported scenario is summary does not update when clicking the adjacent cell of the currently edited cell. For instance, if you click the next cell in the same column as the current editing cell, the summary will update correctly.

 

In order to further diagnose the problem, we need to examine the issue at the source level to confirm the behavior. As a result, we require some time for validation and will provide an update on or before October 9, 2024.

Regards,
Santhosh.G

[yu ma]

Hello, have you found out what the reason is, or is there something wrong with my usage

[Santhosh Govindasamy]

Hi yu ma,

Thank you for your response.

We found the reason why the summary does not update when editing a cell value and clicking the adjacent cell. When the adjacent cell is clicked during editing, the end edit process is not completed. However, when the edit process is completed by editing the value and clicking the next cell in the same column, the summary updates properly.

We are currently checking the feasibility of your requirement and will need time to validate it. We will provide an update on or before October 11, 2024.

Thank you for your cooperation.

Regards,
Santhosh.G

[Santhosh Govindasamy]

Hi yu ma,

We have checked the reported issue "Table summary does not update properly at runtime when editing a value and clicking the adjacent cell" on our end and it is confirmed as a defect. And We have logged a bug. We will fix this issue and include it in our NuGet release Which is scheduled on November 05, 2024.
 

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

Feedback link-> The table summary does not update properly at runtime, when using DataTable as the data source for the grid in WinForms | Feedback Portal (syncfusion.com)

Note: The provided feedback link is private, and you need to log in to view this feedback.

We will let you know once it is released. We appreciate your patience until then.

Disclaimer: “Inclusion of this solution in the weekly release may change due to other factors including but not limited to QA checks and works reprioritization.”

Regards,
Santhosh.G

[Santhosh Govindasamy]

Hi yu ma,

We are unable to include the fix for this issue in our currently released NuGet package. We will address this issue and include the fix in our first NuGet release after the service pack, which is scheduled for mid-November. We will inform you once it is released. We appreciate your patience in the meantime.

Regards,
Santhosh.G

[Santhosh Govindasamy]

Hi yu ma,

We deeply regret the delay and inconvenience caused.

 

We are unable to include the fix for this issue in our NuGet package released. We will fix this issue and include it in our upcoming Weekly NuGet release scheduled for November 26, 2024.

 

We will let you know once it is released. We appreciate your patience until then.

Regards,
Santhosh.G
 

[Santhosh Govindasamy]

Hi yu ma,

We apologize for any inconvenience caused.

After further analysis, we have found that the reported issue is not an issue. In SfDataGrid, the editing process in the DataTable adheres to the IEditableObject interface, similar to the MS DataGrid. As a result, changes to a column are only committed to the underlying data row once row-wise editing is completed. Consequently, summaries will be updated only after the editing of the entire row is finalized.

To address your requirements, we recommend a workaround utilizing the CurrentCellEndEdit event along with the CommitEdit method. By invoking the CommitEdit method when you move to an adjacent cell within the same row after editing, you can ensure that edited values are committed, which will allow the summaries to update correctly.

Kindly refer the below code snippets for `CurrentCellEndEdit ` Event.

sfDataGrid1.CurrentCellEndEdit += SfDataGrid1_CurrentCellEndEdit;

 

 private void SfDataGrid1_CurrentCellEndEdit(object sender, Syncfusion.WinForms.DataGrid.Events.CurrentCellEndEditEventArgs e)

 {

     var row = sfDataGrid1.View.Records.GetItemAt(e.DataRow.RowIndex - 1);

     dt.Rows[e.DataRow.RowIndex - 1]["AB"] = int.Parse(dt.Rows[e.DataRow.RowIndex - 1]["A"].ToString()) + int.Parse(dt.Rows[e.DataRow.RowIndex - 1]["B"].ToString());

 

     if (sfDataGrid1.View.IsEditingItem)

         sfDataGrid1.View.CommitEdit();

 }

We have modified the sample according to your requirements and attached it for your reference, If you have any further questions or need additional assistance, please feel free to reach out.

Regards,

Santhosh.G

Attachment: SfDataGrid_Sample_3ac6d596.zip