SummaryRow and Hyperformula

[haraleib]

I have noticed that when using columnSummary, there is no result calculated in the cell which should calculate some result for a column with formulas.

Do I miss something here if I work with Hyperformula?
As a workaround I could skip the Handsontable columnSummary and provide my own summary filled with formulas which calculate the sum of the column.

The seetings of interest for the hot and hf instances (for the last column there should be a sum calculated)

UI

[AMBudnik]

Hi @haraleib

the SummaryRow in not a method name in Handsontable nor HyperFormula. Do you mean the columnSummary (https://handsontable.com/docs/9.0.0/demo-summary-calculations.html)? If you could share a demo that would definitely help me to solve the case.

[haraleib]

My bad. I have updated the title and description and changed it to columnSummary.

Here the jsfiddle example:
https://jsfiddle.net/awy9d43f/1/

[AMBudnik]

The summary calculations are not formulas, they won't appear in the formula stack.

And there is a difference between the demo (calculates properly and returns hot.getData() as it should) and the images where the value in the last row is not calculated. Do you mean that previously in your code you have also used the summaryRow and replacing it with columnSummary fixed the result?

[haraleib]

The summary calculations are not formulas, they won't appear in the formula stack.

Yes, I thought so, but I guess I can achieve the same result without the columnSummary configuration, if I provide a normal row instaed of the columnSummary row which calculates the result with formulas if it turns out that it is a bug.

I wanted to share some data of interest for you with the image I provided.
In my code I also use columnSummary. The summaryRow I used here in this discussion was a typo.

Nevertheless, in the jsfiddle example I provided the result is not calculated for the first column (which consists of formulas). Do I make something wrong here?

[AMBudnik]

Sorry @haraleib I did not see that.

The Formulas and columnSummary collaboration is not yet supported in the Handsontable v9.0.0.

Here https://github.com/handsontable/handsontable/projects/2 is a full list of changes made for the plugin and in the Rejected/On hold column (where we also have columnSummary) we listed all the topics that had to be postponed. We will provide more changes and updates in the future.

[haraleib]

Ok, so everything is clear for me. Thank you :)

[AMBudnik]

You're welcome 👋

If you'd have any questions feel free to ask.
HyperFormula is still a fresh thing, and we may miss some info in the docs or examples, so all the feedback is priceless.

[julianaiglsdorfer]

Hello,

i just want to ask you if this issue/problem is still on your roadmap?

We have the same problem with one of our users who also wants to calculate a sum for fields that are calculated from a formula.
Would be nice if you could give me an update about the status.

Thanks!

[adrianszymanski89]

Hi @julianaiglsdorfer

Thank you for contacting us. We have this issue reported internally. I'll update you as soon as we have the fix done.

[julianaiglsdorfer]

Thank you a lot for your effort. Do you have an approximate implementation date or time frame?

[adrianszymanski89]

Hi @julianaiglsdorfer

Not yet. I will let you know as soon as we have it fixed.

[julianaiglsdorfer]

Hello @adrianszymanski89 do you have some information for me about this topic?

Are there any efforts to fix this issue?

Thanks in advance!

[sequba]

@julianaiglsdorfer, this is a feature request for the Handsontable product and should be discussed with their team within Handsontable repository.

However, it seems this feature may already have been shipped in Handsontable 18.0.0 via this pull request. @adrianspdev can you confirm that?

[adrianspdev]

Confirmed. This was fixed in Handsontable 18.0.0 via handsontable/handsontable#12489 (fixes handsontable/handsontable#10980).

Before 18.0.0, columnSummary read cell values from the source data, so a cell containing =A1+B1 contributed the raw formula string instead of its calculated result and was skipped from the calculation. Since 18.0.0:

• columnSummary reads the value calculated by the formulas plugin, so sum, min, max, average, and count include formula cells.
• Summaries are refreshed automatically when HyperFormula recalculates a referenced cell, so they stay in sync after edits.

Changelog entry: https://github.com/handsontable/handsontable/blob/master/CHANGELOG.md#1800---2026-06-30

To get this, upgrade handsontable to 18.0.0 or later. If you still see the issue on 18.x, please open an issue in the Handsontable repository with a reproducible demo and we will take a look.

[sequba]

Thanks @adrianspdev. I'm closing this discussion.