ColumnSummary is always 0

Questions
,
1

hi , i am adding ColumnSummary plugin to my grid , but i still have always 0 as value , also the sum is maked only when i make a cell change value.

this is my config :

this.laGrille = new Handsontable(grilleContainer, {

            stretchH: "all",

            autoColumnSize: true,

            rowHeaders: true,

            manualColumnResize: true,

            autoRowSize: false,

            columnSorting: true,

            licenseKey: "non-commercial-and-evaluation",

            startRows: 1,

            minRows: 1,

            fixedRowsTop: 1,

            filters: true,

            dropdownMenu: true,

            autoWrapRow: true,

            autoWrapCol: true,

            columns: this.definitionOfColumns(),



            columnSummary: \[

                {

                    sourceColumn: 6,

                    type: "sum",

                    destinationRow: 0,

                    destinationColumn: 6,

                    reversedRowCoords: true,

                    // force this column summary to treat non-numeric values as numeric values

                    forceNumeric: true,

                },

                {

                    sourceColumn: 8,

                    type: "sum",

                    destinationRow: 0,

                    destinationColumn: 8,

                    reversedRowCoords: true,

                    // force this column summary to treat non-numeric values as numeric values

                    forceNumeric: true,

                },

            \], … }
2

Hi @majdthb

Thank you for contacting us. We don’t any similar issues reported so can I ask you to send a code demo where the problem can be replicated? In the code snippet you sent the data object is missing. You can use StackBlitz or jsFiddle to do this.

3

Hi @majdthb

do we have any updates here?

4

hi @aleksandra_budnik , now i have the columnSummary showing good values when first time loading data , but when i apply filters , the line of summary is gone

5

I guess that I would also need to ask for a demo as @adrian.szymanski mentioned as we are not able to replicate the issue on our end.

Here’s a 16.2.0 (latest) demo with summaries and filters (and other settings you defined in the first post) applied: Handsontable example - JSFiddle - Code Playground

Even when I filter multiple times I can still see the sum of the rows (hidden by filters and displayed).

demo
demo430×590 24.9 KB

If that helps with the reproduction, I am on Chrome 144/mac OS 26.0

Please let me know if you are able to replicate the issue using my demo. Thanks in advance!

6

Hi @majdthb do we have any updated here?