Skip to content
REFERENCE

U.GZIP

Summary

Compresses or decompresses specified value using the gzip algorithm and returns the result as a Base64-encoded string

Syntax

=U.GZIP(input, [unzip], [ignore_errors])

Parameters

Parameter Required Description
input Yes The value to be zipped or unzipped. If a multi-cell range is provided the cells will be concatenated before being processed. When zipping, if the input is already gzipped then it is returned unchanged
[unzip] No If set to TRUE then the input is unzipped instead of zipped
[ignore_errors] No If set to TRUE then any errors in the input range are ignored when zipping, and if unzipping then if unable to unzip the input is returned instead of an error

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.GZIP(B5)

=U.GZIP(GZIP,TRUE)

=U.GZIP(B18:C20)

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.