FormatOutputBuffer

The FormatOutputBuffer function is for configuring the format of the output data. When FormatOutputBuffer is inserted in the spreadsheet, the FormatOutputBuffer dialog is automatically opened and used to program the function.

Parameter Description
WithErr

Specifies whether the function returns a valid buffer, even if an input error has occurred.

  • 0 = Data is put in the buffer even if an input error has occurred (default).
  • 1 = Function returns #ERR and no data is stored in the buffer.
Format Specifies the Data Type and Element Size in bytes to automatically configure.
Value Specifies a variable-length list of values.
Returns A Buffer data structure containing the formatted data or #ERR if any of the input parameters are invalid.