Expose parsed formula references with values

[robertoGallu]

Hi! First of all, thanks for HyperFormula — it's a super powerful tool.

What I need

I would love to have access to a structured breakdown of a formula’s components, including:

• The formula string itself
• All referenced cells or ranges (with sheet info)
• The current value of each referenced cell - as it was a expleded formula, showing each value

Why?

This would be super useful for:

• Debugging complex formulas
• Creating UI components that show how a formula is resolved
• Highlighting dependencies and cell values interactively, so the user is able the understand the path of the calculation

Current workaround

Right now, I'm doing this manually by:

1. Getting the formula with getCellFormula
2. Using a regex to parse the formula (e.g. [A-Z]+\d+ or Sheet1!A1:B2)
3. Resolving each reference using simpleCellAddressFromString + getCellValue, but I regret when the formula become a little bit much complex.

Thank you for your patience

[sequba]

Hi @robertoGallu, thank you for reaching out.

We know that this feature would be helpful in the community. It was already discussed here.

Unfortunately, implementing it is quite a complex task, and currently, we do not have it on our roadmap. But HyperFormula is an open-source project. If you'd like to contribute to it by working on it yourself, we would be delighted to provide guidance on the current project architecture.

[robertoGallu]

Thank you for your replying! I think it would require a good knowledge of your library and time, that I don't have right now :) thank you anyway for the suggestion i will consider it in the future!