BoldDeskWe are launching BoldDesk on Product Hunt soon. Learn more & follow us.
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
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
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
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