Skip to content

FormulaFence 0.8.0

Choose a tag to compare

@SybilGambleyyu SybilGambleyyu released this 24 Jul 07:38

FormulaFence 0.8.0 preserves static dependency paths through modern Excel lexical scope.

  • Recognizes ordinary LET bindings as local variables instead of unresolved workbook names.
  • Recognizes inline LAMBDA parameters, including nested lambdas supplied to higher-order functions such as REDUCE.
  • Retains surrounding A1, named-range, formula-defined-name, and supported table dependencies in the graph.
  • Handles nested shadowing and OOXML _xlfn. function prefixes conservatively.
  • Keeps spilled ranges and named LAMBDA/custom-function calls outside the static subset rather than inferring dependencies.

Validation: 45 tests, Ruff, fresh wheel install and CLI impact tracing, two public-workbook regression profiles, and GitHub Actions CI all pass.