Skip to content

FormulaFence 0.7.0

Choose a tag to compare

View all tags
@SybilGambleyyu SybilGambleyyu released this 24 Jul 07:17
v0.7.0
5a073be

FormulaFence 0.7.0 resolves the static dependency paths hidden behind formula-defined Excel names.

  • Expands nested workbook-level and sheet-local formula-defined names when their full definition is statically visible and internal.
  • Recognizes named constants without inventing cell dependencies.
  • Supports the existing safe static table subset inside formula-defined names.
  • Keeps relative, cyclic, external, dynamic, 3-D-in-name, and tokenizer-unsupported definitions unresolved instead of guessing.
  • Continues to report changes to a defined-name formula as the existing FF008 workbook-control finding.

Validation: 39 tests, Ruff, a fresh wheel install and CLI impact check, a public 4,228-formula workbook re-profile, and GitHub Actions CI all pass.

Assets 4
Loading