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.