DoubleAggregate summary for Sum function is not working when ItemsSource is a DataTable

[Ender Karadag]

DoubleAggregate functions are not shown when ItemsSource is assigned as a DataTable

Here is my simplified code;

        datagrid.Columns.Add(new DataGridNumericColumn() { MappingName = "VALUE", HeaderText = "Value", Width = 180 });

        DataTable DT=new DataTable();
DT.Columns.Add("VALUE",typeof(double));
DT.Rows.Add(15.25);
DT.Rows.Add(12.15);
DT.Rows.Add(1.15);


DataGridTableSummaryRow summaryRow = new DataGridTableSummaryRow();
        summaryRow.ShowSummaryInRow = false;
        summaryRow.SummaryColumns.Add(new DataGridSummaryColumn()
        {
            Name = "TableSummary",
            MappingName = "VALUE",
            Format = "{Sum:C0}",
            SummaryType = SummaryType.DoubleAggregate
        });
        datagrid.TableSummaryRows.Add(summaryRow);

        datagrid.ItemsSource = DT;

When data is created with corresponding ObservableCollection(MyRowItem), Sum value is shown as expected with the same summary creation code.

Am i missing something here?

Best Regards

Ender

[Nirmalkumar Yuvaraj]

Hi Ender,

We have checked your query at our end, and we are able to replicate that issue at our end. We have considered this as a bug and logged a bug report regarding this in our feedback portal. We will fix the reported issue and include the changes in our upcoming weekly patch release, which is expected to be rolled out on May 16, 2023. We will let you know once released, and we appreciate your patience until then. You can also track the status of the bug using the feedback link below. 

Feedback Link: https://www.syncfusion.com/feedback/43251/doubleaggregate-summary-for-sum-function-not-working-with-datatable-as-itemssource

Regards,

Nirmalkumar

[Ender Karadag]

Thanks for the reply. Custom summary with DataGridTableSummaryCellRenderer shows summary rows after manually calculating the aggregate function.

Can the summary row be sticked bottom for winui?  it looks bad while scrolling (espicially down) as if it has a ui bug somewhere.

I have attached a gif file

Thanks in advance

Regards

Ender

Attachment: SFDataGrid_c076cb22.zip

[Nirmalkumar Yuvaraj]

Hi Ender,

This is already a known issue. It occurs when scrolling with the mouse wheel. The issue is happening because the scroll view is bouncing. Unfortunately, the framework does not provide an option to limit this. However, we will explore possible solutions to address the problem from our side. Trying to scroll with the thumb track might be more advantageous.

I hope this helps! Please let us know if you have any further queries on this. We are happy to help you.

Regards,

Nirmalkumar