handsontable
Add support for INDIRECT
Description
INDIRECT: Return a reference given a string representation of a reference
Specifically I need this in order to be able to have references to relatively positioned cells without using the current cell reference e.g.
=OFFSET(INDIRECT(ADDRESS(ROW(), COLUMN())),0,-1)
In order to do this, I will also need this issue resolving.
Hi @jfstephe
Thank you for your input.
@sequba
Do we have any timeline for this issue? https://github.com/handsontable/hyperformula/issues/1221
@jfstephe, ADDRESS function will most likely be included in the upcoming release of HyperFormula.
It seems to me that it is impossible to implement INDIRECT unless we change the way HyperFormula builds the dependency graph. Currently, HyperFormula collects dependencies during the parsing phase before evaluating any expression. The dependency graph is a core data representation of the engine. We do not plan to rewrite it in the near future.
Related discussion: https://github.com/handsontable/hyperformula/discussions/870
Why do you avoid using the current cell reference in your formula? Perhaps your problem has another solution which doesn't require INDIRECT?
This is indeed a very important feature, and it can avoid complex custom operations.
