You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
@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.
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
The text was updated successfully, but these errors were encountered: