Proportional spread, equal spread, and repeat

The proportional spread method distributes a specified value among cells proportional to existing cell values. The equal spread method distributes a specified value equally across cells in a view. The repeat method repeats a specified value across cells in a view.

All three of these spreading examples use the same arguments. For more information, see Spreading command codes.

Example: Proportional spread

This example proportionally spreads the value 100 to all leaf cells on the row of insertion, replacing existing cell values.

POST api/v1/Cellsets('AAAAAA')/tm1.Update
{
    "BeginOrdinal":0,
    "Value":"P<>100"
}

Example: Equal spread

This example equally spreads the value 200 to all leaf cells on the column of insertion, adding the product of spreading to existing cell values.

POST api/v1/Cellsets('AAAAAA')/tm1.Update
{
    "BeginOrdinal":0,
    "Value":"S+|^200"
}

Example: Repeat

This example adds the value 50 from all leaf cells left of the insertion point.

POST api/v1/Cellsets('AAAAAA')/tm1.Update
{
    "BeginOrdinal":0,
    "Value":"R+<50"
}