Spreading command codes

The following table provides information about the spreading command codes.

Note:

1. The default data action is Replace. The spreading syntax uses the tilde character (~) to denote the Subtract data action, and the plus symbol (+) to denote the Add data action.

2. Straight Line and Growth % methods can be used across a single row or column. Rectangular ranges are not allowed. Direction combinations of up and down (^|) or left and right(<>) are the only combinations allowed for these spreading methods.

This table describes the spreading command code arguments.

Data Spreading Method	Code Update Action Direction Indicators Required Method Parameters	Example
Proportional Spread	P +, ~ \|, ^, <, > Value to be spread	P<>100 This example proportionally spreads the value 100 to all leaf cells on the row of insertion, replacing existing cell values.
Equal Spread	S +, ~ \|, ^, <, > Value to be spread	S+\|^200 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.
Repeat	R +, ~ \|, ^, <, > Value to be spread	R~<50 This example subtracts the value 50 from all leaf cells left of the insertion point.
Percent Change	P% +, ~ \|, ^, <, > Percentage	P%+\|^<>10 This example applies a percent change of 10% to all leaf values in the view and adds the product to existing cell values.(It increments all leaves in the view by 10%.)
Straight Line	SL +, ~ \|, ^, <, > ∗∗ Start Value and End Value	SL>100:200 This example applies Straight Line spreading to replace all leaf values right of the point of insertion, using a start value of 100 and an end value of 200.
Growth %	GR +, ~ \|, ^, <, > ∗∗ Start Value and Growth Percentage	GR\|300:25 This example applies a 25% growth percentage to the starting value of 300 and replaces all leaf values below the point of insertion.
Clear	C N/A \|, ^, <, > N/A	C\|^<> This example clears values from all cells in the view.
Relative Proportional Spread	RP +, ~ N/A Value to be spread	RP+500 Distributes the value 500 proportionally across all leaf cells of the consolidation.
Relative Percent adjustment	R% +, ~ N/A Percentage adjustment	R%+20 For each leaf cell in the consolidation, take the value of the reference cell's analagous leaf cell, add 20%, and add the total to the leaf cell in the current consolidation.
Repeat Leaves	LR +, ~ The default is to update populated cells. * means update all leaf cells Value to be spread	LR+*200 Add 200 to all populated leaves in the current consolidation.
Equal spread Leaves	LS +, ~ The default is to update populated cells. * means update all leaf cells Value to be spread	LS+*200 Spread 200 to all leaves in the current consolidation.
Leaf Hold	H N/A \|, ^, <, > N/A	H<> This example holds all leaf cells on the row of insertion.
Release Leaf Hold	RH N/A \|, ^, <, > N/A	RH<> This example releases all leaf holds on the row of insertion.
Consolidation Hold	HC N/A \|, ^, <, > N/A	HC<> This example holds all consolidated cells on the row of insertion.
Release Consolidation Hold	RC N/A \|, ^, <, > N/A	RC<> This example releases all consolidated cells on the row of insertion.

Data Spreading Method

Code

Update Action

Direction Indicators

Required Method Parameters

Example

Proportional Spread

+, ~

|, ^, <, >

Value to be spread

P<>100

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

Equal Spread

+, ~

|, ^, <, >

Value to be spread

S+|^200

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.

Repeat

+, ~

|, ^, <, >

Value to be spread

R~<50

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

Percent Change

+, ~

|, ^, <, >

Percentage

P%+|^<>10

This example applies a percent change of 10% to all leaf values in the view and adds the product to existing cell values.(It increments all leaves in the view by 10%.)

Straight Line

+, ~

|, ^, <, > ∗∗

Start Value and End Value

SL>100:200

This example applies Straight Line spreading to replace all leaf values right of the point of insertion, using a start value of 100 and an end value of 200.

Growth %

+, ~

|, ^, <, > ∗∗

Start Value and Growth Percentage

GR|300:25

This example applies a 25% growth percentage to the starting value of 300 and replaces all leaf values below the point of insertion.

Clear

N/A

|, ^, <, >

N/A

C|^<>

This example clears values from all cells in the view.

Relative Proportional Spread

+, ~

N/A

Value to be spread

RP+500

Distributes the value 500 proportionally across all leaf cells of the consolidation.

Relative Percent adjustment

+, ~

N/A

Percentage adjustment

R%+20

For each leaf cell in the consolidation, take the value of the reference cell's analagous leaf cell, add 20%, and add the total to the leaf cell in the current consolidation.

Repeat Leaves

+, ~

The default is to update populated cells.

* means update all leaf cells

Value to be spread

LR+*200

Add 200 to all populated leaves in the current consolidation.

Equal spread Leaves

+, ~

The default is to update populated cells.

* means update all leaf cells

Value to be spread

LS+*200

Spread 200 to all leaves in the current consolidation.

Leaf Hold

N/A

|, ^, <, >

N/A

H<>

This example holds all leaf cells on the row of insertion.

Release Leaf Hold

N/A

|, ^, <, >

N/A

RH<>

This example releases all leaf holds on the row of insertion.

Consolidation Hold

N/A

|, ^, <, >

N/A

HC<>

This example holds all consolidated cells on the row of insertion.

Release Consolidation Hold

N/A

|, ^, <, >

N/A

RC<>

This example releases all consolidated cells on the row of insertion.