Using structured references in Handsontable

Tags: #<Tag:0x00007efc64711e40>
#1

Is it possible at this moment to somehow achieve this?
Calculate value from the table formula?

#2

Hi @terabaitas,

We do not support structured references in the same way Excel do it. However, you can use our ColumnSummary plugin to achieve similar behaviour: https://handsontable.com/docs/8.3.1/demo-summary-calculations.html

If you need to use formulas, you can wait for the official implementation of our new formulas engine, Hyperformula, which will support named ranges: https://handsontable.github.io/hyperformula/guide/named-ranges.html#examples

#3

Hello piotr,
thank you,
I finished up with a solution to convert structures into simple formulas with column and row values.
so “=TABLE1[[#THIS ROW][a]” => “=A1”

#4