Skip to content

FormulaFence v0.5.0

Choose a tag to compare

@SybilGambleyyu SybilGambleyyu released this 24 Jul 06:29

Current-row table references

FormulaFence now traces conservative Excel table references that are scoped to the formula row. It resolves unqualified calculated-column forms such as [@[Sales Amount]] and [Sales Amount] only inside a table data cell, plus qualified Sales[@Amount] / Sales[[#This Row],[Amount]:[Rate]] forms when the formula is on that named table's data row.

Header, totals, cross-sheet, ambiguous, malformed, and complex bracket-escape cases remain explicit unresolved-reference coverage notes rather than guessed dependency edges.

Validation: 26 tests pass, lint is clean, GitHub CI passed, the wheel was installed into a fresh virtual environment, and the public Excel Easy structured-reference workbook was re-profiled with zero unresolved tokens.