Skip to content
REFERENCE

U.PAD

Summary

Applies values to data to ensure it is at least as large as the calling formula array to prevent Excel from automatically filling extra cells with #N/A errors. Also supports auto-resizing array formulas and removing cells to avoid #SPILL errors

Syntax

=U.PAD(data, [dynamic__or__padding_value], [fit_spill_range])

Parameters

Parameter Required Description
data Yes The data to be padded. If only a valid topic is provided, the first page of that report will be used unless there is a spaced pipe and page indicator following the topic (e.g.
[dynamic] OR [padding_value] No If set to TRUE then array formula expands and contracts dynamically to fit the data; additional columns allow scope of expansion to be controlled. If set to a value other than TRUE that value is used to fill extra cells in the calling range, otherwise the padding is an empty string
[fit_spill_range] No If set to TRUE the returned data will be limited to the available spill range. To maximize the number of columns instead of rows, provide a 2nd value and also set that to TRUE. If set explicitly to FALSE and 2nd param is TRUE then data in target range is overwritten by formula

Behavior

The documented public interface is supported by the current U Add-in source signature and the maintained Usage Examples workbook. Optional parameters are shown in square brackets in the syntax above; omit the brackets when entering a formula.

Return Value

Returns the function result or action status described by the formula and parameters above. The maintained sources do not define a narrower, stable return contract for this function.

Examples

=U.PAD(U.SUBRANGE(U.SPLIT(B4:D211,{"U.","("}),,2))

=U.PAD(U.WORKSHEET_NAME("*"))

=U.PAD(U.VAGGREGATE(B7:I20,X50:X54,Y50:Y54,,,TRUE,TRUE))

Notes

  • Formula examples are preserved from maintained workbook usage and normalized to the current U. prefix.
  • Complete formulas demonstrate working patterns; they do not imply that undocumented option values are supported.
  • Where maintained sources do not specify every accepted value, default, or error message, this page does not infer one.
  • For functions that perform actions, use a visible trigger or supported block/throttle parameter to avoid unintended repetition during recalculation.