Dynamic Ranges and Spill Results
Summary
Runline workflows handle changing data shapes through spill results, range references, padding, and controlled paste targets.
Core Idea
Choose whether a formula should return an array, refer to an existing range, or mutate a reserved output range. These modes have different recalculation and overwrite behavior.
How It Works
U.REGION discovers a populated footprint, U.RANGE_REF passes a range reference, U.PAD stabilizes a changing array footprint, and U.PASTE writes values into an explicit target.
Why It Matters
A receiving range that can grow but cannot shrink leaves stale rows. A spill range without reserved space can collide with unrelated cells. Making the output mode explicit prevents both failures.
In Excel (Runline U)
Reserve a clear output area and keep transformation formulas outside it. For paste-based flows, size or clear the entire previous footprint when the incoming report contracts.
Common Patterns
- Spill a read-only report into an empty area.
- Pad a variable result when downstream formulas expect a stable footprint.
- Paste into a controlled range when formats, adjacent formulas, or shrinking output must be managed.
Misconceptions
- A dynamic array automatically grows and shrinks, but a pasted range does not.
- A range reference is not the same as copying the range's current values.