Data spreading and hold syntax reference table

The following table describes the data spreading and hold methods that you can apply with the syntax.

Table 1. Data spreading and hold syntax
Method	Code	Required Method Parameters	Data Action (Optional) *	Example
Proportional Spread	P	Value to be spread	+, ~	P<>100 Proportionally spreads the value 100 to all leaf cells, and replaces the existing cell values.
Equal Spread	S	Value to be spread	+, ~	S+200 Equally spreads the value 200 to all leaf cells, and adds the product of spreading to the existing cell values.
Repeat	R	Value to be spread	+, ~	R~50 Subtracts the value 50 from all leaf cells.
Percent Change	P%	Percentage	+, ~	P%+10 Applies a percent change of 10% to all leaf values, adds the product to the existing cell values, and increments all leaves by 10%.
Straight Line	SL	Start Value and End Value	+, ~	SL100:200 Replaces all leaf values, with a start value of 100 and an end value of 200.
Growth %	GR	Start Value and Growth Percentage	+, ~	GR300:25 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 Clears values from all cells.
Leaf Hold	H	N/A	N/A	H Holds all leaf cells.
Release Leaf Hold	RH	N/A	N/A	RH Releases all leaf holds.
Consolidation Hold	HC	N/A	N/A	HC Holds all consolidated cells.
Release Consolidation Hold	RC	N/A	N/A	RC Releases all holds of consolidated cells.
Release All Holds	RA	N/A	N/A	RA Releases all holds on the cells.

* The default data action is Replace. The spreading syntax uses a tilde (~) to denote the Subtract data action, and a plus sign (+) to denote the Add data action.