hyperformula
hyperformula copied to clipboard
Support dynamic parameters for OFFSET function
Description
The goal of this task is to remove all limitations of the OFFSET function:
- dynamic parameters e.g.
=OFFSET(A1, F16, F17) - passing range as first parameter e.g.
=OFFSET(A1:B1, 0, 0) -
printing OFFSET as a result of
getCellFormula - other limitiations that migh be discovered
Implementation
OFFSET function is hardcoded in HF parser but it should be treated as a regular function. Big refactor is needed for that.
Note
Discussed during HyperFormula Summit: https://docs.google.com/document/d/1xwNKiA4O-gRLNFlw4mu03S3XJXhsR3JzgVeC772ooKc/edit (internal doc)