02paru
(02paru)
October 23, 2018, 5:16am
1
Hi Team,
I am using angular in my project.
I am using Column summary in the settings as follows
columnSummary : [ {
destinationColumn: 0,
destinationRow: 0,
type: ‘sum’
}]
For the first time it is getting applied correctly. But as soon as the data of the table is changed and then If I render the hottable by using hotTable.render(), Column Summary is not getting applied automatically. Could you please look into this issue in priority.
Hi @02paru
please share a demo where this issue will be replicable. I will look into this.
02paru
(02paru)
October 23, 2018, 7:15am
4
Hi ALeksandra,
The issue is same
opened 02:58PM - 22 Jun 16 UTC
bug
Core: Update settings
Summary calculations
Reported
Hello,
is it possible to call column Summary after loadData?
Thanks
JS FIddle For it:
Is this fixed and is there a solution or work around for this
Thank you for finding the corresponding issue.
I will let you know as soon as we fix https://github.com/handsontable/handsontable/issues/3597
02paru
(02paru)
October 23, 2018, 8:52am
6
Hi Aleksandra,
Is there any work around for this as this is an urgent functionality?
Thanks,
Parul Gautam
Yes, @02paru
You can use formulas or native Math function instead.
02paru
(02paru)
October 23, 2018, 6:24pm
8
Hi @aleksandra_budnik ,
Could you please provide an example to add a row having average values of all the columns(i.e… Add values from average formula on button click).
Thanks,
Parul Gautam
If you have a fixed number of rows you can use this code https://jsfiddle.net/ogk2safh/
mehdiraza
(Mehdiraza)
December 2, 2022, 1:37pm
10
I am also facing same issue, once the data is changed the column summary doesn’t get updated. Which hook or function to use for this ?
Thanks
Hi @mehdiraza
This issue isn’t solved yet, we will update this topic as soon as we finish it.
mehdiraza
(Mehdiraza)
December 5, 2022, 12:04pm
12
What is the workaround or we should implement a custom row for that instead of using this columnSummary feature at first place?
Thanks
Hi @aleksandra_budnik
I think the workaround that @aleksandra_budnik posted is still a good solution. I’ve updated the example to current version of Handsontable:
https://jsfiddle.net/aszymanski/2q6371bp/