How to specify the range of the calculation formula

Tags: #<Tag:0x00007efc654ecd58>
#1

Versions 9, 10 and 11 will freeze if the user enters a formula like the one below.
Is there a way around this?

example
= sum (A1: A4) works fine
= sum (A4: A1) raises an exception.

handsontable.full.min.js: 78

    Uncaught Error: Incorrect array size
 at new e (handsontable.full.min.js:78)
 at e.value (handsontable.full.min.js:78)
 at handsontable.full.min.js: 78
 at Array.map (<anonymous>)
 at e.value (handsontable.full.min.js:78)
 at e.value (handsontable.full.min.js:78)
 at e.value (handsontable.full.min.js:78)
 at e.value (handsontable.full.min.js:134)
 at e.value (handsontable.full.min.js: 526)
 at e.value (handsontable.full.min.js: 113)
#3

Hi @daisuke.kobayashi

Here is Aleksandra. I have answered the same question in email. But I assume that it may end up in your spam folder.

The topic on that subject is opened on the Github repository of HyperFormula on its discussion board at https://github.com/handsontable/hyperformula/discussions/832. It is marked as a bug but does not have a set milestone. I will notify you as soon as we fix it.

#4
#5

This feature was added to HyperFormula v2 and now is available in Handsontable - https://github.com/handsontable/hyperformula/discussions/832