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 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.
`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.

This function returns a single value.