INFOR.WRITE.VALUE

This function writes a value to the selected cell and, immediately after, retrieves the cell’s value. By default, the Value cell property is used.

INFOR.WRITE.VALUE supports these features:

  • Writeback

    A value can be written back to the specified base cell.

  • Splashing

    If the target cell is aggregated, the value is splashed through the default writeback command, which is allocation with weighted or equal distribution.

  • Specifying a writeback command instead of value, for example #E2000.
Note:  INFOR.WRITE.VALUE writes to a single cell. Multiselection and MDX expressions, except for DefaultMember, are not supported.

Syntax

The function has this syntax:

=INFOR.WRITE.VALUE("value", "data_connection", "cube" {, "cell_property", "cell_coordinate", ... })

This table shows the parameters and their descriptions:

Parameters Description
value Represents an input in any data type or cell-reference. Can be a value or a write-back command string, for example, #W4000 or &E200.
data_connection Represents the database unique name. It is a string or a cell reference.
cube Represents the cube unique name. It is a string or a cell reference.
cell_property Represents the cell property unique name. The default value is value. It is a string or a cell-reference.
cell_coordinate Represents the element unique name and must be provided in its long form. It is any number of strings or cell references, up to Excel's cell limit of 252 characters.

Return values

This function returns a single value.