Skip to content
REFERENCE

U.WEB_CONTROL_LOCATION

Summary

Helper method used to create HTML control indicator that will prompt UWeb to render an interactive checkbox in the indicated report cell

Syntax

=U.WEB_CONTROL_LOCATION(report_range, [control_cell])

Parameters

Parameter Required Description
report_range Yes A reference to a region of the published report starting from the top-left corner and large enough to include all cells that will contain HTML controls when rendered in a browser
[control_cell] No A reference to the specific cell in the report_range that will contain the interactive Web control when rendered in a browser. If a range is provided, then the returned value indicates both the top-left and bottom-right cell in that subrange

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.TWO_WAY_DATA(,,,,U.WEB_CONTROL_LOCATION(G97:H101,H98:H101))

=U.WEB_CONTROL_LOCATION($B$331:$D$336,D333)

=U.WEB_CONTROL_LOCATION($B$331:$D$336,D334)

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.