Skip to content
REFERENCE

U.HAPPEND

Summary

Dynamically appends ranges of data together. (All params are individually optional, but at least 1 must be set to get any result)

Syntax

=U.HAPPEND(top_range_left_range_config, range, range, range, range, range, range, range, range, range)

Parameters

Parameter Required Description
top_range / left_range / config No The range or ranges placed at the top (or left for HAPPENED) of the result or config details on how to process subsequent ranges. If only valid topics are provided, the all pages of reports will be used unless there is a spaced pipe and page indicator following a topic (e.g.
range No The next range or ranges to be appended. Handling of valid topics is same as for top_range
range No The next range or ranges to be appended. Handling of valid topics is same as for top_range
range No The next range or ranges to be appended. Handling of valid topics is same as for top_range
range No The next range or ranges to be appended. Handling of valid topics is same as for top_range
range No The next range or ranges to be appended. Handling of valid topics is same as for top_range
range No The next range or ranges to be appended. Handling of valid topics is same as for top_range
range No The next range or ranges to be appended. Handling of valid topics is same as for top_range
range No The next range or ranges to be appended. Handling of valid topics is same as for top_range
range No The next range or ranges to be appended. Handling of valid topics is same as for top_range

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.HFILTER(U.HAPPEND(B216:C218,(B221:C223,B226:C229)))

=U.SPLIT(B24,",",,U.HAPPEND(B26,TRUE))

=U.SPLIT(B24,",",,U.HAPPEND(B26,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.