Add support for INDIRECT

[jfstephe]

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.

Open Formula

[adrianszymanski89]

Hi @jfstephe

Thank you for your input.

@sequba

Do we have any timeline for this issue? #1221

[sequba]

@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: #870

Why do you avoid using the current cell reference in your formula? Perhaps your problem has another solution which doesn't require INDIRECT?

[171h]

This is indeed a very important feature, and it can avoid complex custom operations.

[AMBudnik]

Ref: #1388