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 works correctly only when the Writeback Behavior setting is enabled in EPM Administration. By default, writeback mode is disabled for all users. Only the administrator can enable and disable the ability to write values for specific users, user groups, application roles, and all users. See "Application settings" and "Entering and exiting writeback mode".

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 writeback 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. To write cell notes, use the `note` value.
`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.