[Formulas] Operations in Handsontable

Tags: #<Tag:0x00007efc72f7f420>
#1

Is there any way to Hansontable support the following operations?

“–” operator: Convert boolean to number

“%” with reference: Hansontable can deal with 100% -> 1, but it is not working with reference like A1 has 100 as it’s value, in another cell user write =A1%, it gives an error

Range of string: In excel, =A1:A4=“test” returns true if there is “test” in any of those cell, but in handsontable it always return false

#2

Hi @nathalia.pissuti

Range of string: In excel, =A1:A4=“test” returns true if there is “test” in any of those cell, but in handsontable it always return false

That is a bug in the current formula plugin. It will be fixed in the new plugin.

Here’s a scope of work that we plan for the new formula plugin https://github.com/handsontable/handsontable/issues/6466 based on the HyperFormula engine https://handsontable.github.io/hyperformula/

1 Like